PREVIEW / etf_30min / 2001-06-27

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-06-27.parquet
  size:    15 KB
  rows:    376

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-27 09:30:00	SPY	ETF	121.6	121.88	121.38	121.71	669400.0
2001-06-27 10:00:00	SPY	ETF	121.7	122.06	121.6	122.06	281500.0
2001-06-27 10:30:00	SPY	ETF	122.02	122.24	122.0	122.07	578400.0
2001-06-27 11:00:00	SPY	ETF	122.07	122.23	121.98	122.05	354900.0
2001-06-27 11:30:00	SPY	ETF	122.1	122.22	122.06	122.09	309300.0
2001-06-27 12:00:00	SPY	ETF	122.07	122.18	121.95	122.01	245100.0
2001-06-27 12:30:00	SPY	ETF	122.01	122.19	121.97	122.05	176000.0
2001-06-27 13:00:00	SPY	ETF	122.04	122.19	122.0	122.0	384100.0
2001-06-27 13:30:00	SPY	ETF	122.07	122.09	121.85	121.94	679700.0
2001-06-27 14:00:00	SPY	ETF	121.9	122.04	120.99	121.2	1894700.0
2001-06-27 14:30:00	SPY	ETF	121.2	122.06	120.91	121.93	1430900.0
2001-06-27 15:00:00	SPY	ETF	121.99	122.22	121.64	121.8	1672200.0
2001-06-27 15:30:00	SPY	ETF	121.76	121.85	121.34	121.35	659900.0
2001-06-27 16:00:00	SPY	ETF	121.31	122.42	120.54	121.8	521200.0
2001-06-27 16:30:00	SPY	ETF	121.65	121.65	121.48	121.48	500.0
2001-06-27 17:00:00	SPY	ETF	121.43	121.43	121.43	121.43	200.0
2001-06-27 09:30:00	QQQ	ETF	43.68	43.8	43.3	43.56	5137400.0
2001-06-27 10:00:00	QQQ	ETF	43.56	43.74	43.41	43.74	2342600.0
2001-06-27 10:30:00	QQQ	ETF	43.72	43.82	43.65	43.68	2662100.0
2001-06-27 11:00:00	QQQ	ETF	43.7	43.95	43.66	43.88	1790500.0
2001-06-27 11:30:00	QQQ	ETF	43.85	44.13	43.85	43.96	2433800.0
2001-06-27 12:00:00	QQQ	ETF	43.96	44.06	43.9	43.92	1141400.0
2001-06-27 12:30:00	QQQ	ETF	43.89	44.01	43.85	43.97	955900.0
2001-06-27 13:00:00	QQQ	ETF	43.93	44.02	43.9	43.9	1147800.0
2001-06-27 13:30:00	QQQ	ETF	43.92	43.94	43.7	43.75	2695500.0
2001-06-27 14:00:00	QQQ	ETF	43.75	44.0	43.1	43.2	9957000.0
2001-06-27 14:30:00	QQQ	ETF	43.18	43.9	43.0	43.77	7895500.0
2001-06-27 15:00:00	QQQ	ETF	43.77	44.15	43.67	43.92	7234100.0
2001-06-27 15:30:00	QQQ	ETF	43.93	44.03	43.66	43.75	4597000.0
2001-06-27 16:00:00	QQQ	ETF	43.73	43.85	43.35	43.71	932000.0
2001-06-27 16:30:00	QQQ	ETF	43.72	43.89	43.7	43.79	79900.0
2001-06-27 17:00:00	QQQ	ETF	43.83	43.95	43.78	43.9	110900.0
2001-06-27 17:30:00	QQQ	ETF	43.86	43.92	43.77	43.9	92500.0
2001-06-27 18:00:00	QQQ	ETF	43.94	43.94	43.65	43.8	4800.0
2001-06-27 09:30:00	IWM	ETF	49.1	49.15	48.95	48.95	367800.0
2001-06-27 10:00:00	IWM	ETF	49.07	49.22	49.05	49.15	42200.0
2001-06-27 10:30:00	IWM	ETF	49.25	49.36	49.175	49.295	22400.0
2001-06-27 11:00:00	IWM	ETF	49.275	49.295	49.25	49.285	26800.0
2001-06-27 11:30:00	IWM	ETF	49.285	49.35	49.285	49.35	30600.0
2001-06-27 12:00:00	IWM	ETF	49.375	49.375	49.35	49.36	2600.0
2001-06-27 12:30:00	IWM	ETF	49.3	49.525	49.3	49.47	106800.0
2001-06-27 13:00:00	IWM	ETF	49.49	49.6	49.455	49.55	29000.0
2001-06-27 13:30:00	IWM	ETF	49.55	49.55	49.35	49.37	26800.0
2001-06-27 14:00:00	IWM	ETF	49.305	49.375	49.0	49.04	132200.0
2001-06-27 14:30:00	IWM	ETF	48.965	49.45	48.965	49.45	11800.0
2001-06-27 15:00:00	IWM	ETF	49.29	49.53	49.29	49.4	3000.0
2001-06-27 15:30:00	IWM	ETF	49.4	49.5	49.225	49.375	117400.0
2001-06-27 16:00:00	IWM	ETF	49.525	49.525	49.1	49.475	43800.0
2001-06-27 09:30:00	DIA	ETF	104.88	105.18	104.74	105.18	110200.0
2001-06-27 10:00:00	DIA	ETF	105.05	105.31	105.03	105.23	121700.0

> showing 50 of 376 rows — these rows as CSV

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