PREVIEW / etf_30min / 2001-03-20

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-03-20.parquet
  size:    15 KB
  rows:    378

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-03-20 09:30:00	SPY	ETF	117.9	117.9	117.03	117.15	1068800.0
2001-03-20 10:00:00	SPY	ETF	117.12	117.96	117.0	117.65	678700.0
2001-03-20 10:30:00	SPY	ETF	117.63	118.0	117.46	117.65	477200.0
2001-03-20 11:00:00	SPY	ETF	117.65	117.94	117.5	117.75	658900.0
2001-03-20 11:30:00	SPY	ETF	117.81	118.18	117.64	118.14	334300.0
2001-03-20 12:00:00	SPY	ETF	118.01	118.26	117.92	117.96	400200.0
2001-03-20 12:30:00	SPY	ETF	118.04	118.19	117.66	117.66	214500.0
2001-03-20 13:00:00	SPY	ETF	117.66	118.0	117.56	117.94	222900.0
2001-03-20 13:30:00	SPY	ETF	117.9	118.27	117.82	118.03	493100.0
2001-03-20 14:00:00	SPY	ETF	117.99	118.46	116.25	117.73	3311900.0
2001-03-20 14:30:00	SPY	ETF	117.41	117.49	116.56	116.56	1452500.0
2001-03-20 15:00:00	SPY	ETF	116.71	116.71	115.35	115.5	1247800.0
2001-03-20 15:30:00	SPY	ETF	115.46	115.46	114.22	114.25	2347600.0
2001-03-20 16:00:00	SPY	ETF	114.15	114.62	114.02	114.45	1496700.0
2001-03-20 16:30:00	SPY	ETF	114.05	114.05	114.0	114.0	300.0
2001-03-20 17:00:00	SPY	ETF	113.85	114.0	113.85	114.0	300.0
2001-03-20 17:30:00	SPY	ETF	114.3	114.3	113.89	113.89	3500.0
2001-03-20 09:30:00	QQQ	ETF	43.44	43.69	42.91	43.13	11039300.0
2001-03-20 10:00:00	QQQ	ETF	43.08	43.55	42.92	43.25	4797000.0
2001-03-20 10:30:00	QQQ	ETF	43.21	43.5	43.1	43.24	3624900.0
2001-03-20 11:00:00	QQQ	ETF	43.21	43.25	42.94	43.06	3030400.0
2001-03-20 11:30:00	QQQ	ETF	43.05	43.4	43.02	43.37	4199700.0
2001-03-20 12:00:00	QQQ	ETF	43.35	43.45	43.2	43.29	3795300.0
2001-03-20 12:30:00	QQQ	ETF	43.28	43.35	42.88	42.91	4428800.0
2001-03-20 13:00:00	QQQ	ETF	42.91	43.15	42.82	43.04	2862300.0
2001-03-20 13:30:00	QQQ	ETF	43.09	43.6	43.03	43.3	4159700.0
2001-03-20 14:00:00	QQQ	ETF	43.25	43.81	41.98	43.12	18093400.0
2001-03-20 14:30:00	QQQ	ETF	43.11	43.2	41.65	41.76	13140400.0
2001-03-20 15:00:00	QQQ	ETF	41.78	41.9	40.9	41.0	11888900.0
2001-03-20 15:30:00	QQQ	ETF	40.93	41.0	40.2	40.2	13097600.0
2001-03-20 16:00:00	QQQ	ETF	40.2	40.9	40.0	40.25	2496900.0
2001-03-20 16:30:00	QQQ	ETF	40.32	41.0	40.21	40.25	78400.0
2001-03-20 17:00:00	QQQ	ETF	40.25	40.45	40.04	40.12	141400.0
2001-03-20 17:30:00	QQQ	ETF	40.1	40.25	40.02	40.06	72100.0
2001-03-20 18:00:00	QQQ	ETF	40.08	40.2	40.0	40.15	20400.0
2001-03-20 18:30:00	QQQ	ETF	40.15	40.19	40.15	40.19	1000.0
2001-03-20 09:30:00	IWM	ETF	45.05	45.085	44.85	44.85	34800.0
2001-03-20 10:00:00	IWM	ETF	44.9	45.265	44.9	45.25	80800.0
2001-03-20 10:30:00	IWM	ETF	45.375	45.4	45.23	45.25	5000.0
2001-03-20 11:00:00	IWM	ETF	45.275	45.375	45.2	45.3	11200.0
2001-03-20 11:30:00	IWM	ETF	45.39	45.525	45.35	45.45	55600.0
2001-03-20 12:00:00	IWM	ETF	45.45	45.575	45.4	45.45	26400.0
2001-03-20 12:30:00	IWM	ETF	45.45	45.58	45.4	45.4	7200.0
2001-03-20 13:00:00	IWM	ETF	45.35	45.41	45.25	45.39	5600.0
2001-03-20 13:30:00	IWM	ETF	45.39	45.475	45.325	45.375	18400.0
2001-03-20 14:00:00	IWM	ETF	45.27	45.5	44.75	45.37	80600.0
2001-03-20 14:30:00	IWM	ETF	45.325	45.325	44.975	44.99	90200.0
2001-03-20 15:00:00	IWM	ETF	44.75	44.9	44.5	44.5	31400.0
2001-03-20 15:30:00	IWM	ETF	44.6	44.6	44.15	44.175	166600.0
2001-03-20 16:00:00	IWM	ETF	44.1	44.1	44.1	44.1	9000.0

> showing 50 of 378 rows — these rows as CSV

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