PREVIEW / etf_30min / 2001-06-19

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-06-19.parquet
  size:    15 KB
  rows:    372

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-06-19 09:30:00	SPY	ETF	122.38	122.89	122.0	122.54	1304400.0
2001-06-19 10:00:00	SPY	ETF	122.5	122.74	122.19	122.34	717100.0
2001-06-19 10:30:00	SPY	ETF	122.26	122.47	121.81	121.84	574700.0
2001-06-19 11:00:00	SPY	ETF	121.8	121.88	121.38	121.64	684200.0
2001-06-19 11:30:00	SPY	ETF	121.62	121.83	121.46	121.83	357100.0
2001-06-19 12:00:00	SPY	ETF	121.83	122.09	121.77	122.0	561700.0
2001-06-19 12:30:00	SPY	ETF	121.94	122.14	121.79	122.05	199900.0
2001-06-19 13:00:00	SPY	ETF	122.09	122.25	121.86	121.95	203000.0
2001-06-19 13:30:00	SPY	ETF	122.0	122.13	121.66	121.8	213800.0
2001-06-19 14:00:00	SPY	ETF	121.77	121.94	121.6	121.91	429600.0
2001-06-19 14:30:00	SPY	ETF	121.93	121.99	121.15	121.28	308700.0
2001-06-19 15:00:00	SPY	ETF	121.22	121.47	120.89	120.98	568000.0
2001-06-19 15:30:00	SPY	ETF	121.0	121.53	120.94	121.46	662300.0
2001-06-19 16:00:00	SPY	ETF	121.41	122.48	121.17	121.17	602400.0
2001-06-19 16:30:00	SPY	ETF	121.07	121.7	121.07	121.7	1500.0
2001-06-19 17:00:00	SPY	ETF	121.55	121.55	121.5	121.5	1100.0
2001-06-19 09:30:00	QQQ	ETF	43.32	43.56	42.99	43.05	11635000.0
2001-06-19 10:00:00	QQQ	ETF	43.05	43.25	42.72	42.88	8240600.0
2001-06-19 10:30:00	QQQ	ETF	42.9	43.1	42.58	42.6	5530200.0
2001-06-19 11:00:00	QQQ	ETF	42.6	42.7	42.15	42.43	7828500.0
2001-06-19 11:30:00	QQQ	ETF	42.44	42.65	42.31	42.65	4802500.0
2001-06-19 12:00:00	QQQ	ETF	42.67	42.85	42.63	42.77	3778000.0
2001-06-19 12:30:00	QQQ	ETF	42.76	42.86	42.55	42.55	2232000.0
2001-06-19 13:00:00	QQQ	ETF	42.62	42.81	42.45	42.5	1837800.0
2001-06-19 13:30:00	QQQ	ETF	42.5	42.63	42.15	42.24	3074800.0
2001-06-19 14:00:00	QQQ	ETF	42.24	42.34	41.93	42.22	4231500.0
2001-06-19 14:30:00	QQQ	ETF	42.22	42.26	41.58	41.6	5105000.0
2001-06-19 15:00:00	QQQ	ETF	41.62	41.82	41.28	41.3	4546400.0
2001-06-19 15:30:00	QQQ	ETF	41.31	41.81	41.26	41.79	5548800.0
2001-06-19 16:00:00	QQQ	ETF	41.8	42.33	41.5	41.95	2340900.0
2001-06-19 16:30:00	QQQ	ETF	41.9	41.96	41.58	41.7	138500.0
2001-06-19 17:00:00	QQQ	ETF	41.7	41.82	41.59	41.61	51100.0
2001-06-19 17:30:00	QQQ	ETF	41.69	41.7	41.58	41.7	6900.0
2001-06-19 18:00:00	QQQ	ETF	41.6	41.65	41.56	41.6	10600.0
2001-06-19 09:30:00	IWM	ETF	49.5	49.55	49.35	49.53	97800.0
2001-06-19 10:00:00	IWM	ETF	49.525	49.525	49.2	49.2	50200.0
2001-06-19 10:30:00	IWM	ETF	49.18	49.35	49.15	49.18	57400.0
2001-06-19 11:00:00	IWM	ETF	49.09	49.1	48.905	48.925	38400.0
2001-06-19 11:30:00	IWM	ETF	48.93	49.0	48.91	48.94	39400.0
2001-06-19 12:00:00	IWM	ETF	48.94	48.98	48.94	48.975	36200.0
2001-06-19 12:30:00	IWM	ETF	49.0	49.0	48.9	48.97	31600.0
2001-06-19 13:00:00	IWM	ETF	48.975	49.04	48.945	49.04	32600.0
2001-06-19 13:30:00	IWM	ETF	49.03	49.055	48.925	48.925	29600.0
2001-06-19 14:00:00	IWM	ETF	48.94	49.05	48.825	49.05	59600.0
2001-06-19 14:30:00	IWM	ETF	49.05	49.05	48.605	48.745	69400.0
2001-06-19 15:00:00	IWM	ETF	48.755	48.78	48.59	48.68	75000.0
2001-06-19 15:30:00	IWM	ETF	48.665	48.77	48.6	48.69	90200.0
2001-06-19 16:00:00	IWM	ETF	48.7	48.85	48.7	48.85	49600.0
2001-06-19 09:30:00	DIA	ETF	107.25	107.56	107.11	107.11	395500.0
2001-06-19 10:00:00	DIA	ETF	107.2	107.35	106.85	106.98	164100.0

> showing 50 of 372 rows — these rows as CSV

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