PREVIEW / etf_1hour / 2007-12-31

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-12-31.parquet
  size:    95 KB
  rows:    3,207

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
2007-12-31 05:00:00	SPY	ETF	147.72	147.72	147.59	147.59	2100.0
2007-12-31 06:00:00	SPY	ETF	147.65	147.67	147.62	147.62	14000.0
2007-12-31 07:00:00	SPY	ETF	147.62	147.7	147.59	147.67	62000.0
2007-12-31 08:00:00	SPY	ETF	147.63	147.75	147.52	147.53	961100.0
2007-12-31 09:00:00	SPY	ETF	147.54	147.54	146.8	146.84	7530343.0
2007-12-31 10:00:00	SPY	ETF	146.84	147.17	146.59	146.71	11923735.0
2007-12-31 11:00:00	SPY	ETF	146.71	146.74	146.25	146.438	16302712.0
2007-12-31 12:00:00	SPY	ETF	146.44	146.75	146.33	146.66	8393802.0
2007-12-31 13:00:00	SPY	ETF	146.65	147.13	146.61	146.99	8922703.0
2007-12-31 14:00:00	SPY	ETF	146.99	147.25	146.85	147.16	7337334.0
2007-12-31 15:00:00	SPY	ETF	147.16	147.33	146.36	146.42	20974910.0
2007-12-31 16:00:00	SPY	ETF	146.42	146.9484	146.06	146.1	9755110.0
2007-12-31 17:00:00	SPY	ETF	146.1	146.21	146.0	146.0	1288700.0
2007-12-31 18:00:00	SPY	ETF	146.07	146.2	146.05	146.2	17800.0
2007-12-31 19:00:00	SPY	ETF	146.18	146.22	146.16	146.22	5800.0
2007-12-31 07:00:00	QQQ	ETF	51.76	51.76	51.7	51.74	120600.0
2007-12-31 08:00:00	QQQ	ETF	51.76	51.77	51.66	51.69	1391156.0
2007-12-31 09:00:00	QQQ	ETF	51.68	51.68	51.4	51.5299	8870094.0
2007-12-31 10:00:00	QQQ	ETF	51.53	51.68	51.4	51.43	8999581.0
2007-12-31 11:00:00	QQQ	ETF	51.43	51.46	51.3	51.3601	9532816.0
2007-12-31 12:00:00	QQQ	ETF	51.36	51.43	51.27	51.3601	7958989.0
2007-12-31 13:00:00	QQQ	ETF	51.36	51.5	51.34	51.405	7418836.0
2007-12-31 14:00:00	QQQ	ETF	51.401	51.55	51.35	51.52	7167961.0
2007-12-31 15:00:00	QQQ	ETF	51.51	51.65	51.21	51.22	13875579.0
2007-12-31 16:00:00	QQQ	ETF	51.24	51.7896	51.17	51.19	4908670.0
2007-12-31 17:00:00	QQQ	ETF	51.19	51.24	51.19	51.21	12650.0
2007-12-31 18:00:00	QQQ	ETF	51.21	51.21	51.2	51.21	12671.0
2007-12-31 19:00:00	QQQ	ETF	51.22	51.24	51.21	51.22	8670.0
2007-12-31 07:00:00	IWM	ETF	76.7	76.72	76.69	76.72	17500.0
2007-12-31 08:00:00	IWM	ETF	76.71	76.77	76.67	76.74	54100.0
2007-12-31 09:00:00	IWM	ETF	76.68	76.68	76.13	76.14	5838686.0
2007-12-31 10:00:00	IWM	ETF	76.14	76.31	75.75	75.79	8700977.0
2007-12-31 11:00:00	IWM	ETF	75.78	76.57	75.58	75.82	10388886.0
2007-12-31 12:00:00	IWM	ETF	75.82	75.95	75.74	75.83	7197670.0
2007-12-31 13:00:00	IWM	ETF	75.84	76.26	75.81	76.2	8422856.0
2007-12-31 14:00:00	IWM	ETF	76.21	76.46	76.15	76.41	5933676.0
2007-12-31 15:00:00	IWM	ETF	76.42	76.71	76.15	76.23	16340390.0
2007-12-31 16:00:00	IWM	ETF	76.23	76.45	75.9	76.0	11374214.0
2007-12-31 17:00:00	IWM	ETF	75.99	75.99	75.99	75.99	2000.0
2007-12-31 18:00:00	IWM	ETF	76.09	76.09	76.09	76.09	3000.0
2007-12-31 08:00:00	DIA	ETF	133.57	133.69	133.49	133.5	2600.0
2007-12-31 09:00:00	DIA	ETF	133.5	133.5	132.78	132.84	799576.0
2007-12-31 10:00:00	DIA	ETF	132.87	133.24	132.69	132.78	1136328.0
2007-12-31 11:00:00	DIA	ETF	132.79	132.8	132.33	132.51	786355.0
2007-12-31 12:00:00	DIA	ETF	132.51	132.76	132.38	132.66	1022952.0
2007-12-31 13:00:00	DIA	ETF	132.66	133.0	132.59	132.88	755275.0
2007-12-31 14:00:00	DIA	ETF	132.85	133.07	132.74	132.99	507615.0
2007-12-31 15:00:00	DIA	ETF	132.99	133.1	132.4	132.42	1188571.0
2007-12-31 16:00:00	DIA	ETF	132.43	132.58	132.16	132.45	252416.0
2007-12-31 17:00:00	DIA	ETF	132.45	132.48	132.3	132.3	10800.0

> showing 50 of 3,207 rows — these rows as CSV

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