PREVIEW / etf_1hour / 2001-09-06

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-09-06.parquet
  size:    12 KB
  rows:    256

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-09-06 09:00:00	SPY	ETF	112.65	113.12	112.41	112.47	1754500.0
2001-09-06 10:00:00	SPY	ETF	112.46	113.3	111.91	112.6	4609800.0
2001-09-06 11:00:00	SPY	ETF	112.65	112.67	111.95	112.01	2076100.0
2001-09-06 12:00:00	SPY	ETF	112.0	112.04	111.12	111.6	3788100.0
2001-09-06 13:00:00	SPY	ETF	111.63	111.96	111.41	111.64	2353700.0
2001-09-06 14:00:00	SPY	ETF	111.66	111.9	111.23	111.62	2017900.0
2001-09-06 15:00:00	SPY	ETF	111.65	111.73	111.09	111.1	2373700.0
2001-09-06 16:00:00	SPY	ETF	111.15	111.25	110.25	110.92	1456700.0
2001-09-06 17:00:00	SPY	ETF	110.92	111.25	110.9	111.04	3800.0
2001-09-06 18:00:00	SPY	ETF	111.06	111.1	111.06	111.1	1400.0
2001-09-06 09:00:00	QQQ	ETF	34.74	35.11	34.59	34.74	8460600.0
2001-09-06 10:00:00	QQQ	ETF	34.73	35.5	34.45	34.8	20204300.0
2001-09-06 11:00:00	QQQ	ETF	34.79	34.84	34.26	34.4	9542200.0
2001-09-06 12:00:00	QQQ	ETF	34.4	34.55	34.08	34.49	11383400.0
2001-09-06 13:00:00	QQQ	ETF	34.49	34.71	34.27	34.5	7566800.0
2001-09-06 14:00:00	QQQ	ETF	34.46	34.52	34.15	34.34	9773500.0
2001-09-06 15:00:00	QQQ	ETF	34.37	34.42	33.9	33.96	13653800.0
2001-09-06 16:00:00	QQQ	ETF	33.94	34.45	33.78	34.09	3145000.0
2001-09-06 17:00:00	QQQ	ETF	34.08	34.29	34.08	34.25	160300.0
2001-09-06 18:00:00	QQQ	ETF	34.2	34.43	34.2	34.36	103800.0
2001-09-06 09:00:00	IWM	ETF	45.75	45.885	45.55	45.55	5000.0
2001-09-06 10:00:00	IWM	ETF	45.62	45.9	45.48	45.6	67800.0
2001-09-06 11:00:00	IWM	ETF	45.655	45.655	45.425	45.425	51200.0
2001-09-06 12:00:00	IWM	ETF	45.41	45.415	45.25	45.25	15000.0
2001-09-06 13:00:00	IWM	ETF	45.21	45.39	45.16	45.32	103000.0
2001-09-06 14:00:00	IWM	ETF	45.25	45.345	45.19	45.2	11800.0
2001-09-06 15:00:00	IWM	ETF	45.325	45.345	45.105	45.27	27400.0
2001-09-06 16:00:00	IWM	ETF	45.175	45.175	45.175	45.175	600.0
2001-09-06 09:00:00	DIA	ETF	99.8	100.12	99.47	99.55	620200.0
2001-09-06 10:00:00	DIA	ETF	99.53	100.2	99.0	99.8	1452600.0
2001-09-06 11:00:00	DIA	ETF	99.8	99.85	99.22	99.23	432900.0
2001-09-06 12:00:00	DIA	ETF	99.22	99.25	98.4	98.87	1067600.0
2001-09-06 13:00:00	DIA	ETF	98.9	99.2	98.72	98.82	661800.0
2001-09-06 14:00:00	DIA	ETF	98.83	99.18	98.52	98.85	499000.0
2001-09-06 15:00:00	DIA	ETF	98.86	98.97	98.44	98.59	717000.0
2001-09-06 16:00:00	DIA	ETF	98.55	98.8	98.33	98.48	170700.0
2001-09-06 17:00:00	DIA	ETF	98.54	98.54	98.54	98.54	1000.0

> showing 37 of 256 rows — these rows as CSV

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