PREVIEW / etf_1hour / 2008-12-23

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-12-23.parquet
  size:    127 KB
  rows:    3,855

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-23 04:00:00	SPY	ETF	87.38	87.81	87.38	87.79	6960.0
2008-12-23 05:00:00	SPY	ETF	87.75	87.95	87.65	87.95	7226.0
2008-12-23 06:00:00	SPY	ETF	87.69	87.72	87.32	87.42	11030.0
2008-12-23 07:00:00	SPY	ETF	87.5	87.8	87.13	87.25	368292.0
2008-12-23 08:00:00	SPY	ETF	87.28	87.75	87.0	87.5	1310270.0
2008-12-23 09:00:00	SPY	ETF	87.49	87.8	87.195	87.64	21480792.0
2008-12-23 10:00:00	SPY	ETF	87.64	87.93	87.08	87.42	42635347.0
2008-12-23 11:00:00	SPY	ETF	87.42	87.57	86.53	86.55	26689822.0
2008-12-23 12:00:00	SPY	ETF	86.56	86.63	86.17	86.53	25592594.0
2008-12-23 13:00:00	SPY	ETF	86.53	86.89	86.33	86.82	17170693.0
2008-12-23 14:00:00	SPY	ETF	86.83	87.49	85.91	86.11	32111898.0
2008-12-23 15:00:00	SPY	ETF	86.11	86.59	85.8	86.17	38675196.0
2008-12-23 16:00:00	SPY	ETF	86.16	86.9983	85.75	86.15	14120618.0
2008-12-23 17:00:00	SPY	ETF	86.12	86.21	86.09	86.13	55655.0
2008-12-23 18:00:00	SPY	ETF	86.12	86.3	86.04	86.3	81102.0
2008-12-23 19:00:00	SPY	ETF	86.26	86.39	86.16	86.21	40636.0
2008-12-23 05:00:00	QQQ	ETF	29.37	29.44	29.37	29.42	1070.0
2008-12-23 07:00:00	QQQ	ETF	29.3	29.47	29.27	29.31	56896.0
2008-12-23 08:00:00	QQQ	ETF	29.29	29.38	29.2	29.32	773572.0
2008-12-23 09:00:00	QQQ	ETF	29.31	29.55	29.2579	29.53	7361013.0
2008-12-23 10:00:00	QQQ	ETF	29.52	29.62	29.32	29.45	17007496.0
2008-12-23 11:00:00	QQQ	ETF	29.45	29.52	29.14	29.16	8542533.0
2008-12-23 12:00:00	QQQ	ETF	29.16	29.19	28.99	29.1204	8245515.0
2008-12-23 13:00:00	QQQ	ETF	29.12	29.2	29.05	29.18	4903155.0
2008-12-23 14:00:00	QQQ	ETF	29.18	29.19	28.89	28.99	7662017.0
2008-12-23 15:00:00	QQQ	ETF	28.99	29.2	28.92	29.08	11512816.0
2008-12-23 16:00:00	QQQ	ETF	29.07	29.16	29.0	29.12	1041222.0
2008-12-23 17:00:00	QQQ	ETF	29.12	29.16	29.11	29.11	81691.0
2008-12-23 18:00:00	QQQ	ETF	29.1	29.11	29.08	29.11	33730.0
2008-12-23 19:00:00	QQQ	ETF	29.15	29.15	29.09	29.09	5965.0
2008-12-23 07:00:00	IWM	ETF	47.75	47.78	47.59	47.59	14516.0
2008-12-23 08:00:00	IWM	ETF	47.59	48.34	47.56	47.76	269233.0
2008-12-23 09:00:00	IWM	ETF	47.74	48.0	47.36	47.89	7485127.0
2008-12-23 10:00:00	IWM	ETF	47.89	48.0	47.22	47.24	11665631.0
2008-12-23 11:00:00	IWM	ETF	47.22	47.4	46.93	46.95	8297110.0
2008-12-23 12:00:00	IWM	ETF	46.94	47.01	46.43	46.64	7680982.0
2008-12-23 13:00:00	IWM	ETF	46.64	46.78	46.42	46.77	4735593.0
2008-12-23 14:00:00	IWM	ETF	46.77	46.96	46.37	46.57	7499509.0
2008-12-23 15:00:00	IWM	ETF	46.56	46.96	46.34	46.49	12298471.0
2008-12-23 16:00:00	IWM	ETF	46.49	47.3242	46.3	46.56	1983191.0
2008-12-23 17:00:00	IWM	ETF	46.53	46.58	46.53	46.53	15400.0
2008-12-23 18:00:00	IWM	ETF	46.64	46.64	46.64	46.64	200.0
2008-12-23 19:00:00	IWM	ETF	46.64	46.64	46.64	46.64	100.0
2008-12-23 04:00:00	DIA	ETF	82.5	82.5	82.5	82.5	100.0
2008-12-23 06:00:00	DIA	ETF	85.54	85.54	85.54	85.54	408.0
2008-12-23 07:00:00	DIA	ETF	85.55	85.81	85.42	85.42	9592.0
2008-12-23 08:00:00	DIA	ETF	85.38	85.63	85.34	85.62	107492.0
2008-12-23 09:00:00	DIA	ETF	85.58	85.88	85.1242	85.66	1964699.0
2008-12-23 10:00:00	DIA	ETF	85.66	85.93	85.08	85.4201	3149674.0
2008-12-23 11:00:00	DIA	ETF	85.42	85.52	84.69	84.73	1919243.0

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

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