PREVIEW / etf_30min / 2008-10-07

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-10-07.parquet
  size:    188 KB
  rows:    6,561

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2008-10-07 04:00:00	SPY	ETF	105.07	105.07	105.07	105.07	200.0
2008-10-07 05:00:00	SPY	ETF	104.86	104.88	104.86	104.88	5000.0
2008-10-07 05:30:00	SPY	ETF	104.88	104.92	104.75	104.75	9100.0
2008-10-07 06:00:00	SPY	ETF	105.07	106.13	105.07	106.13	99100.0
2008-10-07 06:30:00	SPY	ETF	105.81	106.15	105.57	106.15	15800.0
2008-10-07 07:00:00	SPY	ETF	106.13	106.19	105.77	105.8	466610.0
2008-10-07 07:30:00	SPY	ETF	105.77	106.2	105.58	106.08	526590.0
2008-10-07 08:00:00	SPY	ETF	106.07	106.832	104.45	104.7	5333084.0
2008-10-07 08:30:00	SPY	ETF	104.7	106.28	104.03	104.46	4279918.0
2008-10-07 09:00:00	SPY	ETF	104.46	107.31	104.46	106.82	20510369.0
2008-10-07 09:30:00	SPY	ETF	106.84	107.33	105.05	105.69	58913691.0
2008-10-07 10:00:00	SPY	ETF	105.69	106.29	104.69	106.238	39703224.0
2008-10-07 10:30:00	SPY	ETF	106.23	106.41	105.33	105.64	25069940.0
2008-10-07 11:00:00	SPY	ETF	105.65	105.78	104.43	104.87	23703345.0
2008-10-07 11:30:00	SPY	ETF	104.87	105.79	104.8	105.16	22931143.0
2008-10-07 12:00:00	SPY	ETF	105.17	105.25	103.83	104.12	23025728.0
2008-10-07 12:30:00	SPY	ETF	104.11	104.3	103.07	103.49	23034405.0
2008-10-07 13:00:00	SPY	ETF	103.48	104.44	102.26	102.69	37822001.0
2008-10-07 13:30:00	SPY	ETF	102.7	103.52	101.43	101.55	45205240.0
2008-10-07 14:00:00	SPY	ETF	101.54	103.51	101.25	103.12	53590940.0
2008-10-07 14:30:00	SPY	ETF	103.12	103.85	102.02	102.17	32957877.0
2008-10-07 15:00:00	SPY	ETF	102.17	102.4	100.78	101.55	39181336.0
2008-10-07 15:30:00	SPY	ETF	101.55	101.96	99.65	99.79	57057831.0
2008-10-07 16:00:00	SPY	ETF	99.81	105.6276	99.57	99.75	16005803.0
2008-10-07 16:30:00	SPY	ETF	99.75	100.42	99.75	100.1	5432808.0
2008-10-07 17:00:00	SPY	ETF	100.05	100.19	99.9	100.19	1203553.0
2008-10-07 17:30:00	SPY	ETF	100.15	100.15	99.57	100.07	1229360.0
2008-10-07 18:00:00	SPY	ETF	100.07	100.4	100.05	100.24	128294.0
2008-10-07 18:30:00	SPY	ETF	100.32	100.43	100.14	100.2	24696.0
2008-10-07 19:00:00	SPY	ETF	100.25	100.25	99.94	100.0	56858.0
2008-10-07 19:30:00	SPY	ETF	99.95	100.01	99.56	99.7	43987.0
2008-10-07 20:00:00	SPY	ETF	99.71	99.71	99.71	99.71	100.0
2008-10-07 04:30:00	QQQ	ETF	34.27	34.48	34.27	34.48	3090.0
2008-10-07 05:00:00	QQQ	ETF	34.42	34.5	34.42	34.48	4900.0
2008-10-07 05:30:00	QQQ	ETF	34.55	34.55	34.4	34.4	7300.0
2008-10-07 06:00:00	QQQ	ETF	34.4	34.7	34.4	34.69	6900.0
2008-10-07 06:30:00	QQQ	ETF	34.73	34.82	34.64	34.82	2292.0
2008-10-07 07:00:00	QQQ	ETF	34.78	34.95	34.75	34.84	460600.0
2008-10-07 07:30:00	QQQ	ETF	34.84	34.85	34.66	34.84	799059.0
2008-10-07 08:00:00	QQQ	ETF	34.84	34.89	34.38	34.42	2230769.0
2008-10-07 08:30:00	QQQ	ETF	34.43	34.59	34.04	34.26	2025885.0
2008-10-07 09:00:00	QQQ	ETF	34.27	35.23	34.27	35.14	9751196.0
2008-10-07 09:30:00	QQQ	ETF	35.15	35.2	34.28	34.49	40998195.0
2008-10-07 10:00:00	QQQ	ETF	34.5	35.1	34.16	34.8099	30830972.0
2008-10-07 10:30:00	QQQ	ETF	34.81	34.94	34.51	34.6	14454596.0
2008-10-07 11:00:00	QQQ	ETF	34.6	34.7	34.23	34.37	10740851.0
2008-10-07 11:30:00	QQQ	ETF	34.38	34.65	34.32	34.52	10722954.0
2008-10-07 12:00:00	QQQ	ETF	34.52	34.5201	33.962	34.04	10673531.0
2008-10-07 12:30:00	QQQ	ETF	34.05	34.14	33.73	33.94	15620574.0
2008-10-07 13:00:00	QQQ	ETF	33.94	34.33	33.55	33.68	18643518.0

> showing 50 of 6,561 rows — these rows as CSV

> unlock the full archive -- $79 one-time