PREVIEW / etf_30min / 2001-08-01

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-08-01.parquet
  size:    15 KB
  rows:    370

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
2001-08-01 09:30:00	SPY	ETF	121.97	122.0	121.55	121.96	1250700.0
2001-08-01 10:00:00	SPY	ETF	121.97	122.34	121.85	122.25	1128800.0
2001-08-01 10:30:00	SPY	ETF	122.25	122.47	122.1	122.19	447300.0
2001-08-01 11:00:00	SPY	ETF	122.24	122.52	122.22	122.37	1047300.0
2001-08-01 11:30:00	SPY	ETF	122.37	122.42	122.18	122.35	967800.0
2001-08-01 12:00:00	SPY	ETF	122.36	122.69	122.32	122.67	546300.0
2001-08-01 12:30:00	SPY	ETF	122.67	122.7	122.5	122.55	373000.0
2001-08-01 13:00:00	SPY	ETF	122.57	122.58	122.36	122.41	418700.0
2001-08-01 13:30:00	SPY	ETF	122.41	122.49	122.22	122.3	492700.0
2001-08-01 14:00:00	SPY	ETF	122.29	122.3	121.87	121.94	896100.0
2001-08-01 14:30:00	SPY	ETF	121.94	122.05	121.57	121.68	894200.0
2001-08-01 15:00:00	SPY	ETF	121.68	122.15	121.64	121.98	1215200.0
2001-08-01 15:30:00	SPY	ETF	121.98	122.05	121.59	121.96	1048100.0
2001-08-01 16:00:00	SPY	ETF	121.95	122.14	121.95	122.11	915200.0
2001-08-01 16:30:00	SPY	ETF	122.11	122.12	122.0	122.12	48200.0
2001-08-01 17:00:00	SPY	ETF	122.13	122.13	122.1	122.1	400.0
2001-08-01 18:00:00	SPY	ETF	122.3	122.3	122.18	122.18	1000.0
2001-08-01 09:30:00	QQQ	ETF	42.63	42.85	42.41	42.83	8149200.0
2001-08-01 10:00:00	QQQ	ETF	42.84	43.15	42.7	42.96	7210600.0
2001-08-01 10:30:00	QQQ	ETF	42.95	43.19	42.84	42.94	3458200.0
2001-08-01 11:00:00	QQQ	ETF	42.95	43.21	42.92	43.06	3117700.0
2001-08-01 11:30:00	QQQ	ETF	43.06	43.14	42.95	43.13	1755900.0
2001-08-01 12:00:00	QQQ	ETF	43.15	43.44	43.09	43.44	3246000.0
2001-08-01 12:30:00	QQQ	ETF	43.44	43.5	43.33	43.36	2188600.0
2001-08-01 13:00:00	QQQ	ETF	43.37	43.39	43.17	43.22	2062800.0
2001-08-01 13:30:00	QQQ	ETF	43.23	43.31	43.01	43.1	3666900.0
2001-08-01 14:00:00	QQQ	ETF	43.14	43.15	42.82	42.92	3596600.0
2001-08-01 14:30:00	QQQ	ETF	42.92	43.05	42.66	42.73	3436400.0
2001-08-01 15:00:00	QQQ	ETF	42.75	43.17	42.72	43.06	3040200.0
2001-08-01 15:30:00	QQQ	ETF	43.08	43.14	42.81	43.05	3473600.0
2001-08-01 16:00:00	QQQ	ETF	43.04	43.16	43.0	43.16	1147100.0
2001-08-01 16:30:00	QQQ	ETF	43.15	43.22	43.02	43.18	56800.0
2001-08-01 17:00:00	QQQ	ETF	43.19	43.2	43.1	43.16	22600.0
2001-08-01 17:30:00	QQQ	ETF	43.14	43.22	43.09	43.18	18900.0
2001-08-01 18:00:00	QQQ	ETF	43.24	43.24	43.17	43.17	2800.0
2001-08-01 09:30:00	IWM	ETF	48.525	48.525	48.225	48.495	38000.0
2001-08-01 10:00:00	IWM	ETF	48.5	48.58	48.5	48.54	6800.0
2001-08-01 10:30:00	IWM	ETF	48.565	48.695	48.55	48.64	8800.0
2001-08-01 11:00:00	IWM	ETF	48.64	48.82	48.64	48.8	33600.0
2001-08-01 11:30:00	IWM	ETF	48.825	48.825	48.75	48.79	6600.0
2001-08-01 12:00:00	IWM	ETF	48.85	48.85	48.85	48.85	2400.0
2001-08-01 12:30:00	IWM	ETF	48.9	48.9	48.9	48.9	2000.0
2001-08-01 13:00:00	IWM	ETF	48.8	48.85	48.75	48.84	38400.0
2001-08-01 13:30:00	IWM	ETF	48.65	48.845	48.65	48.73	211800.0
2001-08-01 14:00:00	IWM	ETF	48.63	48.795	48.56	48.56	5000.0
2001-08-01 14:30:00	IWM	ETF	48.7	48.715	48.555	48.555	9000.0
2001-08-01 15:00:00	IWM	ETF	48.6	48.75	48.525	48.75	24200.0
2001-08-01 15:30:00	IWM	ETF	48.75	48.795	48.65	48.795	32600.0
2001-08-01 16:00:00	IWM	ETF	48.75	48.85	48.75	48.85	7600.0
2001-08-01 09:30:00	DIA	ETF	105.78	105.78	105.27	105.64	357400.0

> showing 50 of 370 rows — these rows as CSV

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