PREVIEW / etf_1hour / 2009-10-29

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-10-29.parquet
  size:    149 KB
  rows:    4,529

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
2009-10-29 04:00:00	SPY	ETF	104.7	104.82	104.68	104.75	8900.0
2009-10-29 05:00:00	SPY	ETF	104.72	104.88	104.7	104.8	3550.0
2009-10-29 06:00:00	SPY	ETF	104.78	104.8	104.67	104.79	17500.0
2009-10-29 07:00:00	SPY	ETF	104.87	104.9	104.6	104.65	460882.0
2009-10-29 08:00:00	SPY	ETF	104.66	105.44	104.47	105.43	8691375.0
2009-10-29 09:00:00	SPY	ETF	105.43	105.46	104.94	105.29	32069799.0
2009-10-29 10:00:00	SPY	ETF	105.29	105.87	105.2	105.72	29487062.0
2009-10-29 11:00:00	SPY	ETF	105.71	105.93	105.66	105.8	17180436.0
2009-10-29 12:00:00	SPY	ETF	105.8	106.42	105.745	106.26	17659425.0
2009-10-29 13:00:00	SPY	ETF	106.26	106.5	106.18	106.38	14476226.0
2009-10-29 14:00:00	SPY	ETF	106.38	106.69	106.26	106.68	17969601.0
2009-10-29 15:00:00	SPY	ETF	106.68	106.86	106.35	106.64	49862799.0
2009-10-29 16:00:00	SPY	ETF	106.64	106.76	104.4107	106.51	8721502.0
2009-10-29 17:00:00	SPY	ETF	106.51	106.68	106.46	106.61	155562.0
2009-10-29 18:00:00	SPY	ETF	106.63	106.71	106.63	106.69	60872.0
2009-10-29 19:00:00	SPY	ETF	106.7	106.71	106.54	106.61	36415.0
2009-10-29 04:00:00	QQQ	ETF	41.51	41.52	41.51	41.52	400.0
2009-10-29 05:00:00	QQQ	ETF	41.48	41.48	41.48	41.48	200.0
2009-10-29 06:00:00	QQQ	ETF	41.51	41.51	41.46	41.48	1600.0
2009-10-29 07:00:00	QQQ	ETF	41.52	41.53	41.44	41.45	323600.0
2009-10-29 08:00:00	QQQ	ETF	41.46	41.86	41.4	41.85	3345013.0
2009-10-29 09:00:00	QQQ	ETF	41.85	41.86	41.54	41.72	15258421.0
2009-10-29 10:00:00	QQQ	ETF	41.72	41.98	41.69	41.94	16616052.0
2009-10-29 11:00:00	QQQ	ETF	41.93	42.0	41.87	41.92	10452663.0
2009-10-29 12:00:00	QQQ	ETF	41.91	42.08	41.88	41.99	7679531.0
2009-10-29 13:00:00	QQQ	ETF	41.99	42.0401	41.93	42.0099	6604026.0
2009-10-29 14:00:00	QQQ	ETF	42.0	42.14	41.94	42.1201	4813302.0
2009-10-29 15:00:00	QQQ	ETF	42.12	42.19	41.992	42.08	14977117.0
2009-10-29 16:00:00	QQQ	ETF	42.09	42.09	41.994	42.01	3669780.0
2009-10-29 17:00:00	QQQ	ETF	42.02	42.08	42.01	42.07	119131.0
2009-10-29 18:00:00	QQQ	ETF	42.07	42.11	42.07	42.11	160778.0
2009-10-29 19:00:00	QQQ	ETF	42.11	42.11	42.06	42.07	58078.0
2009-10-29 07:00:00	IWM	ETF	57.09	57.09	56.99	57.0	7784.0
2009-10-29 08:00:00	IWM	ETF	57.15	57.58	56.87	57.58	1280154.0
2009-10-29 09:00:00	IWM	ETF	57.59	57.61	57.12	57.48	11238122.0
2009-10-29 10:00:00	IWM	ETF	57.48	57.8799	57.4	57.79	17344578.0
2009-10-29 11:00:00	IWM	ETF	57.78	58.0	57.77	57.85	6778704.0
2009-10-29 12:00:00	IWM	ETF	57.85	58.07	57.785	57.97	6175851.0
2009-10-29 13:00:00	IWM	ETF	57.98	58.04	57.75	57.908	4366204.0
2009-10-29 14:00:00	IWM	ETF	57.9	58.09	57.77	58.048	3964609.0
2009-10-29 15:00:00	IWM	ETF	58.04	58.24	57.75	57.93	13814124.0
2009-10-29 16:00:00	IWM	ETF	57.94	58.07	56.6885	57.79	5216579.0
2009-10-29 17:00:00	IWM	ETF	57.8	57.8	57.8	57.8	3000.0
2009-10-29 18:00:00	IWM	ETF	57.93	57.94	57.9	57.9	1100.0
2009-10-29 06:00:00	DIA	ETF	97.95	97.95	97.95	97.95	100.0
2009-10-29 07:00:00	DIA	ETF	97.99	98.15	97.99	98.02	20800.0
2009-10-29 08:00:00	DIA	ETF	98.07	98.5	97.81	98.5	84862.0
2009-10-29 09:00:00	DIA	ETF	98.55	98.57	98.05	98.35	1377391.0
2009-10-29 10:00:00	DIA	ETF	98.37	98.705	98.27	98.57	1958131.0
2009-10-29 11:00:00	DIA	ETF	98.57	98.85	98.56	98.77	1408811.0

> showing 50 of 4,529 rows — these rows as CSV

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