PREVIEW / etf_1hour / 2008-12-17

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-12-17.parquet
  size:    131 KB
  rows:    4,357

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
2008-12-17 04:00:00	SPY	ETF	89.37	89.76	89.37	89.67	15748.0
2008-12-17 05:00:00	SPY	ETF	89.71	90.27	89.69	90.2	57612.0
2008-12-17 06:00:00	SPY	ETF	90.44	90.78	90.3	90.5	220240.0
2008-12-17 07:00:00	SPY	ETF	90.57	90.8	90.26	90.63	1881646.0
2008-12-17 08:00:00	SPY	ETF	90.65	91.19	89.49	91.11	3464816.0
2008-12-17 09:00:00	SPY	ETF	91.1	91.22	90.28	91.13	33499583.0
2008-12-17 10:00:00	SPY	ETF	91.139	91.28	90.06	91.09	43509617.0
2008-12-17 11:00:00	SPY	ETF	91.09	91.32	90.43	91.08	28095054.0
2008-12-17 12:00:00	SPY	ETF	91.08	91.84	90.86	91.56	25525740.0
2008-12-17 13:00:00	SPY	ETF	91.56	92.43	91.33	91.98	26148397.0
2008-12-17 14:00:00	SPY	ETF	91.989	92.42	90.99	91.56	38167987.0
2008-12-17 15:00:00	SPY	ETF	91.55	91.99	90.83	91.01	54825267.0
2008-12-17 16:00:00	SPY	ETF	90.96	91.98	90.78	91.18	18087938.0
2008-12-17 17:00:00	SPY	ETF	91.16	91.87	90.95	91.87	5252008.0
2008-12-17 18:00:00	SPY	ETF	90.97	91.54	90.8	90.8	171877.0
2008-12-17 19:00:00	SPY	ETF	90.8	91.0	90.75	90.93	60567.0
2008-12-17 20:00:00	SPY	ETF	90.99	91.0	90.86	90.86	9016.0
2008-12-17 04:00:00	QQQ	ETF	29.78	29.8	29.76	29.78	7350.0
2008-12-17 05:00:00	QQQ	ETF	30.11	30.11	30.11	30.11	300.0
2008-12-17 06:00:00	QQQ	ETF	30.28	30.28	30.08	30.22	5975.0
2008-12-17 07:00:00	QQQ	ETF	30.24	30.27	30.12	30.21	85950.0
2008-12-17 08:00:00	QQQ	ETF	30.2	30.6	30.09	30.34	1204821.0
2008-12-17 09:00:00	QQQ	ETF	30.33	30.39	30.04	30.21	21313414.0
2008-12-17 10:00:00	QQQ	ETF	30.21	30.2411	29.82	30.12	25874463.0
2008-12-17 11:00:00	QQQ	ETF	30.13	30.21	29.96	30.2	14730823.0
2008-12-17 12:00:00	QQQ	ETF	30.2	30.49	30.14	30.37	20766106.0
2008-12-17 13:00:00	QQQ	ETF	30.36	30.6	30.24	30.4404	14569601.0
2008-12-17 14:00:00	QQQ	ETF	30.44	30.55	30.12	30.37	24672221.0
2008-12-17 15:00:00	QQQ	ETF	30.37	30.52	30.16	30.19	25283336.0
2008-12-17 16:00:00	QQQ	ETF	30.19	30.26	30.15	30.25	3784746.0
2008-12-17 17:00:00	QQQ	ETF	30.27	30.56	30.21	30.22	131102.0
2008-12-17 18:00:00	QQQ	ETF	30.25	30.26	30.22	30.24	22925.0
2008-12-17 19:00:00	QQQ	ETF	30.22	30.3	30.19	30.28	36345.0
2008-12-17 06:00:00	IWM	ETF	48.16	48.22	48.01	48.01	6900.0
2008-12-17 07:00:00	IWM	ETF	48.04	48.09	47.76	47.9	317580.0
2008-12-17 08:00:00	IWM	ETF	47.9	48.29	47.54	48.28	793047.0
2008-12-17 09:00:00	IWM	ETF	48.24	48.59	47.57	48.46	11004437.0
2008-12-17 10:00:00	IWM	ETF	48.47	48.58	47.8	48.26	13081740.0
2008-12-17 11:00:00	IWM	ETF	48.26	48.41	48.0	48.21	6607630.0
2008-12-17 12:00:00	IWM	ETF	48.21	48.79	48.15	48.66	8909993.0
2008-12-17 13:00:00	IWM	ETF	48.66	49.51	48.45	49.18	8471143.0
2008-12-17 14:00:00	IWM	ETF	49.18	49.45	48.37	48.81	11450981.0
2008-12-17 15:00:00	IWM	ETF	48.82	49.17	48.4	48.82	11437371.0
2008-12-17 16:00:00	IWM	ETF	48.82	48.9	48.53	48.8	1941993.0
2008-12-17 17:00:00	IWM	ETF	48.75	48.8	48.33	48.33	4930.0
2008-12-17 18:00:00	IWM	ETF	48.72	48.72	48.46	48.46	4350.0
2008-12-17 19:00:00	IWM	ETF	48.41	48.41	48.41	48.41	100.0
2008-12-17 06:00:00	DIA	ETF	88.18	88.18	87.95	88.12	2800.0
2008-12-17 07:00:00	DIA	ETF	88.12	88.3	87.89	88.23	19578.0
2008-12-17 08:00:00	DIA	ETF	88.23	88.71	88.06	88.71	85634.0

> showing 50 of 4,357 rows — these rows as CSV

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