PREVIEW / etf_1hour / 2017-09-29

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-09-29.parquet
  size:    279 KB
  rows:    9,145

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
2017-09-29 04:00:00	SPY	ETF	250.23	250.32	250.23	250.24	22550.0
2017-09-29 05:00:00	SPY	ETF	250.29	250.3	250.24	250.29	8400.0
2017-09-29 06:00:00	SPY	ETF	250.29	250.36	250.29	250.36	17779.0
2017-09-29 07:00:00	SPY	ETF	250.34	250.34	250.23	250.28	104380.0
2017-09-29 08:00:00	SPY	ETF	250.35	250.35	250.16	250.22	104263.0
2017-09-29 09:00:00	SPY	ETF	250.23	250.56	250.13	250.3	4867455.0
2017-09-29 10:00:00	SPY	ETF	250.31	250.79	250.29	250.74	5579277.0
2017-09-29 11:00:00	SPY	ETF	250.74	251.0	250.67	250.99	7338503.0
2017-09-29 12:00:00	SPY	ETF	250.99	251.16	250.95	251.09	3343435.0
2017-09-29 13:00:00	SPY	ETF	251.095	251.12	250.96	251.04	4820901.0
2017-09-29 14:00:00	SPY	ETF	251.046	251.09	250.88	251.02	9629241.0
2017-09-29 15:00:00	SPY	ETF	251.01	251.32	250.97	251.2	21724821.0
2017-09-29 16:00:00	SPY	ETF	251.21	251.42	250.8323	251.4	24324434.0
2017-09-29 17:00:00	SPY	ETF	251.39	251.47	251.23	251.25	419621.0
2017-09-29 18:00:00	SPY	ETF	251.25	251.39	251.24	251.38	92338.0
2017-09-29 19:00:00	SPY	ETF	251.35	251.44	251.33	251.44	39476.0
2017-09-29 04:00:00	QQQ	ETF	144.5	144.56	144.5	144.56	3300.0
2017-09-29 05:00:00	QQQ	ETF	144.55	144.58	144.55	144.58	2600.0
2017-09-29 06:00:00	QQQ	ETF	144.65	144.65	144.65	144.65	200.0
2017-09-29 07:00:00	QQQ	ETF	144.66	144.69	144.63	144.65	136696.0
2017-09-29 08:00:00	QQQ	ETF	144.69	144.69	144.59	144.6	101432.0
2017-09-29 09:00:00	QQQ	ETF	144.61	144.91	144.39	144.3907	3427049.0
2017-09-29 10:00:00	QQQ	ETF	144.4	144.98	144.32	144.875	4111415.0
2017-09-29 11:00:00	QQQ	ETF	144.87	145.32	144.82	145.29	4266740.0
2017-09-29 12:00:00	QQQ	ETF	145.29	145.55	145.21	145.5234	3931234.0
2017-09-29 13:00:00	QQQ	ETF	145.525	145.555	145.35	145.4242	2557445.0
2017-09-29 14:00:00	QQQ	ETF	145.43	145.45	145.26	145.35	2583645.0
2017-09-29 15:00:00	QQQ	ETF	145.35	145.55	145.27	145.45	6754378.0
2017-09-29 16:00:00	QQQ	ETF	145.46	145.56	145.38	145.41	2011982.0
2017-09-29 17:00:00	QQQ	ETF	145.45	145.45	145.41	145.44	882048.0
2017-09-29 18:00:00	QQQ	ETF	145.42	145.42	145.42	145.42	200.0
2017-09-29 19:00:00	QQQ	ETF	145.54	145.55	145.54	145.55	1000.0
2017-09-29 04:00:00	IWM	ETF	147.93	147.93	147.91	147.91	793.0
2017-09-29 06:00:00	IWM	ETF	147.93	147.93	147.93	147.93	5000.0
2017-09-29 07:00:00	IWM	ETF	147.93	147.93	147.83	147.91	27299.0
2017-09-29 08:00:00	IWM	ETF	147.83	147.92	147.77	147.82	103542.0
2017-09-29 09:00:00	IWM	ETF	147.84	148.21	147.74	148.045	2856929.0
2017-09-29 10:00:00	IWM	ETF	148.05	148.24	147.8875	148.14	2634102.0
2017-09-29 11:00:00	IWM	ETF	148.13	148.32	148.09	148.28	1569410.0
2017-09-29 12:00:00	IWM	ETF	148.275	148.43	148.18	148.235	1255550.0
2017-09-29 13:00:00	IWM	ETF	148.24	148.25	148.05	148.14	1286337.0
2017-09-29 14:00:00	IWM	ETF	148.14	148.27	148.04	148.19	2162593.0
2017-09-29 15:00:00	IWM	ETF	148.1966	148.27	147.94	148.15	4787187.0
2017-09-29 16:00:00	IWM	ETF	148.15	148.25	148.078	148.21	2257350.0
2017-09-29 17:00:00	IWM	ETF	148.18	148.18	148.18	148.18	462000.0
2017-09-29 18:00:00	IWM	ETF	148.18	148.18	148.18	148.18	850.0
2017-09-29 19:00:00	IWM	ETF	148.2	148.29	148.2	148.29	1300.0
2017-09-29 07:00:00	DIA	ETF	223.4	223.4	223.39	223.39	3000.0
2017-09-29 08:00:00	DIA	ETF	223.45	223.45	223.26	223.26	700.0
2017-09-29 09:00:00	DIA	ETF	223.28	223.4	223.13	223.31	301526.0

> showing 50 of 9,145 rows — these rows as CSV

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