PREVIEW / etf_1hour / 2008-09-17

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-09-17.parquet
  size:    120 KB
  rows:    3,887

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-09-17 04:00:00	SPY	ETF	121.0	121.63	120.89	121.63	32700.0
2008-09-17 05:00:00	SPY	ETF	121.6	121.75	121.33	121.44	43100.0
2008-09-17 06:00:00	SPY	ETF	121.33	121.55	120.89	121.5	874332.0
2008-09-17 07:00:00	SPY	ETF	121.5	121.8	121.24	121.26	3816595.0
2008-09-17 08:00:00	SPY	ETF	121.27	122.7	119.58	119.59	18284255.0
2008-09-17 09:00:00	SPY	ETF	119.59	120.34	118.94	120.07	59607502.0
2008-09-17 10:00:00	SPY	ETF	120.07	120.38	118.41	118.73	68634326.0
2008-09-17 11:00:00	SPY	ETF	118.74	118.87	117.14	117.77	79149973.0
2008-09-17 12:00:00	SPY	ETF	117.77	121.8517	116.71	117.98	71581167.0
2008-09-17 13:00:00	SPY	ETF	117.98	118.54	116.0	117.18	64917524.0
2008-09-17 14:00:00	SPY	ETF	117.19	121.8517	116.87	118.59	97524153.0
2008-09-17 15:00:00	SPY	ETF	118.59	121.8516	116.02	116.3	106203708.0
2008-09-17 16:00:00	SPY	ETF	116.32	121.8517	116.13	116.9	32002489.0
2008-09-17 17:00:00	SPY	ETF	116.86	121.8517	116.65	116.65	17854976.0
2008-09-17 18:00:00	SPY	ETF	116.65	121.8517	116.21	116.72	2503556.0
2008-09-17 19:00:00	SPY	ETF	116.77	116.85	116.62	116.79	235506.0
2008-09-17 04:00:00	QQQ	ETF	42.12	42.3	42.07	42.3	6200.0
2008-09-17 05:00:00	QQQ	ETF	42.35	42.38	42.27	42.28	2700.0
2008-09-17 06:00:00	QQQ	ETF	42.33	42.38	42.13	42.37	38300.0
2008-09-17 07:00:00	QQQ	ETF	42.44	42.45	42.17	42.33	798236.0
2008-09-17 08:00:00	QQQ	ETF	42.32	42.8	41.96	41.97	5447566.0
2008-09-17 09:00:00	QQQ	ETF	41.97	42.05	41.4999	41.92	40765414.0
2008-09-17 10:00:00	QQQ	ETF	41.92	42.0	41.33	41.43	47925862.0
2008-09-17 11:00:00	QQQ	ETF	41.43	41.46	40.87	41.12	43443091.0
2008-09-17 12:00:00	QQQ	ETF	41.11	41.26	40.84	41.0599	33612822.0
2008-09-17 13:00:00	QQQ	ETF	41.05	41.27	40.55	40.7001	32553839.0
2008-09-17 14:00:00	QQQ	ETF	40.7	41.24	40.52	41.03	52593790.0
2008-09-17 15:00:00	QQQ	ETF	41.03	41.48	40.19	40.22	64813704.0
2008-09-17 16:00:00	QQQ	ETF	40.22	40.66	40.2	40.42	9385807.0
2008-09-17 17:00:00	QQQ	ETF	40.42	40.43	40.3	40.37	930505.0
2008-09-17 18:00:00	QQQ	ETF	40.37	40.47	40.32	40.32	151090.0
2008-09-17 19:00:00	QQQ	ETF	40.38	40.39	40.32	40.39	164320.0
2008-09-17 06:00:00	IWM	ETF	71.0	71.24	71.0	71.24	4200.0
2008-09-17 07:00:00	IWM	ETF	71.24	71.3	70.99	71.04	387894.0
2008-09-17 08:00:00	IWM	ETF	71.04	71.13	70.28	70.29	1369172.0
2008-09-17 09:00:00	IWM	ETF	70.28	70.34	69.2	69.81	31118338.0
2008-09-17 10:00:00	IWM	ETF	69.81	69.96	68.37	68.68	41245166.0
2008-09-17 11:00:00	IWM	ETF	68.68	68.76	67.84	68.23	27164068.0
2008-09-17 12:00:00	IWM	ETF	68.23	68.59	67.64	68.35	28611582.0
2008-09-17 13:00:00	IWM	ETF	68.34	68.55	67.63	67.88	21916491.0
2008-09-17 14:00:00	IWM	ETF	67.88	68.91	67.87	68.45	33554529.0
2008-09-17 15:00:00	IWM	ETF	68.45	69.03	67.45	67.61	50210733.0
2008-09-17 16:00:00	IWM	ETF	67.61	71.01	67.61	71.01	13869248.0
2008-09-17 17:00:00	IWM	ETF	68.65	71.01	68.19	68.45	2312607.0
2008-09-17 18:00:00	IWM	ETF	68.5	71.01	68.09	68.41	4692719.0
2008-09-17 19:00:00	IWM	ETF	68.5	68.62	68.39	68.5	5327.0
2008-09-17 06:00:00	DIA	ETF	110.35	110.35	110.35	110.35	100.0
2008-09-17 07:00:00	DIA	ETF	110.67	110.76	110.41	110.47	16401.0
2008-09-17 08:00:00	DIA	ETF	110.41	110.55	109.09	109.09	169366.0
2008-09-17 09:00:00	DIA	ETF	109.12	109.59	108.57	109.29	4899871.0

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

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