PREVIEW / etf_1hour / 2010-07-29

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-07-29.parquet
  size:    162 KB
  rows:    4,890

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
2010-07-29 04:00:00	SPY	ETF	110.92	111.43	110.92	111.36	1229.0
2010-07-29 05:00:00	SPY	ETF	111.38	111.38	111.26	111.29	15850.0
2010-07-29 06:00:00	SPY	ETF	111.34	111.37	111.26	111.26	59700.0
2010-07-29 07:00:00	SPY	ETF	111.26	111.46	111.23	111.27	317175.0
2010-07-29 08:00:00	SPY	ETF	111.24	111.58	111.11	111.56	3207415.0
2010-07-29 09:00:00	SPY	ETF	111.57	111.82	111.31	111.41	19570746.0
2010-07-29 10:00:00	SPY	ETF	111.42	111.42	110.87	111.08	24319308.0
2010-07-29 11:00:00	SPY	ETF	111.08	111.09	109.69	109.79	34048833.0
2010-07-29 12:00:00	SPY	ETF	109.79	109.97	109.41	109.94	24874132.0
2010-07-29 13:00:00	SPY	ETF	109.94	110.45	109.88	110.251	17689136.0
2010-07-29 14:00:00	SPY	ETF	110.251	110.87	110.01	110.72	27718187.0
2010-07-29 15:00:00	SPY	ETF	110.73	110.98	110.27	110.28	48415655.0
2010-07-29 16:00:00	SPY	ETF	110.29	111.285	109.805	110.21	13528894.0
2010-07-29 17:00:00	SPY	ETF	110.2	110.32	110.15	110.15	363675.0
2010-07-29 18:00:00	SPY	ETF	110.19	110.29	110.17	110.18	84490.0
2010-07-29 19:00:00	SPY	ETF	110.19	110.21	110.15	110.2	51930.0
2010-07-29 06:00:00	QQQ	ETF	46.16	46.17	46.14	46.14	7900.0
2010-07-29 07:00:00	QQQ	ETF	46.15	46.24	46.14	46.14	47417.0
2010-07-29 08:00:00	QQQ	ETF	46.16	46.3	46.12	46.29	966360.0
2010-07-29 09:00:00	QQQ	ETF	46.29	46.41	46.13	46.19	7632137.0
2010-07-29 10:00:00	QQQ	ETF	46.19	46.2	45.9	46.0	9882030.0
2010-07-29 11:00:00	QQQ	ETF	45.99	45.99	45.38	45.45	13530232.0
2010-07-29 12:00:00	QQQ	ETF	45.46	45.48	45.25	45.47	11850968.0
2010-07-29 13:00:00	QQQ	ETF	45.47	45.8041	45.43	45.71	8979487.0
2010-07-29 14:00:00	QQQ	ETF	45.71	46.1	45.61	46.03	11209827.0
2010-07-29 15:00:00	QQQ	ETF	46.03	46.14	45.7001	45.71	14508801.0
2010-07-29 16:00:00	QQQ	ETF	45.7001	46.3487	45.65	45.71	3320864.0
2010-07-29 17:00:00	QQQ	ETF	45.72	45.72	45.64	45.65	27726.0
2010-07-29 18:00:00	QQQ	ETF	45.65	45.7	45.65	45.66	40160.0
2010-07-29 19:00:00	QQQ	ETF	45.67	45.69	45.65	45.65	6050.0
2010-07-29 04:00:00	IWM	ETF	65.32	65.58	65.32	65.5	675.0
2010-07-29 05:00:00	IWM	ETF	65.53	65.53	65.53	65.53	500.0
2010-07-29 06:00:00	IWM	ETF	65.53	65.54	65.5	65.52	17950.0
2010-07-29 07:00:00	IWM	ETF	65.56	65.59	65.44	65.44	31500.0
2010-07-29 08:00:00	IWM	ETF	65.46	65.72	65.43	65.72	331392.0
2010-07-29 09:00:00	IWM	ETF	65.71	65.99	65.46	65.58	5651492.0
2010-07-29 10:00:00	IWM	ETF	65.59	65.59	65.12	65.3115	7551991.0
2010-07-29 11:00:00	IWM	ETF	65.32	65.32	64.09	64.2	10107476.0
2010-07-29 12:00:00	IWM	ETF	64.21	64.51	63.95	64.49	6721235.0
2010-07-29 13:00:00	IWM	ETF	64.5	65.07	64.421	64.901	6808989.0
2010-07-29 14:00:00	IWM	ETF	64.9001	65.5498	64.64	65.36	8659213.0
2010-07-29 15:00:00	IWM	ETF	65.35	65.5	64.95	64.97	13409481.0
2010-07-29 16:00:00	IWM	ETF	64.97	65.4003	64.83	64.93	1875346.0
2010-07-29 17:00:00	IWM	ETF	64.9	65.07	64.9	65.03	357240.0
2010-07-29 18:00:00	IWM	ETF	65.03	65.06	64.93	64.97	12817.0
2010-07-29 19:00:00	IWM	ETF	64.98	64.98	64.98	64.98	1100.0
2010-07-29 06:00:00	DIA	ETF	105.47	105.47	105.47	105.47	1000.0
2010-07-29 07:00:00	DIA	ETF	105.51	105.51	105.5	105.51	11600.0
2010-07-29 08:00:00	DIA	ETF	105.5	105.68	105.36	105.68	66350.0
2010-07-29 09:00:00	DIA	ETF	105.65	105.93	105.57	105.64	1078722.0

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

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