PREVIEW / etf_30min / 2002-05-01

all etf 30-min files

  file:    by_date/etf_30min/2002/2002-05-01.parquet
  size:    19 KB
  rows:    499

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
2002-05-01 09:30:00	SPY	ETF	107.97	108.13	107.58	107.63	1913200.0
2002-05-01 10:00:00	SPY	ETF	107.58	107.63	106.8	107.07	2915500.0
2002-05-01 10:30:00	SPY	ETF	107.04	107.31	106.87	107.28	1838000.0
2002-05-01 11:00:00	SPY	ETF	107.27	107.39	106.91	106.93	1641900.0
2002-05-01 11:30:00	SPY	ETF	106.93	107.38	106.9	107.34	787900.0
2002-05-01 12:00:00	SPY	ETF	107.35	107.48	107.2	107.36	1373900.0
2002-05-01 12:30:00	SPY	ETF	107.37	107.84	107.37	107.59	1319700.0
2002-05-01 13:00:00	SPY	ETF	107.62	107.8	107.44	107.74	606100.0
2002-05-01 13:30:00	SPY	ETF	107.79	108.6	107.78	108.33	3113000.0
2002-05-01 14:00:00	SPY	ETF	108.3	109.0	108.21	108.87	2597500.0
2002-05-01 14:30:00	SPY	ETF	108.88	108.94	108.59	108.83	1293000.0
2002-05-01 15:00:00	SPY	ETF	108.85	109.25	108.77	109.07	1594100.0
2002-05-01 15:30:00	SPY	ETF	109.08	109.15	108.79	108.96	1480000.0
2002-05-01 16:00:00	SPY	ETF	108.95	109.93	108.92	109.15	1626900.0
2002-05-01 16:30:00	SPY	ETF	109.21	109.23	109.21	109.21	2500.0
2002-05-01 17:30:00	SPY	ETF	109.19	109.35	109.13	109.35	4900.0
2002-05-01 18:00:00	SPY	ETF	109.3	109.34	109.05	109.34	600.0
2002-05-01 09:30:00	QQQ	ETF	31.67	31.69	31.24	31.27	8681300.0
2002-05-01 10:00:00	QQQ	ETF	31.27	31.31	30.78	30.84	15994600.0
2002-05-01 10:30:00	QQQ	ETF	30.85	31.05	30.72	31.0	15143500.0
2002-05-01 11:00:00	QQQ	ETF	31.02	31.02	30.65	30.66	5838600.0
2002-05-01 11:30:00	QQQ	ETF	30.66	30.93	30.65	30.88	4691700.0
2002-05-01 12:00:00	QQQ	ETF	30.88	30.99	30.83	30.94	2502800.0
2002-05-01 12:30:00	QQQ	ETF	30.94	31.16	30.91	30.92	5583700.0
2002-05-01 13:00:00	QQQ	ETF	30.93	31.05	30.8	31.01	3289800.0
2002-05-01 13:30:00	QQQ	ETF	31.02	31.41	31.01	31.27	9680000.0
2002-05-01 14:00:00	QQQ	ETF	31.25	31.7	31.2	31.65	9476800.0
2002-05-01 14:30:00	QQQ	ETF	31.68	31.69	31.43	31.6	7966900.0
2002-05-01 15:00:00	QQQ	ETF	31.6	31.84	31.58	31.77	9716100.0
2002-05-01 15:30:00	QQQ	ETF	31.75	31.79	31.42	31.56	7751200.0
2002-05-01 16:00:00	QQQ	ETF	31.49	31.81	30.88	30.88	2786500.0
2002-05-01 16:30:00	QQQ	ETF	31.55	31.58	31.49	31.57	116600.0
2002-05-01 17:00:00	QQQ	ETF	31.55	31.59	31.5	31.59	21600.0
2002-05-01 17:30:00	QQQ	ETF	31.57	31.57	31.53	31.55	27800.0
2002-05-01 18:00:00	QQQ	ETF	31.55	31.58	31.54	31.54	18500.0
2002-05-01 09:30:00	IWM	ETF	50.75	50.75	50.515	50.515	179800.0
2002-05-01 10:00:00	IWM	ETF	50.58	50.58	50.01	50.075	166600.0
2002-05-01 10:30:00	IWM	ETF	50.065	50.15	49.98	50.15	70000.0
2002-05-01 11:00:00	IWM	ETF	50.175	50.25	50.11	50.11	74800.0
2002-05-01 11:30:00	IWM	ETF	50.11	50.285	50.11	50.24	70600.0
2002-05-01 12:00:00	IWM	ETF	50.285	50.4	50.28	50.375	37000.0
2002-05-01 12:30:00	IWM	ETF	50.39	50.57	50.35	50.565	15000.0
2002-05-01 13:00:00	IWM	ETF	50.51	50.51	50.43	50.48	19600.0
2002-05-01 13:30:00	IWM	ETF	50.48	50.78	50.48	50.725	240800.0
2002-05-01 14:00:00	IWM	ETF	50.75	50.875	50.685	50.875	168200.0
2002-05-01 14:30:00	IWM	ETF	50.97	50.97	50.82	50.875	106600.0
2002-05-01 15:00:00	IWM	ETF	50.895	50.98	50.875	50.98	164600.0
2002-05-01 15:30:00	IWM	ETF	50.975	50.98	50.8	50.86	95800.0
2002-05-01 16:00:00	IWM	ETF	50.735	51.0	50.735	51.0	18200.0
2002-05-01 09:30:00	DIA	ETF	99.64	99.82	99.31	99.38	617800.0

> showing 50 of 499 rows — these rows as CSV

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