PREVIEW / etf_1hour / 2008-03-03

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-03-03.parquet
  size:    101 KB
  rows:    3,363

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-03 04:00:00	SPY	ETF	132.73	132.9	132.61	132.9	4400.0
2008-03-03 05:00:00	SPY	ETF	133.04	133.1	132.92	133.06	26800.0
2008-03-03 06:00:00	SPY	ETF	132.98	132.98	132.51	132.74	219000.0
2008-03-03 07:00:00	SPY	ETF	132.71	133.11	132.63	133.11	897200.0
2008-03-03 08:00:00	SPY	ETF	133.11	133.82	132.3	133.25	3393100.0
2008-03-03 09:00:00	SPY	ETF	133.25	133.3	132.43	132.6	30372237.0
2008-03-03 10:00:00	SPY	ETF	132.6	133.73	132.5	132.99	37466956.0
2008-03-03 11:00:00	SPY	ETF	132.98	133.62	132.7	133.52	20063218.0
2008-03-03 12:00:00	SPY	ETF	133.52	133.81	133.12	133.29	16439597.0
2008-03-03 13:00:00	SPY	ETF	133.29	133.6	133.05	133.13	13449847.0
2008-03-03 14:00:00	SPY	ETF	133.13	133.57	132.24	132.35	28775924.0
2008-03-03 15:00:00	SPY	ETF	132.3499	133.47	132.33	133.41	31947418.0
2008-03-03 16:00:00	SPY	ETF	133.4201	133.63	133.27	133.6	4287700.0
2008-03-03 17:00:00	SPY	ETF	133.61	133.96	132.35	133.71	379800.0
2008-03-03 18:00:00	SPY	ETF	133.73	133.74	133.36	133.61	6147400.0
2008-03-03 19:00:00	SPY	ETF	133.57	133.57	133.32	133.32	31000.0
2008-03-03 04:00:00	QQQ	ETF	42.77	42.77	42.75	42.75	300.0
2008-03-03 06:00:00	QQQ	ETF	42.75	42.75	42.72	42.74	25200.0
2008-03-03 07:00:00	QQQ	ETF	42.75	42.9	42.73	42.9	107222.0
2008-03-03 08:00:00	QQQ	ETF	42.89	42.99	42.86	42.91	1297898.0
2008-03-03 09:00:00	QQQ	ETF	42.91	42.98	42.63	42.73	16411482.0
2008-03-03 10:00:00	QQQ	ETF	42.72	42.99	42.62	42.67	24689948.0
2008-03-03 11:00:00	QQQ	ETF	42.67	42.87	42.5	42.8499	14592381.0
2008-03-03 12:00:00	QQQ	ETF	42.85	42.93	42.69	42.73	13621144.0
2008-03-03 13:00:00	QQQ	ETF	42.73	42.82	42.61	42.67	13447403.0
2008-03-03 14:00:00	QQQ	ETF	42.67	42.67	42.24	42.28	18260137.0
2008-03-03 15:00:00	QQQ	ETF	42.29	42.69	42.28	42.68	24342563.0
2008-03-03 16:00:00	QQQ	ETF	42.67	42.76	42.58	42.74	5508291.0
2008-03-03 17:00:00	QQQ	ETF	42.74	42.84	41.86	42.75	511515.0
2008-03-03 18:00:00	QQQ	ETF	42.71	42.71	42.54	42.54	573303.0
2008-03-03 19:00:00	QQQ	ETF	42.55	42.56	42.53	42.55	264941.0
2008-03-03 07:00:00	IWM	ETF	68.3	68.5	68.26	68.5	149800.0
2008-03-03 08:00:00	IWM	ETF	68.54	68.61	68.44	68.51	413300.0
2008-03-03 09:00:00	IWM	ETF	68.53	68.55	67.71	68.01	9743190.0
2008-03-03 10:00:00	IWM	ETF	68.01	68.72	67.92	68.19	14664416.0
2008-03-03 11:00:00	IWM	ETF	68.19	68.56	67.87	68.48	12164731.0
2008-03-03 12:00:00	IWM	ETF	68.49	68.6	68.14	68.25	5758855.0
2008-03-03 13:00:00	IWM	ETF	68.25	68.4	67.95	67.95	5469974.0
2008-03-03 14:00:00	IWM	ETF	67.94	67.98	67.21	67.35	16399208.0
2008-03-03 15:00:00	IWM	ETF	67.36	68.25	67.34	68.25	17983426.0
2008-03-03 16:00:00	IWM	ETF	68.23	68.4	67.99	68.28	2536000.0
2008-03-03 17:00:00	IWM	ETF	68.28	68.59	68.2	68.37	75100.0
2008-03-03 18:00:00	IWM	ETF	68.16	68.24	68.16	68.22	500900.0
2008-03-03 19:00:00	IWM	ETF	68.2	68.2	68.11	68.13	8700.0
2008-03-03 07:00:00	DIA	ETF	122.19	122.37	122.19	122.33	7500.0
2008-03-03 08:00:00	DIA	ETF	122.44	122.64	122.3	122.54	95500.0
2008-03-03 09:00:00	DIA	ETF	122.5	122.59	121.73	121.83	1358285.0
2008-03-03 10:00:00	DIA	ETF	121.83	122.7	121.77	122.1	2332218.0
2008-03-03 11:00:00	DIA	ETF	122.1	122.69	121.87	122.62	1608935.0
2008-03-03 12:00:00	DIA	ETF	122.63	122.85	122.29	122.41	1009227.0

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

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