PREVIEW / etf_30min / 2001-07-05

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-07-05.parquet
  size:    15 KB
  rows:    373

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-07-05 09:30:00	SPY	ETF	123.07	123.39	122.93	123.01	1002200.0
2001-07-05 10:00:00	SPY	ETF	123.02	123.65	122.96	123.49	653300.0
2001-07-05 10:30:00	SPY	ETF	123.48	123.5	122.87	123.02	303600.0
2001-07-05 11:00:00	SPY	ETF	123.05	123.17	122.6	122.75	388100.0
2001-07-05 11:30:00	SPY	ETF	122.75	122.75	122.27	122.29	458800.0
2001-07-05 12:00:00	SPY	ETF	122.37	122.68	122.3	122.53	221800.0
2001-07-05 12:30:00	SPY	ETF	122.46	122.69	122.46	122.59	62200.0
2001-07-05 13:00:00	SPY	ETF	122.53	122.53	122.32	122.39	107500.0
2001-07-05 13:30:00	SPY	ETF	122.39	122.49	122.25	122.32	130500.0
2001-07-05 14:00:00	SPY	ETF	122.39	122.73	122.39	122.68	186800.0
2001-07-05 14:30:00	SPY	ETF	122.69	122.7	122.41	122.47	142200.0
2001-07-05 15:00:00	SPY	ETF	122.53	122.6	122.31	122.42	253800.0
2001-07-05 15:30:00	SPY	ETF	122.42	122.54	122.11	122.13	710700.0
2001-07-05 16:00:00	SPY	ETF	122.13	122.19	121.66	121.68	719700.0
2001-07-05 16:30:00	SPY	ETF	121.74	122.37	121.74	122.37	4100.0
2001-07-05 17:00:00	SPY	ETF	121.7	122.37	121.5	121.5	7600.0
2001-07-05 17:30:00	SPY	ETF	121.5	121.79	120.51	121.0	4100.0
2001-07-05 18:00:00	SPY	ETF	121.12	121.3	120.3	121.3	3100.0
2001-07-05 09:30:00	QQQ	ETF	44.87	45.1	44.72	44.72	6577600.0
2001-07-05 10:00:00	QQQ	ETF	44.74	45.18	44.7	45.01	4726400.0
2001-07-05 10:30:00	QQQ	ETF	45.0	45.04	44.63	44.73	4018600.0
2001-07-05 11:00:00	QQQ	ETF	44.72	44.84	44.41	44.56	2848000.0
2001-07-05 11:30:00	QQQ	ETF	44.57	44.61	44.15	44.19	3642600.0
2001-07-05 12:00:00	QQQ	ETF	44.18	44.38	44.13	44.15	2169100.0
2001-07-05 12:30:00	QQQ	ETF	44.16	44.35	44.14	44.27	1347600.0
2001-07-05 13:00:00	QQQ	ETF	44.26	44.3	44.0	44.04	2332800.0
2001-07-05 13:30:00	QQQ	ETF	44.03	44.13	43.95	44.03	1774100.0
2001-07-05 14:00:00	QQQ	ETF	44.07	44.24	44.01	44.21	1785000.0
2001-07-05 14:30:00	QQQ	ETF	44.2	44.23	44.04	44.07	1322400.0
2001-07-05 15:00:00	QQQ	ETF	44.07	44.15	43.87	43.94	2606600.0
2001-07-05 15:30:00	QQQ	ETF	43.95	44.06	43.65	43.66	4401400.0
2001-07-05 16:00:00	QQQ	ETF	43.66	43.72	43.14	43.45	2644900.0
2001-07-05 16:30:00	QQQ	ETF	43.47	43.55	43.35	43.4	187700.0
2001-07-05 17:00:00	QQQ	ETF	43.4	43.4	42.65	42.86	316100.0
2001-07-05 17:30:00	QQQ	ETF	42.85	42.95	42.69	42.69	92000.0
2001-07-05 18:00:00	QQQ	ETF	42.77	42.8	42.69	42.79	30900.0
2001-07-05 18:30:00	QQQ	ETF	42.75	42.75	42.75	42.75	100.0
2001-07-05 09:30:00	IWM	ETF	49.0	49.25	49.0	49.175	126600.0
2001-07-05 10:00:00	IWM	ETF	49.14	49.495	49.14	49.345	69400.0
2001-07-05 10:30:00	IWM	ETF	49.345	49.425	49.265	49.265	53600.0
2001-07-05 11:00:00	IWM	ETF	49.335	49.35	49.195	49.24	67000.0
2001-07-05 11:30:00	IWM	ETF	49.24	49.25	49.15	49.23	219200.0
2001-07-05 12:00:00	IWM	ETF	49.15	49.3	49.15	49.2	29200.0
2001-07-05 12:30:00	IWM	ETF	49.2	49.26	49.2	49.26	12200.0
2001-07-05 13:00:00	IWM	ETF	49.205	49.29	49.2	49.25	43400.0
2001-07-05 13:30:00	IWM	ETF	49.225	49.25	49.185	49.245	11600.0
2001-07-05 14:00:00	IWM	ETF	49.25	49.34	49.225	49.255	133400.0
2001-07-05 14:30:00	IWM	ETF	49.32	49.34	49.25	49.25	2200.0
2001-07-05 15:00:00	IWM	ETF	49.2	49.225	49.175	49.195	12400.0
2001-07-05 15:30:00	IWM	ETF	49.175	49.19	48.83	48.975	41800.0

> showing 50 of 373 rows — these rows as CSV

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