PREVIEW / etf_1hour / 2007-12-04

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-12-04.parquet
  size:    90 KB
  rows:    3,071

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-04 04:00:00	SPY	ETF	147.21	147.21	147.21	147.21	1500.0
2007-12-04 05:00:00	SPY	ETF	147.16	147.16	146.96	147.07	16500.0
2007-12-04 06:00:00	SPY	ETF	147.07	147.07	146.97	147.02	52000.0
2007-12-04 07:00:00	SPY	ETF	147.0	147.1	146.64	146.7	773100.0
2007-12-04 08:00:00	SPY	ETF	146.71	147.1	146.65	146.87	3145200.0
2007-12-04 09:00:00	SPY	ETF	146.88	147.1	146.31	146.95	27558932.0
2007-12-04 10:00:00	SPY	ETF	146.94	147.16	146.64	146.83	16122794.0
2007-12-04 11:00:00	SPY	ETF	146.82	147.11	146.62	146.68	12791360.0
2007-12-04 12:00:00	SPY	ETF	146.68	147.31	146.68	147.17	13780819.0
2007-12-04 13:00:00	SPY	ETF	147.17	147.34	146.83	146.9774	13570065.0
2007-12-04 14:00:00	SPY	ETF	146.97	147.5409	146.6	147.02	16463206.0
2007-12-04 15:00:00	SPY	ETF	147.02	147.17	146.51	146.56	26859971.0
2007-12-04 16:00:00	SPY	ETF	146.58	147.5409	146.35	146.53	2690700.0
2007-12-04 17:00:00	SPY	ETF	146.55	146.6	146.36	146.59	61334.0
2007-12-04 18:00:00	SPY	ETF	146.57	146.57	146.46	146.51	43600.0
2007-12-04 19:00:00	SPY	ETF	146.51	146.66	146.43	146.66	5300.0
2007-12-04 06:00:00	QQQ	ETF	50.78	50.79	50.7	50.75	42000.0
2007-12-04 07:00:00	QQQ	ETF	50.75	50.76	50.46	50.5	941864.0
2007-12-04 08:00:00	QQQ	ETF	50.5	50.62	50.46	50.58	3632347.0
2007-12-04 09:00:00	QQQ	ETF	50.6	50.78	50.38	50.77	23258363.0
2007-12-04 10:00:00	QQQ	ETF	50.76	50.92	50.65	50.76	19444746.0
2007-12-04 11:00:00	QQQ	ETF	50.76	50.912	50.7	50.73	10334326.0
2007-12-04 12:00:00	QQQ	ETF	50.73	50.9	50.69	50.8699	10588064.0
2007-12-04 13:00:00	QQQ	ETF	50.86	50.94	50.71	50.7701	7883068.0
2007-12-04 14:00:00	QQQ	ETF	50.78	50.8	50.53	50.76	13497362.0
2007-12-04 15:00:00	QQQ	ETF	50.76	50.79	50.53	50.66	21529024.0
2007-12-04 16:00:00	QQQ	ETF	50.66	50.68	50.55	50.65	1989695.0
2007-12-04 17:00:00	QQQ	ETF	50.67	50.7	50.65	50.65	308768.0
2007-12-04 18:00:00	QQQ	ETF	50.67	50.69	50.64	50.69	41962.0
2007-12-04 19:00:00	QQQ	ETF	50.68	50.72	50.64	50.69	32497.0
2007-12-04 06:00:00	IWM	ETF	75.4	75.4	75.4	75.4	5000.0
2007-12-04 07:00:00	IWM	ETF	75.32	75.32	75.21	75.23	25500.0
2007-12-04 08:00:00	IWM	ETF	75.27	75.3	75.12	75.21	913200.0
2007-12-04 09:00:00	IWM	ETF	75.25	75.3	74.56	75.08	10077186.0
2007-12-04 10:00:00	IWM	ETF	75.08	75.46	74.97	75.17	9412679.0
2007-12-04 11:00:00	IWM	ETF	75.18	75.31	74.98	75.06	6409545.0
2007-12-04 12:00:00	IWM	ETF	75.07	75.5	75.06	75.45	5208322.0
2007-12-04 13:00:00	IWM	ETF	75.44	75.56	75.13	75.31	6135495.0
2007-12-04 14:00:00	IWM	ETF	75.31	75.34	75.01	75.29	5791110.0
2007-12-04 15:00:00	IWM	ETF	75.28	75.45	74.91	74.97	11427351.0
2007-12-04 16:00:00	IWM	ETF	74.97	75.22	74.96	75.11	1893780.0
2007-12-04 17:00:00	IWM	ETF	75.12	75.13	75.0	75.1	250800.0
2007-12-04 18:00:00	IWM	ETF	75.23	75.23	75.13	75.14	121000.0
2007-12-04 07:00:00	DIA	ETF	132.63	132.7	132.63	132.64	1300.0
2007-12-04 08:00:00	DIA	ETF	132.58	132.71	132.58	132.66	16800.0
2007-12-04 09:00:00	DIA	ETF	132.89	132.89	132.36	132.84	1678902.0
2007-12-04 10:00:00	DIA	ETF	132.84	133.09	132.66	132.83	1230748.0
2007-12-04 11:00:00	DIA	ETF	132.82	133.09	132.63	132.64	917243.0
2007-12-04 12:00:00	DIA	ETF	132.66	133.12	132.65	133.05	1133406.0
2007-12-04 13:00:00	DIA	ETF	133.03	133.18	132.81	132.9	443800.0

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

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