PREVIEW / etf_1hour / 2001-11-06

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-11-06.parquet
  size:    13 KB
  rows:    268

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-11-06 09:00:00	SPY	ETF	110.35	110.53	110.15	110.5	1798700.0
2001-11-06 10:00:00	SPY	ETF	110.52	110.7	110.28	110.66	1408700.0
2001-11-06 11:00:00	SPY	ETF	110.65	110.67	110.43	110.55	1158300.0
2001-11-06 12:00:00	SPY	ETF	110.5	110.62	110.21	110.27	954100.0
2001-11-06 13:00:00	SPY	ETF	110.25	110.42	109.98	110.0	801700.0
2001-11-06 14:00:00	SPY	ETF	109.96	111.14	109.85	110.6	7611900.0
2001-11-06 15:00:00	SPY	ETF	110.59	112.45	110.36	112.29	7488900.0
2001-11-06 16:00:00	SPY	ETF	112.26	112.49	111.55	112.33	1362400.0
2001-11-06 17:00:00	SPY	ETF	112.26	112.45	112.24	112.4	11700.0
2001-11-06 18:00:00	SPY	ETF	112.2	112.2	112.16	112.16	2200.0
2001-11-06 09:00:00	QQQ	ETF	36.6	36.9	36.39	36.87	9621100.0
2001-11-06 10:00:00	QQQ	ETF	36.86	37.05	36.65	37.0	10274900.0
2001-11-06 11:00:00	QQQ	ETF	36.99	37.01	36.8	36.91	5487200.0
2001-11-06 12:00:00	QQQ	ETF	36.91	36.98	36.6	36.64	4391600.0
2001-11-06 13:00:00	QQQ	ETF	36.65	36.75	36.42	36.45	7197300.0
2001-11-06 14:00:00	QQQ	ETF	36.45	37.33	36.4	36.96	32097800.0
2001-11-06 15:00:00	QQQ	ETF	36.95	37.98	36.84	37.92	24864900.0
2001-11-06 16:00:00	QQQ	ETF	37.92	38.25	37.25	38.0	9599700.0
2001-11-06 17:00:00	QQQ	ETF	38.0	38.07	36.9	37.86	395400.0
2001-11-06 18:00:00	QQQ	ETF	37.9	38.0	37.84	37.88	29600.0
2001-11-06 09:00:00	IWM	ETF	43.375	43.6	43.25	43.6	122400.0
2001-11-06 10:00:00	IWM	ETF	43.5	43.6	43.36	43.545	321400.0
2001-11-06 11:00:00	IWM	ETF	43.5	43.725	43.47	43.565	21600.0
2001-11-06 12:00:00	IWM	ETF	43.53	43.585	43.485	43.52	19600.0
2001-11-06 13:00:00	IWM	ETF	43.5	43.51	43.325	43.435	18400.0
2001-11-06 14:00:00	IWM	ETF	43.38	43.725	43.275	43.55	107600.0
2001-11-06 15:00:00	IWM	ETF	43.375	44.125	43.375	44.075	813600.0
2001-11-06 16:00:00	IWM	ETF	44.11	44.25	43.95	44.25	44600.0
2001-11-06 09:00:00	DIA	ETF	94.25	94.29	94.0	94.28	337900.0
2001-11-06 10:00:00	DIA	ETF	94.2	94.45	94.03	94.45	253500.0
2001-11-06 11:00:00	DIA	ETF	94.36	94.41	94.23	94.29	134800.0
2001-11-06 12:00:00	DIA	ETF	94.34	94.4	94.04	94.06	71100.0
2001-11-06 13:00:00	DIA	ETF	94.12	94.29	94.01	94.02	114900.0
2001-11-06 14:00:00	DIA	ETF	94.01	95.01	93.85	94.4	847900.0
2001-11-06 15:00:00	DIA	ETF	94.5	96.15	94.3	96.0	1041200.0
2001-11-06 16:00:00	DIA	ETF	95.95	96.15	95.82	96.05	263500.0
2001-11-06 17:00:00	DIA	ETF	96.05	96.05	95.97	96.0	1100.0

> showing 37 of 268 rows — these rows as CSV

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