PREVIEW / etf_1hour / 2008-04-23

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-04-23.parquet
  size:    105 KB
  rows:    3,371

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-04-23 04:00:00	SPY	ETF	138.41	138.41	138.34	138.34	300.0
2008-04-23 06:00:00	SPY	ETF	138.2	138.2	137.6	137.64	154700.0
2008-04-23 07:00:00	SPY	ETF	137.64	137.7	137.26	137.64	1134583.0
2008-04-23 08:00:00	SPY	ETF	137.64	137.93	137.6	137.82	1967610.0
2008-04-23 09:00:00	SPY	ETF	137.79	138.17	137.44	137.61	20148795.0
2008-04-23 10:00:00	SPY	ETF	137.62	138.78	137.42	138.44	41113142.0
2008-04-23 11:00:00	SPY	ETF	138.43	138.59	138.09	138.19	22282983.0
2008-04-23 12:00:00	SPY	ETF	138.19	138.2	137.12	137.419	29939303.0
2008-04-23 13:00:00	SPY	ETF	137.43	137.81	137.29	137.73	18502995.0
2008-04-23 14:00:00	SPY	ETF	137.73	137.92	137.55	137.65	13940935.0
2008-04-23 15:00:00	SPY	ETF	137.65	138.16	137.63	137.97	31157491.0
2008-04-23 16:00:00	SPY	ETF	137.94	138.55	137.15	137.23	10023828.0
2008-04-23 17:00:00	SPY	ETF	137.27	137.45	137.04	137.44	552565.0
2008-04-23 18:00:00	SPY	ETF	137.42	137.46	137.34	137.42	153966.0
2008-04-23 19:00:00	SPY	ETF	137.4	137.4	137.23	137.25	11737.0
2008-04-23 04:00:00	QQQ	ETF	46.6	46.64	46.6	46.64	6100.0
2008-04-23 06:00:00	QQQ	ETF	46.57	46.61	46.5	46.52	4600.0
2008-04-23 07:00:00	QQQ	ETF	46.45	46.61	46.34	46.56	1222244.0
2008-04-23 08:00:00	QQQ	ETF	46.52	46.64	46.46	46.61	1475256.0
2008-04-23 09:00:00	QQQ	ETF	46.61	46.77	46.44	46.62	10592491.0
2008-04-23 10:00:00	QQQ	ETF	46.62	47.06	46.55	46.961	22839224.0
2008-04-23 11:00:00	QQQ	ETF	46.9695	47.05	46.9	46.9225	10311535.0
2008-04-23 12:00:00	QQQ	ETF	46.92	46.925	46.53	46.63	13926666.0
2008-04-23 13:00:00	QQQ	ETF	46.62	46.84	46.57	46.81	7366425.0
2008-04-23 14:00:00	QQQ	ETF	46.802	46.88	46.75	46.76	8409377.0
2008-04-23 15:00:00	QQQ	ETF	46.75	46.95	46.73	46.85	19834742.0
2008-04-23 16:00:00	QQQ	ETF	46.84	47.05	46.34	46.42	15035093.0
2008-04-23 17:00:00	QQQ	ETF	46.4	46.5	46.25	46.49	3580472.0
2008-04-23 18:00:00	QQQ	ETF	46.48	46.85	46.39	46.45	2804903.0
2008-04-23 19:00:00	QQQ	ETF	46.45	46.45	46.41	46.43	52004.0
2008-04-23 06:00:00	IWM	ETF	70.43	70.43	70.43	70.43	100.0
2008-04-23 07:00:00	IWM	ETF	70.14	70.19	70.09	70.19	40817.0
2008-04-23 08:00:00	IWM	ETF	70.16	70.38	70.14	70.34	208103.0
2008-04-23 09:00:00	IWM	ETF	70.34	70.56	69.99	70.06	5818899.0
2008-04-23 10:00:00	IWM	ETF	70.06	71.02	69.9	70.85	10225397.0
2008-04-23 11:00:00	IWM	ETF	70.84	70.88	70.59	70.63	5304029.0
2008-04-23 12:00:00	IWM	ETF	70.63	70.63	69.99	70.18	5865547.0
2008-04-23 13:00:00	IWM	ETF	70.18	70.42	70.07	70.38	4240138.0
2008-04-23 14:00:00	IWM	ETF	70.38	70.49	70.28	70.31	3155903.0
2008-04-23 15:00:00	IWM	ETF	70.31	70.73	70.3	70.7	8252492.0
2008-04-23 16:00:00	IWM	ETF	70.7	70.72	70.0	70.07	2556785.0
2008-04-23 17:00:00	IWM	ETF	70.1	70.38	69.95	70.1	58055.0
2008-04-23 18:00:00	IWM	ETF	70.26	70.26	70.1	70.2	5800.0
2008-04-23 04:00:00	DIA	ETF	127.44	127.44	127.44	127.44	100.0
2008-04-23 07:00:00	DIA	ETF	127.03	127.13	127.03	127.13	40500.0
2008-04-23 08:00:00	DIA	ETF	127.21	127.34	127.12	127.32	9483.0
2008-04-23 09:00:00	DIA	ETF	127.25	127.58	126.97	127.09	1155733.0
2008-04-23 10:00:00	DIA	ETF	127.1	128.24	126.97	127.94	2516688.0
2008-04-23 11:00:00	DIA	ETF	127.93	128.07	127.09	127.79	1919970.0
2008-04-23 12:00:00	DIA	ETF	127.78	127.78	126.91	127.13	1356152.0

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

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