PREVIEW / etf_30min / 2001-04-16

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-04-16.parquet
  size:    14 KB
  rows:    338

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-16 09:30:00	SPY	ETF	118.29	118.82	118.19	118.62	1617700.0
2001-04-16 10:00:00	SPY	ETF	118.66	118.89	118.05	118.19	591300.0
2001-04-16 10:30:00	SPY	ETF	118.2	118.33	117.77	118.21	488500.0
2001-04-16 11:00:00	SPY	ETF	118.28	118.47	117.77	118.4	270900.0
2001-04-16 11:30:00	SPY	ETF	118.46	118.47	118.01	118.22	246800.0
2001-04-16 12:00:00	SPY	ETF	118.24	118.41	117.92	117.96	321000.0
2001-04-16 12:30:00	SPY	ETF	117.96	118.05	117.82	117.96	125900.0
2001-04-16 13:00:00	SPY	ETF	117.92	118.49	117.92	118.35	125100.0
2001-04-16 13:30:00	SPY	ETF	118.24	118.69	118.15	118.69	348000.0
2001-04-16 14:00:00	SPY	ETF	118.55	118.77	117.97	118.0	323900.0
2001-04-16 14:30:00	SPY	ETF	117.9	118.23	117.56	117.64	376600.0
2001-04-16 15:00:00	SPY	ETF	117.64	117.64	116.91	117.27	799500.0
2001-04-16 15:30:00	SPY	ETF	117.2	118.25	117.2	118.23	680700.0
2001-04-16 16:00:00	SPY	ETF	118.28	118.4	117.1	117.75	633600.0
2001-04-16 16:30:00	SPY	ETF	117.78	117.9	117.5	117.82	54900.0
2001-04-16 17:00:00	SPY	ETF	117.76	117.86	117.75	117.75	3900.0
2001-04-16 17:30:00	SPY	ETF	117.9	117.9	117.6	117.6	4400.0
2001-04-16 18:00:00	SPY	ETF	117.62	117.8	117.62	117.66	2400.0
2001-04-16 09:30:00	QQQ	ETF	41.94	42.15	41.3	41.69	8598200.0
2001-04-16 10:00:00	QQQ	ETF	41.67	41.75	41.09	41.27	4982300.0
2001-04-16 10:30:00	QQQ	ETF	41.29	41.65	41.05	41.59	4076100.0
2001-04-16 11:00:00	QQQ	ETF	41.65	41.87	41.32	41.85	3076100.0
2001-04-16 11:30:00	QQQ	ETF	41.87	41.97	41.65	41.9	3313800.0
2001-04-16 12:00:00	QQQ	ETF	41.88	42.25	41.75	41.84	4331700.0
2001-04-16 12:30:00	QQQ	ETF	41.79	41.87	41.6	41.72	2043800.0
2001-04-16 13:00:00	QQQ	ETF	41.78	42.18	41.66	42.1	2138900.0
2001-04-16 13:30:00	QQQ	ETF	42.1	42.4	41.9	42.38	3121200.0
2001-04-16 14:00:00	QQQ	ETF	42.4	42.43	41.5	41.5	3855800.0
2001-04-16 14:30:00	QQQ	ETF	41.51	41.68	41.2	41.25	3941100.0
2001-04-16 15:00:00	QQQ	ETF	41.25	41.3	40.63	40.75	7734200.0
2001-04-16 15:30:00	QQQ	ETF	40.76	41.15	40.73	41.12	5828300.0
2001-04-16 16:00:00	QQQ	ETF	41.1	42.35	39.5	40.15	4267100.0
2001-04-16 16:30:00	QQQ	ETF	40.15	41.45	39.9	40.1	819300.0
2001-04-16 17:00:00	QQQ	ETF	40.1	40.35	40.09	40.35	199100.0
2001-04-16 17:30:00	QQQ	ETF	40.4	40.4	40.25	40.3	86600.0
2001-04-16 18:00:00	QQQ	ETF	40.3	40.3	40.18	40.2	32800.0
2001-04-16 09:30:00	IWM	ETF	45.25	45.25	44.95	44.95	24800.0
2001-04-16 10:00:00	IWM	ETF	44.945	45.05	44.825	44.825	24800.0
2001-04-16 10:30:00	IWM	ETF	44.95	45.05	44.95	45.05	600.0
2001-04-16 11:00:00	IWM	ETF	45.05	45.2	45.05	45.2	3000.0
2001-04-16 11:30:00	IWM	ETF	45.2	45.2	45.075	45.075	1600.0
2001-04-16 12:00:00	IWM	ETF	45.325	45.325	45.325	45.325	800.0
2001-04-16 12:30:00	IWM	ETF	45.175	45.175	45.15	45.15	2400.0
2001-04-16 13:00:00	IWM	ETF	45.02	45.25	45.02	45.25	16600.0
2001-04-16 14:00:00	IWM	ETF	45.25	45.4	45.25	45.4	4200.0
2001-04-16 14:30:00	IWM	ETF	45.25	45.25	45.0	45.0	18000.0
2001-04-16 15:00:00	IWM	ETF	44.93	44.95	44.75	44.895	47800.0
2001-04-16 15:30:00	IWM	ETF	44.805	45.05	44.775	45.025	102800.0
2001-04-16 16:00:00	IWM	ETF	45.0	45.0	44.63	44.63	6400.0
2001-04-16 09:30:00	DIA	ETF	101.0	101.9	101.0	101.9	307400.0

> showing 50 of 338 rows — these rows as CSV

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