PREVIEW / etf_30min / 2008-01-22

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-01-22.parquet
  size:    171 KB
  rows:    6,186

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-01-22 04:00:00	SPY	ETF	125.74	125.99	125.15	125.53	74800.0
2008-01-22 04:30:00	SPY	ETF	125.15	125.97	125.15	125.97	48900.0
2008-01-22 05:00:00	SPY	ETF	125.9	125.96	125.0	125.0	22800.0
2008-01-22 05:30:00	SPY	ETF	125.25	125.78	125.25	125.78	34500.0
2008-01-22 06:00:00	SPY	ETF	125.86	126.5	125.83	126.12	312400.0
2008-01-22 06:30:00	SPY	ETF	126.14	126.87	126.14	126.5	746600.0
2008-01-22 07:00:00	SPY	ETF	126.5	126.55	125.29	125.72	2134500.0
2008-01-22 07:30:00	SPY	ETF	125.64	126.25	125.45	125.73	4085700.0
2008-01-22 08:00:00	SPY	ETF	125.71	131.3	125.36	127.77	21902371.0
2008-01-22 08:30:00	SPY	ETF	127.76	128.53	125.48	126.64	13582647.0
2008-01-22 09:00:00	SPY	ETF	126.57	127.29	126.15	126.46	6113328.0
2008-01-22 09:30:00	SPY	ETF	126.4	129.86	126.0	128.53	55111484.0
2008-01-22 10:00:00	SPY	ETF	128.54	130.76	128.37	130.44	42722144.0
2008-01-22 10:30:00	SPY	ETF	130.44	132.4266	129.91	130.44	41093022.0
2008-01-22 11:00:00	SPY	ETF	130.403	132.25	130.39	130.75	36455999.0
2008-01-22 11:30:00	SPY	ETF	130.77	131.52	129.9	130.13	21542042.0
2008-01-22 12:00:00	SPY	ETF	130.13	131.28	129.98	130.64	15798735.0
2008-01-22 12:30:00	SPY	ETF	130.63	131.19	130.22	131.14	10407355.0
2008-01-22 13:00:00	SPY	ETF	131.15	131.9	130.72	131.0	21696018.0
2008-01-22 13:30:00	SPY	ETF	131.0	132.4266	130.3	130.75	30819956.0
2008-01-22 14:00:00	SPY	ETF	130.76	131.59	130.07	130.72	17740222.0
2008-01-22 14:30:00	SPY	ETF	130.7	131.17	130.13	130.84	16850508.0
2008-01-22 15:00:00	SPY	ETF	130.85	132.4266	130.6	131.07	25549251.0
2008-01-22 15:30:00	SPY	ETF	131.07	132.21	130.75	131.02	33908450.0
2008-01-22 16:00:00	SPY	ETF	130.97	131.07	129.2396	130.74	5283400.0
2008-01-22 16:30:00	SPY	ETF	130.74	131.75	129.45	129.89	4089300.0
2008-01-22 17:00:00	SPY	ETF	129.84	131.04	129.73	129.8	269100.0
2008-01-22 17:30:00	SPY	ETF	129.8	129.94	129.8	129.88	321500.0
2008-01-22 18:00:00	SPY	ETF	129.88	130.72	129.82	130.07	67200.0
2008-01-22 18:30:00	SPY	ETF	130.08	130.39	130.08	130.35	64500.0
2008-01-22 19:00:00	SPY	ETF	130.35	130.52	130.28	130.41	28400.0
2008-01-22 19:30:00	SPY	ETF	130.42	130.48	130.24	130.42	23900.0
2008-01-22 04:00:00	QQQ	ETF	43.04	43.07	42.77	42.94	19875.0
2008-01-22 04:30:00	QQQ	ETF	42.8	43.11	42.8	43.1	124000.0
2008-01-22 05:00:00	QQQ	ETF	43.17	43.25	42.98	42.98	25300.0
2008-01-22 05:30:00	QQQ	ETF	42.89	43.02	42.89	43.02	7600.0
2008-01-22 06:00:00	QQQ	ETF	43.18	43.33	43.18	43.33	7737.0
2008-01-22 06:30:00	QQQ	ETF	43.3	43.66	43.3	43.48	203000.0
2008-01-22 07:00:00	QQQ	ETF	43.5	43.51	43.11	43.26	737143.0
2008-01-22 07:30:00	QQQ	ETF	43.26	43.53	43.23	43.29	1555557.0
2008-01-22 08:00:00	QQQ	ETF	43.32	44.58	43.0	43.97	10822842.0
2008-01-22 08:30:00	QQQ	ETF	43.97	44.36	43.2	43.31	7959213.0
2008-01-22 09:00:00	QQQ	ETF	43.3	45.5	42.84	42.84	4820947.0
2008-01-22 09:30:00	QQQ	ETF	42.83	44.21	42.73	43.82	52132320.0
2008-01-22 10:00:00	QQQ	ETF	43.82	44.45	43.7	44.29	31453977.0
2008-01-22 10:30:00	QQQ	ETF	44.29	44.39	43.91	44.09	25612109.0
2008-01-22 11:00:00	QQQ	ETF	44.1	44.67	44.088	44.22	26932659.0
2008-01-22 11:30:00	QQQ	ETF	44.21	44.219	43.9	44.01	19703872.0
2008-01-22 12:00:00	QQQ	ETF	44.01	44.45	43.95	44.14	19714664.0
2008-01-22 12:30:00	QQQ	ETF	44.13	44.34	44.03	44.3399	9535173.0

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

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