PREVIEW / etf_1hour / 2008-12-15

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-12-15.parquet
  size:    116 KB
  rows:    3,780

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-15 04:00:00	SPY	ETF	88.45	88.5	88.27	88.33	6900.0
2008-12-15 05:00:00	SPY	ETF	88.45	88.86	88.45	88.86	5700.0
2008-12-15 06:00:00	SPY	ETF	89.03	89.29	89.03	89.26	21069.0
2008-12-15 07:00:00	SPY	ETF	89.17	89.17	88.56	88.74	252838.0
2008-12-15 08:00:00	SPY	ETF	88.75	89.16	88.65	88.84	1761022.0
2008-12-15 09:00:00	SPY	ETF	88.83	89.726	87.9	87.94	26377981.0
2008-12-15 10:00:00	SPY	ETF	87.94	88.0	87.07	87.15	37284334.0
2008-12-15 11:00:00	SPY	ETF	87.15	87.76	86.96	87.57	25575795.0
2008-12-15 12:00:00	SPY	ETF	87.56	88.0	87.2	87.34	20078827.0
2008-12-15 13:00:00	SPY	ETF	87.33	87.59	86.71	87.29	32406282.0
2008-12-15 14:00:00	SPY	ETF	87.29	87.7	86.75	86.7699	26958803.0
2008-12-15 15:00:00	SPY	ETF	86.76	88.0	86.29	87.5	66680387.0
2008-12-15 16:00:00	SPY	ETF	87.47	88.0	86.3	87.92	12090935.0
2008-12-15 17:00:00	SPY	ETF	87.92	88.02	87.81	87.86	1083399.0
2008-12-15 18:00:00	SPY	ETF	87.84	87.89	87.74	87.79	69236.0
2008-12-15 19:00:00	SPY	ETF	87.8	87.83	87.5	87.64	129643.0
2008-12-15 04:00:00	QQQ	ETF	29.57	29.57	29.57	29.57	540.0
2008-12-15 05:00:00	QQQ	ETF	29.87	29.87	29.87	29.87	950.0
2008-12-15 06:00:00	QQQ	ETF	29.91	30.0	29.91	30.0	1013.0
2008-12-15 07:00:00	QQQ	ETF	30.0	30.0	29.87	29.88	74441.0
2008-12-15 08:00:00	QQQ	ETF	29.88	29.95	29.69	29.86	1891346.0
2008-12-15 09:00:00	QQQ	ETF	29.86	29.93	29.24	29.25	13304815.0
2008-12-15 10:00:00	QQQ	ETF	29.24	29.55	28.84	28.8701	20098576.0
2008-12-15 11:00:00	QQQ	ETF	28.87	29.16	28.81	29.08	11839377.0
2008-12-15 12:00:00	QQQ	ETF	29.08	29.2	28.97	29.03	7292316.0
2008-12-15 13:00:00	QQQ	ETF	29.03	29.06	28.85	28.99	9724260.0
2008-12-15 14:00:00	QQQ	ETF	29.0	29.14	28.92	28.94	9505537.0
2008-12-15 15:00:00	QQQ	ETF	28.93	29.37	28.74	29.17	29419520.0
2008-12-15 16:00:00	QQQ	ETF	29.16	29.38	29.0621	29.35	3525524.0
2008-12-15 17:00:00	QQQ	ETF	29.35	29.37	29.32	29.32	85448.0
2008-12-15 18:00:00	QQQ	ETF	29.34	29.38	29.33	29.35	37218.0
2008-12-15 19:00:00	QQQ	ETF	29.33	29.33	29.29	29.32	38070.0
2008-12-15 05:00:00	IWM	ETF	47.19	47.19	47.19	47.19	3000.0
2008-12-15 07:00:00	IWM	ETF	47.36	47.37	47.21	47.35	15900.0
2008-12-15 08:00:00	IWM	ETF	47.36	47.52	46.91	47.32	141645.0
2008-12-15 09:00:00	IWM	ETF	47.31	47.56	46.66	46.67	8243827.0
2008-12-15 10:00:00	IWM	ETF	46.66	46.69	45.25	45.29	15139419.0
2008-12-15 11:00:00	IWM	ETF	45.28	45.93	45.07	45.8	10616637.0
2008-12-15 12:00:00	IWM	ETF	45.8	46.14	45.59	45.83	4393413.0
2008-12-15 13:00:00	IWM	ETF	45.82	45.9	45.24	45.7	6410339.0
2008-12-15 14:00:00	IWM	ETF	45.7	45.93	45.16	45.16	6180058.0
2008-12-15 15:00:00	IWM	ETF	45.17	45.75	44.62	45.36	20160565.0
2008-12-15 16:00:00	IWM	ETF	45.35	46.98	45.29	45.88	5593132.0
2008-12-15 17:00:00	IWM	ETF	46.98	46.98	45.86	45.9	1192781.0
2008-12-15 18:00:00	IWM	ETF	45.85	45.9	45.85	45.9	1164.0
2008-12-15 19:00:00	IWM	ETF	45.84	45.84	45.66	45.76	4280.0
2008-12-15 07:00:00	DIA	ETF	86.81	86.96	86.64	86.72	4018.0
2008-12-15 08:00:00	DIA	ETF	86.75	87.03	86.71	86.81	65093.0
2008-12-15 09:00:00	DIA	ETF	86.83	87.13	85.96	85.99	2117346.0
2008-12-15 10:00:00	DIA	ETF	85.98	86.11	85.36	85.44	4468745.0

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

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