PREVIEW / etf_30min / 2001-04-27

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-04-27.parquet
  size:    14 KB
  rows:    365

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-04-27 09:30:00	SPY	ETF	124.92	125.0	124.2	124.55	1244400.0
2001-04-27 10:00:00	SPY	ETF	124.49	125.17	124.46	124.85	1089100.0
2001-04-27 10:30:00	SPY	ETF	124.95	125.15	124.53	124.7	587200.0
2001-04-27 11:00:00	SPY	ETF	124.6	125.04	124.29	124.3	461600.0
2001-04-27 11:30:00	SPY	ETF	124.3	124.96	124.21	124.72	248700.0
2001-04-27 12:00:00	SPY	ETF	124.82	124.94	124.56	124.7	181300.0
2001-04-27 12:30:00	SPY	ETF	124.74	124.94	124.54	124.76	235800.0
2001-04-27 13:00:00	SPY	ETF	124.78	125.13	124.69	125.01	190600.0
2001-04-27 13:30:00	SPY	ETF	124.95	125.15	124.8	125.06	432700.0
2001-04-27 14:00:00	SPY	ETF	124.95	125.07	124.6	124.79	236300.0
2001-04-27 14:30:00	SPY	ETF	124.77	124.8	124.42	124.68	555400.0
2001-04-27 15:00:00	SPY	ETF	124.59	125.08	124.41	124.98	277600.0
2001-04-27 15:30:00	SPY	ETF	124.97	125.68	124.87	125.55	1193700.0
2001-04-27 16:00:00	SPY	ETF	125.68	125.84	125.5	125.78	858100.0
2001-04-27 16:30:00	SPY	ETF	125.66	126.39	125.65	126.39	1900.0
2001-04-27 17:30:00	SPY	ETF	126.33	126.39	126.33	126.39	500.0
2001-04-27 09:30:00	QQQ	ETF	45.15	45.35	44.5	44.97	10230300.0
2001-04-27 10:00:00	QQQ	ETF	44.95	45.47	44.93	45.15	8146300.0
2001-04-27 10:30:00	QQQ	ETF	45.15	45.35	44.64	44.64	3670700.0
2001-04-27 11:00:00	QQQ	ETF	44.68	44.98	44.52	44.53	2785400.0
2001-04-27 11:30:00	QQQ	ETF	44.53	45.1	44.45	44.93	2958200.0
2001-04-27 12:00:00	QQQ	ETF	44.94	45.04	44.52	44.7	3544800.0
2001-04-27 12:30:00	QQQ	ETF	44.7	44.87	44.6	44.77	1837100.0
2001-04-27 13:00:00	QQQ	ETF	44.82	45.05	44.72	44.96	1589200.0
2001-04-27 13:30:00	QQQ	ETF	44.96	45.2	44.84	45.1	2063400.0
2001-04-27 14:00:00	QQQ	ETF	45.05	45.1	44.7	44.73	2406700.0
2001-04-27 14:30:00	QQQ	ETF	44.79	44.8	44.33	44.46	3467200.0
2001-04-27 15:00:00	QQQ	ETF	44.49	44.85	44.24	44.84	4882200.0
2001-04-27 15:30:00	QQQ	ETF	44.84	45.15	44.79	45.11	4456200.0
2001-04-27 16:00:00	QQQ	ETF	45.12	45.25	44.52	45.23	1038800.0
2001-04-27 16:30:00	QQQ	ETF	45.22	45.3	44.79	45.2	176000.0
2001-04-27 17:00:00	QQQ	ETF	45.24	45.3	45.22	45.25	19600.0
2001-04-27 17:30:00	QQQ	ETF	45.26	45.37	45.25	45.27	10500.0
2001-04-27 18:00:00	QQQ	ETF	45.27	45.35	45.22	45.32	10800.0
2001-04-27 09:30:00	IWM	ETF	48.125	48.22	47.95	48.0	27600.0
2001-04-27 10:00:00	IWM	ETF	48.1	48.1	48.1	48.1	200000.0
2001-04-27 10:30:00	IWM	ETF	48.0	48.15	47.95	48.1	234200.0
2001-04-27 11:00:00	IWM	ETF	48.125	48.125	48.0	48.0	101000.0
2001-04-27 11:30:00	IWM	ETF	48.075	48.15	47.97	48.15	208400.0
2001-04-27 12:00:00	IWM	ETF	48.25	48.275	48.12	48.12	102400.0
2001-04-27 12:30:00	IWM	ETF	48.15	48.25	48.105	48.25	103200.0
2001-04-27 13:00:00	IWM	ETF	48.245	48.245	48.05	48.125	158800.0
2001-04-27 13:30:00	IWM	ETF	48.05	48.195	48.05	48.195	161200.0
2001-04-27 14:00:00	IWM	ETF	48.05	48.2	48.05	48.195	13200.0
2001-04-27 14:30:00	IWM	ETF	48.17	48.175	47.975	48.0	125400.0
2001-04-27 15:00:00	IWM	ETF	48.195	48.195	48.15	48.17	9200.0
2001-04-27 15:30:00	IWM	ETF	48.17	48.45	48.075	48.375	147600.0
2001-04-27 16:00:00	IWM	ETF	48.45	48.45	48.45	48.45	100000.0
2001-04-27 09:30:00	DIA	ETF	107.65	107.95	107.3	107.5	922300.0
2001-04-27 10:00:00	DIA	ETF	107.5	108.07	107.45	107.65	407500.0

> showing 50 of 365 rows — these rows as CSV

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