PREVIEW / etf_1hour / 2008-03-18

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-03-18.parquet
  size:    103 KB
  rows:    3,386

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-18 04:00:00	SPY	ETF	129.26	129.31	129.12	129.26	10100.0
2008-03-18 05:00:00	SPY	ETF	129.28	129.59	129.28	129.54	4500.0
2008-03-18 06:00:00	SPY	ETF	129.5	129.78	129.35	129.75	202800.0
2008-03-18 07:00:00	SPY	ETF	129.81	130.14	129.63	130.04	1326500.0
2008-03-18 08:00:00	SPY	ETF	130.03	130.49	129.35	130.37	10969900.0
2008-03-18 09:00:00	SPY	ETF	130.37	130.95	128.37	130.79	27105812.0
2008-03-18 10:00:00	SPY	ETF	130.79	131.31	130.62	131.26	31870865.0
2008-03-18 11:00:00	SPY	ETF	131.26	131.68	131.19	131.36	21987251.0
2008-03-18 12:00:00	SPY	ETF	131.36	131.83	131.21	131.71	20460688.0
2008-03-18 13:00:00	SPY	ETF	131.71	132.06	131.6	131.9	22465247.0
2008-03-18 14:00:00	SPY	ETF	131.9	132.62	129.98	132.489	114583946.0
2008-03-18 15:00:00	SPY	ETF	132.5	133.38	130.67	133.32	59552476.0
2008-03-18 16:00:00	SPY	ETF	133.32	133.7	133.1	133.6	14472446.0
2008-03-18 17:00:00	SPY	ETF	133.6	133.7	133.251	133.62	5509000.0
2008-03-18 18:00:00	SPY	ETF	133.62	133.63	133.5	133.52	144700.0
2008-03-18 19:00:00	SPY	ETF	133.5	133.59	133.48	133.58	29800.0
2008-03-18 04:00:00	QQQ	ETF	41.93	42.03	41.93	42.03	800.0
2008-03-18 05:00:00	QQQ	ETF	41.96	41.96	41.96	41.96	100.0
2008-03-18 07:00:00	QQQ	ETF	42.03	42.09	41.99	42.0	374090.0
2008-03-18 08:00:00	QQQ	ETF	42.0	42.18	41.99	42.17	3293672.0
2008-03-18 09:00:00	QQQ	ETF	42.16	42.47	42.14	42.2901	24553411.0
2008-03-18 10:00:00	QQQ	ETF	42.3	42.42	42.25	42.38	11634926.0
2008-03-18 11:00:00	QQQ	ETF	42.38	42.56	42.35	42.43	14447150.0
2008-03-18 12:00:00	QQQ	ETF	42.44	42.66	42.39	42.6207	12705180.0
2008-03-18 13:00:00	QQQ	ETF	42.62	42.78	42.6	42.7	11910748.0
2008-03-18 14:00:00	QQQ	ETF	42.71	42.97	42.11	42.94	73501696.0
2008-03-18 15:00:00	QQQ	ETF	42.94	43.34	42.77	43.32	35214586.0
2008-03-18 16:00:00	QQQ	ETF	43.32	43.5	42.92	43.44	7763360.0
2008-03-18 17:00:00	QQQ	ETF	43.43	43.46	41.5246	43.42	5593915.0
2008-03-18 18:00:00	QQQ	ETF	43.44	43.48	43.43	43.44	42245.0
2008-03-18 19:00:00	QQQ	ETF	43.44	43.49	43.42	43.49	47608.0
2008-03-18 04:00:00	IWM	ETF	65.56	65.56	65.56	65.56	100.0
2008-03-18 05:00:00	IWM	ETF	65.64	65.64	65.64	65.64	100.0
2008-03-18 06:00:00	IWM	ETF	65.74	65.74	65.74	65.74	2500.0
2008-03-18 07:00:00	IWM	ETF	66.0	66.1	65.97	66.1	64400.0
2008-03-18 08:00:00	IWM	ETF	66.07	66.35	65.87	66.29	973000.0
2008-03-18 09:00:00	IWM	ETF	66.29	66.78	66.28	66.47	13106376.0
2008-03-18 10:00:00	IWM	ETF	66.47	66.88	66.28	66.82	11540370.0
2008-03-18 11:00:00	IWM	ETF	66.82	67.04	66.5	66.56	7862448.0
2008-03-18 12:00:00	IWM	ETF	66.56	67.09	66.52	67.02	9569885.0
2008-03-18 13:00:00	IWM	ETF	67.02	67.2	66.87	66.96	14805386.0
2008-03-18 14:00:00	IWM	ETF	66.95	67.56	65.31	67.51	39462321.0
2008-03-18 15:00:00	IWM	ETF	67.5	68.18	67.14	68.03	47461146.0
2008-03-18 16:00:00	IWM	ETF	68.03	68.2	66.95	68.0	6442900.0
2008-03-18 17:00:00	IWM	ETF	68.05	68.07	68.03	68.03	4900.0
2008-03-18 18:00:00	IWM	ETF	67.98	68.05	67.98	68.0	4502800.0
2008-03-18 19:00:00	IWM	ETF	68.06	68.08	67.96	67.96	1500.0
2008-03-18 07:00:00	DIA	ETF	121.25	121.54	121.2	121.35	3000.0
2008-03-18 08:00:00	DIA	ETF	121.41	121.74	121.34	121.56	69800.0
2008-03-18 09:00:00	DIA	ETF	121.61	122.14	121.61	122.05	2396002.0

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

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