PREVIEW / etf_30min / 2002-04-01

all etf 30-min files

  file:    by_date/etf_30min/2002/2002-04-01.parquet
  size:    19 KB
  rows:    505

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-04-01 09:30:00	SPY	ETF	114.23	114.32	113.82	113.91	1899000.0
2002-04-01 10:00:00	SPY	ETF	113.9	114.15	113.5	113.73	2419600.0
2002-04-01 10:30:00	SPY	ETF	113.71	113.92	113.55	113.61	740000.0
2002-04-01 11:00:00	SPY	ETF	113.62	113.86	113.58	113.82	1533100.0
2002-04-01 11:30:00	SPY	ETF	113.8	113.91	113.68	113.82	361400.0
2002-04-01 12:00:00	SPY	ETF	113.87	114.13	113.78	114.04	707400.0
2002-04-01 12:30:00	SPY	ETF	114.08	114.2	114.0	114.04	544500.0
2002-04-01 13:00:00	SPY	ETF	114.02	114.45	114.0	114.44	618300.0
2002-04-01 13:30:00	SPY	ETF	114.45	114.58	114.33	114.53	982900.0
2002-04-01 14:00:00	SPY	ETF	114.51	114.55	114.32	114.39	698500.0
2002-04-01 14:30:00	SPY	ETF	114.41	114.87	114.37	114.75	1151000.0
2002-04-01 15:00:00	SPY	ETF	114.8	115.1	114.71	114.9	1184900.0
2002-04-01 15:30:00	SPY	ETF	114.9	115.03	114.72	114.83	1039200.0
2002-04-01 16:00:00	SPY	ETF	114.84	114.86	114.5	114.58	3564100.0
2002-04-01 16:30:00	SPY	ETF	114.58	114.59	114.55	114.59	3400.0
2002-04-01 17:00:00	SPY	ETF	114.53	114.53	114.53	114.53	100.0
2002-04-01 17:30:00	SPY	ETF	114.52	114.52	114.52	114.52	300.0
2002-04-01 18:00:00	SPY	ETF	114.52	114.52	114.52	114.52	2700.0
2002-04-01 09:30:00	QQQ	ETF	35.8	35.83	35.53	35.68	7387400.0
2002-04-01 10:00:00	QQQ	ETF	35.69	35.82	35.46	35.67	10019300.0
2002-04-01 10:30:00	QQQ	ETF	35.66	35.9	35.63	35.63	5913800.0
2002-04-01 11:00:00	QQQ	ETF	35.69	35.82	35.65	35.79	1838300.0
2002-04-01 11:30:00	QQQ	ETF	35.79	35.84	35.72	35.77	1834000.0
2002-04-01 12:00:00	QQQ	ETF	35.76	36.03	35.75	35.96	3352200.0
2002-04-01 12:30:00	QQQ	ETF	35.96	36.17	35.93	36.07	4715300.0
2002-04-01 13:00:00	QQQ	ETF	36.06	36.37	36.05	36.37	4525800.0
2002-04-01 13:30:00	QQQ	ETF	36.34	36.48	36.27	36.47	4980900.0
2002-04-01 14:00:00	QQQ	ETF	36.47	36.48	36.34	36.37	3675900.0
2002-04-01 14:30:00	QQQ	ETF	36.38	36.71	36.35	36.67	5205500.0
2002-04-01 15:00:00	QQQ	ETF	36.65	36.9	36.62	36.72	6898800.0
2002-04-01 15:30:00	QQQ	ETF	36.71	36.8	36.56	36.77	5850500.0
2002-04-01 16:00:00	QQQ	ETF	36.76	36.78	36.34	36.71	2588100.0
2002-04-01 16:30:00	QQQ	ETF	36.75	36.8	36.71	36.74	27000.0
2002-04-01 17:00:00	QQQ	ETF	36.74	36.77	36.72	36.74	14800.0
2002-04-01 17:30:00	QQQ	ETF	36.74	36.74	36.7	36.72	16800.0
2002-04-01 18:00:00	QQQ	ETF	36.7	36.71	36.68	36.71	7500.0
2002-04-01 09:30:00	IWM	ETF	50.05	50.12	49.725	49.87	133600.0
2002-04-01 10:00:00	IWM	ETF	49.8	49.88	49.595	49.725	118800.0
2002-04-01 10:30:00	IWM	ETF	49.74	49.74	49.605	49.605	123200.0
2002-04-01 11:00:00	IWM	ETF	49.53	49.7	49.53	49.685	78400.0
2002-04-01 11:30:00	IWM	ETF	49.69	49.735	49.635	49.7	87200.0
2002-04-01 12:00:00	IWM	ETF	49.755	49.845	49.705	49.845	2600.0
2002-04-01 12:30:00	IWM	ETF	49.8	49.88	49.8	49.85	120200.0
2002-04-01 13:00:00	IWM	ETF	49.875	49.94	49.835	49.9	23000.0
2002-04-01 13:30:00	IWM	ETF	49.945	50.15	49.93	50.03	69800.0
2002-04-01 14:00:00	IWM	ETF	50.105	50.105	50.02	50.035	117400.0
2002-04-01 14:30:00	IWM	ETF	50.03	50.255	50.025	50.255	95800.0
2002-04-01 15:00:00	IWM	ETF	50.205	50.415	50.2	50.23	195200.0
2002-04-01 15:30:00	IWM	ETF	50.22	50.31	50.105	50.15	110000.0
2002-04-01 16:00:00	IWM	ETF	50.22	50.22	50.085	50.085	8000.0

> showing 50 of 505 rows — these rows as CSV

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