PREVIEW / etf_1hour / 2008-03-06

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-03-06.parquet
  size:    102 KB
  rows:    3,394

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-03-06 04:00:00	SPY	ETF	133.55	133.55	133.35	133.35	21100.0
2008-03-06 05:00:00	SPY	ETF	133.25	133.25	133.0	133.14	80500.0
2008-03-06 06:00:00	SPY	ETF	133.23	133.55	133.14	133.38	56700.0
2008-03-06 07:00:00	SPY	ETF	133.4	133.61	133.0	133.09	1612700.0
2008-03-06 08:00:00	SPY	ETF	133.08	133.83	132.49	132.67	8866200.0
2008-03-06 09:00:00	SPY	ETF	132.67	133.45	132.43	132.62	32354428.0
2008-03-06 10:00:00	SPY	ETF	132.62	132.72	131.93	132.42	43163077.0
2008-03-06 11:00:00	SPY	ETF	132.42	132.54	131.88	132.24	26292257.0
2008-03-06 12:00:00	SPY	ETF	132.24	132.24	131.55	131.78	24879827.0
2008-03-06 13:00:00	SPY	ETF	131.79	132.09	131.48	131.8299	20300764.0
2008-03-06 14:00:00	SPY	ETF	131.82	132.16	131.5	131.73	17758146.0
2008-03-06 15:00:00	SPY	ETF	131.73	131.95	130.66	130.82	58421086.0
2008-03-06 16:00:00	SPY	ETF	130.77	132.5	130.55	131.25	7267727.0
2008-03-06 17:00:00	SPY	ETF	131.22	131.22	130.95	131.08	308700.0
2008-03-06 18:00:00	SPY	ETF	131.06	131.22	130.7672	131.17	1988300.0
2008-03-06 19:00:00	SPY	ETF	131.17	131.18	130.9	131.12	78200.0
2008-03-06 04:00:00	QQQ	ETF	43.16	43.22	43.16	43.22	800.0
2008-03-06 07:00:00	QQQ	ETF	43.2	43.32	43.15	43.15	744345.0
2008-03-06 08:00:00	QQQ	ETF	43.15	43.3	42.9	43.0	3164861.0
2008-03-06 09:00:00	QQQ	ETF	43.0	43.27	43.0	43.11	16398486.0
2008-03-06 10:00:00	QQQ	ETF	43.11	43.25	42.91	43.1299	27619646.0
2008-03-06 11:00:00	QQQ	ETF	43.13	43.17	42.91	43.0	15768883.0
2008-03-06 12:00:00	QQQ	ETF	43.0	43.0	42.63	42.64	17094367.0
2008-03-06 13:00:00	QQQ	ETF	42.6499	42.75	42.45	42.54	14164785.0
2008-03-06 14:00:00	QQQ	ETF	42.53	42.67	42.45	42.55	11217545.0
2008-03-06 15:00:00	QQQ	ETF	42.56	42.6	42.1	42.16	35954526.0
2008-03-06 16:00:00	QQQ	ETF	42.16	43.1594	42.07	42.25	9958086.0
2008-03-06 17:00:00	QQQ	ETF	42.25	42.28	42.19	42.21	266641.0
2008-03-06 18:00:00	QQQ	ETF	42.21	42.28	42.14	42.28	333398.0
2008-03-06 19:00:00	QQQ	ETF	42.22	42.26	42.17	42.19	65790.0
2008-03-06 07:00:00	IWM	ETF	68.41	68.41	67.93	67.95	57500.0
2008-03-06 08:00:00	IWM	ETF	67.93	67.95	67.65	67.74	274500.0
2008-03-06 09:00:00	IWM	ETF	67.77	68.09	67.56	67.66	9960081.0
2008-03-06 10:00:00	IWM	ETF	67.65	67.85	67.33	67.58	12834249.0
2008-03-06 11:00:00	IWM	ETF	67.58	67.65	67.03	67.25	11476848.0
2008-03-06 12:00:00	IWM	ETF	67.25	67.25	66.77	66.84	10504960.0
2008-03-06 13:00:00	IWM	ETF	66.84	67.09	66.54	66.75	11397815.0
2008-03-06 14:00:00	IWM	ETF	66.75	66.99	66.55	66.79	9836320.0
2008-03-06 15:00:00	IWM	ETF	66.79	66.85	65.98	66.03	23290719.0
2008-03-06 16:00:00	IWM	ETF	66.03	68.18	65.91	66.14	15622465.0
2008-03-06 17:00:00	IWM	ETF	66.1	66.3	65.9	66.04	9600.0
2008-03-06 18:00:00	IWM	ETF	65.98	66.14	65.91	66.14	16200.0
2008-03-06 06:00:00	DIA	ETF	122.59	122.59	122.59	122.59	300.0
2008-03-06 07:00:00	DIA	ETF	122.57	122.57	122.2	122.22	11300.0
2008-03-06 08:00:00	DIA	ETF	122.24	122.26	121.82	121.93	105000.0
2008-03-06 09:00:00	DIA	ETF	122.0	122.39	121.69	121.83	1460628.0
2008-03-06 10:00:00	DIA	ETF	121.83	121.88	121.28	121.64	2493492.0
2008-03-06 11:00:00	DIA	ETF	121.64	121.74	121.19	121.58	1691078.0
2008-03-06 12:00:00	DIA	ETF	121.59	121.62	121.03	121.29	1295694.0
2008-03-06 13:00:00	DIA	ETF	121.39	121.59	121.09	121.31	1174274.0

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

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