PREVIEW / etf_1hour / 2015-04-30

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-04-30.parquet
  size:    248 KB
  rows:    7,906

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
2015-04-30 04:00:00	SPY	ETF	210.05	210.14	209.58	210.01	33099.0
2015-04-30 05:00:00	SPY	ETF	209.88	210.0	209.64	209.87	45385.0
2015-04-30 06:00:00	SPY	ETF	209.76	210.02	209.76	209.98	36301.0
2015-04-30 07:00:00	SPY	ETF	209.99	210.09	209.82	210.02	266052.0
2015-04-30 08:00:00	SPY	ETF	210.01	210.42	209.89	210.14	1536052.0
2015-04-30 09:00:00	SPY	ETF	210.14	210.35	209.28	209.3	15681982.0
2015-04-30 10:00:00	SPY	ETF	209.29	209.52	208.92	209.26	21838991.0
2015-04-30 11:00:00	SPY	ETF	209.25	210.2	209.25	209.45	15307856.0
2015-04-30 12:00:00	SPY	ETF	209.44	209.72	208.97	209.31	11209130.0
2015-04-30 13:00:00	SPY	ETF	209.315	209.54	209.19	209.245	7075200.0
2015-04-30 14:00:00	SPY	ETF	209.245	209.43	208.15	208.195	20691378.0
2015-04-30 15:00:00	SPY	ETF	208.19	209.6508	207.62	208.46	44198334.0
2015-04-30 16:00:00	SPY	ETF	208.46	210.5869	208.1775	208.82	17447233.0
2015-04-30 17:00:00	SPY	ETF	208.82	208.94	208.81	208.83	629745.0
2015-04-30 18:00:00	SPY	ETF	208.83	208.9	208.46	208.76	372137.0
2015-04-30 19:00:00	SPY	ETF	208.78	208.78	208.65	208.71	70805.0
2015-04-30 04:00:00	QQQ	ETF	108.93	108.93	108.65	108.78	10900.0
2015-04-30 05:00:00	QQQ	ETF	108.66	108.66	108.66	108.66	6200.0
2015-04-30 06:00:00	QQQ	ETF	108.73	108.8	108.73	108.8	13500.0
2015-04-30 07:00:00	QQQ	ETF	108.91	108.91	108.7	108.79	44971.0
2015-04-30 08:00:00	QQQ	ETF	108.8	109.03	108.72	108.93	343419.0
2015-04-30 09:00:00	QQQ	ETF	108.94	109.17	108.53	108.534	5678830.0
2015-04-30 10:00:00	QQQ	ETF	108.53	108.7	108.13	108.26	5151900.0
2015-04-30 11:00:00	QQQ	ETF	108.26	108.805	108.25	108.29	3599068.0
2015-04-30 12:00:00	QQQ	ETF	108.3	108.48	107.93	108.12	2787442.0
2015-04-30 13:00:00	QQQ	ETF	108.121	108.24	107.95	107.95	3146523.0
2015-04-30 14:00:00	QQQ	ETF	107.96	108.08	107.45	107.47	4703526.0
2015-04-30 15:00:00	QQQ	ETF	107.47	107.62	107.06	107.61	10355678.0
2015-04-30 16:00:00	QQQ	ETF	107.61	107.85	107.45	107.73	1639152.0
2015-04-30 17:00:00	QQQ	ETF	107.73	107.78	107.73	107.73	272553.0
2015-04-30 18:00:00	QQQ	ETF	107.73	107.76	107.63	107.73	1831527.0
2015-04-30 19:00:00	QQQ	ETF	107.73	107.73	107.62	107.62	50671.0
2015-04-30 04:00:00	IWM	ETF	123.19	123.19	123.19	123.19	200.0
2015-04-30 05:00:00	IWM	ETF	122.84	122.84	122.84	122.84	200.0
2015-04-30 06:00:00	IWM	ETF	123.25	123.25	123.22	123.22	2500.0
2015-04-30 07:00:00	IWM	ETF	123.15	123.15	122.94	123.1	18524.0
2015-04-30 08:00:00	IWM	ETF	123.11	123.35	123.02	123.21	568607.0
2015-04-30 09:00:00	IWM	ETF	123.22	123.44	122.44	122.46	6372764.0
2015-04-30 10:00:00	IWM	ETF	122.485	122.485	121.91	122.19	9271149.0
2015-04-30 11:00:00	IWM	ETF	122.185	122.75	122.14	122.1499	5588997.0
2015-04-30 12:00:00	IWM	ETF	122.14	122.37	122.04	122.32	2937376.0
2015-04-30 13:00:00	IWM	ETF	122.32	122.58	121.97	122.03	3515571.0
2015-04-30 14:00:00	IWM	ETF	122.03	122.07	121.06	121.07	7838241.0
2015-04-30 15:00:00	IWM	ETF	121.07	121.55	120.66	121.2	14875407.0
2015-04-30 16:00:00	IWM	ETF	121.2	123.8814	121.15	121.57	3845055.0
2015-04-30 17:00:00	IWM	ETF	121.59	121.61	121.5	121.5	36413.0
2015-04-30 18:00:00	IWM	ETF	121.61	121.61	121.18	121.5	247436.0
2015-04-30 19:00:00	IWM	ETF	121.52	121.55	121.35	121.55	2610.0
2015-04-30 07:00:00	DIA	ETF	179.58	179.67	179.52	179.67	700.0
2015-04-30 08:00:00	DIA	ETF	179.7	179.8	179.68	179.8	400.0

> showing 50 of 7,906 rows — these rows as CSV

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