PREVIEW / etf_1hour / 2001-12-06

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-12-06.parquet
  size:    13 KB
  rows:    286

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-12-06 09:00:00	SPY	ETF	117.34	117.45	117.09	117.4	2266000.0
2001-12-06 10:00:00	SPY	ETF	117.44	117.61	116.93	117.33	3388900.0
2001-12-06 11:00:00	SPY	ETF	117.3	117.59	117.18	117.46	1241200.0
2001-12-06 12:00:00	SPY	ETF	117.46	117.9	117.36	117.89	2187000.0
2001-12-06 13:00:00	SPY	ETF	117.9	117.94	117.39	117.53	2072300.0
2001-12-06 14:00:00	SPY	ETF	117.53	117.6	117.01	117.33	2954300.0
2001-12-06 15:00:00	SPY	ETF	117.31	117.57	117.05	117.3	2272900.0
2001-12-06 16:00:00	SPY	ETF	117.25	117.82	117.0	117.5	1371500.0
2001-12-06 17:00:00	SPY	ETF	117.56	117.72	117.4	117.42	11000.0
2001-12-06 18:00:00	SPY	ETF	117.43	117.43	117.35	117.36	4300.0
2001-12-06 09:00:00	QQQ	ETF	42.7	42.84	42.45	42.81	12168500.0
2001-12-06 10:00:00	QQQ	ETF	42.79	43.08	42.51	42.73	14815900.0
2001-12-06 11:00:00	QQQ	ETF	42.73	42.92	42.53	42.75	5994100.0
2001-12-06 12:00:00	QQQ	ETF	42.75	43.24	42.66	43.2	9761800.0
2001-12-06 13:00:00	QQQ	ETF	43.2	43.24	42.7	42.82	9075400.0
2001-12-06 14:00:00	QQQ	ETF	42.81	42.83	42.36	42.66	10800800.0
2001-12-06 15:00:00	QQQ	ETF	42.66	42.89	42.52	42.77	10042700.0
2001-12-06 16:00:00	QQQ	ETF	42.79	43.5	42.73	43.11	3809100.0
2001-12-06 17:00:00	QQQ	ETF	43.1	43.1	42.9	43.03	455400.0
2001-12-06 18:00:00	QQQ	ETF	43.03	43.09	43.01	43.04	25300.0
2001-12-06 09:00:00	IWM	ETF	47.8	47.945	47.675	47.85	89400.0
2001-12-06 10:00:00	IWM	ETF	47.925	48.17	47.8	48.02	127800.0
2001-12-06 11:00:00	IWM	ETF	48.0	48.015	47.85	48.005	40400.0
2001-12-06 12:00:00	IWM	ETF	48.0	48.2	47.995	48.195	55000.0
2001-12-06 13:00:00	IWM	ETF	48.21	48.215	47.945	48.07	32200.0
2001-12-06 14:00:00	IWM	ETF	48.07	48.07	47.75	47.78	131000.0
2001-12-06 15:00:00	IWM	ETF	47.935	48.125	47.805	48.125	233000.0
2001-12-06 16:00:00	IWM	ETF	48.2	48.315	48.19	48.315	27000.0
2001-12-06 09:00:00	DIA	ETF	101.22	101.43	101.0	101.32	418800.0
2001-12-06 10:00:00	DIA	ETF	101.32	101.7	101.0	101.37	496800.0
2001-12-06 11:00:00	DIA	ETF	101.42	101.61	101.3	101.6	986000.0
2001-12-06 12:00:00	DIA	ETF	101.56	101.95	101.51	101.94	192400.0
2001-12-06 13:00:00	DIA	ETF	101.95	101.95	101.51	101.73	288800.0
2001-12-06 14:00:00	DIA	ETF	101.65	101.65	101.1	101.38	668500.0
2001-12-06 15:00:00	DIA	ETF	101.41	101.6	101.15	101.29	337000.0
2001-12-06 16:00:00	DIA	ETF	101.27	101.36	101.16	101.33	118300.0

> showing 36 of 286 rows — these rows as CSV

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