PREVIEW / etf_1hour / 2017-05-30

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-05-30.parquet
  size:    268 KB
  rows:    8,844

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-05-30 04:00:00	SPY	ETF	241.53	241.66	241.5	241.66	2920.0
2017-05-30 05:00:00	SPY	ETF	241.6	241.66	241.45	241.45	6060.0
2017-05-30 06:00:00	SPY	ETF	241.51	241.51	241.39	241.39	111807.0
2017-05-30 07:00:00	SPY	ETF	241.4	241.4	241.18	241.18	90793.0
2017-05-30 08:00:00	SPY	ETF	241.17	241.47	241.17	241.44	295652.0
2017-05-30 09:00:00	SPY	ETF	241.41	241.7	241.23	241.495	5313596.0
2017-05-30 10:00:00	SPY	ETF	241.495	241.62	241.16	241.51	7201486.0
2017-05-30 11:00:00	SPY	ETF	241.5	241.64	241.46	241.52	3337800.0
2017-05-30 12:00:00	SPY	ETF	241.52	241.79	241.52	241.71	2583758.0
2017-05-30 13:00:00	SPY	ETF	241.71	241.77	241.59	241.64	2445947.0
2017-05-30 14:00:00	SPY	ETF	241.63	241.7	241.53	241.645	2614830.0
2017-05-30 15:00:00	SPY	ETF	241.65	241.78	241.52	241.52	6948079.0
2017-05-30 16:00:00	SPY	ETF	241.53	241.57	241.4	241.5	3703952.0
2017-05-30 17:00:00	SPY	ETF	241.47	241.47	241.44	241.45	17181.0
2017-05-30 18:00:00	SPY	ETF	241.44	241.53	241.43	241.5	32847.0
2017-05-30 19:00:00	SPY	ETF	241.51	241.51	241.45	241.5	18967.0
2017-05-30 04:00:00	QQQ	ETF	141.15	141.29	141.15	141.29	7200.0
2017-05-30 05:00:00	QQQ	ETF	141.26	141.26	141.21	141.21	767.0
2017-05-30 06:00:00	QQQ	ETF	141.23	141.24	141.19	141.19	7300.0
2017-05-30 07:00:00	QQQ	ETF	141.15	141.15	140.94	140.94	30596.0
2017-05-30 08:00:00	QQQ	ETF	140.94	141.19	140.92	141.19	25220.0
2017-05-30 09:00:00	QQQ	ETF	141.17	141.5	141.06	141.41	1801692.0
2017-05-30 10:00:00	QQQ	ETF	141.42	141.48	141.23	141.37	4034405.0
2017-05-30 11:00:00	QQQ	ETF	141.36	141.45	141.31	141.3552	1319306.0
2017-05-30 12:00:00	QQQ	ETF	141.36	141.505	141.33	141.45	1839787.0
2017-05-30 13:00:00	QQQ	ETF	141.45	141.49	141.335	141.34	1444406.0
2017-05-30 14:00:00	QQQ	ETF	141.34	141.3811	141.27	141.33	1307761.0
2017-05-30 15:00:00	QQQ	ETF	141.33	141.46	141.32	141.33	5618495.0
2017-05-30 16:00:00	QQQ	ETF	141.33	141.35	141.19	141.29	494940.0
2017-05-30 17:00:00	QQQ	ETF	141.31	141.31	141.25	141.29	1723.0
2017-05-30 18:00:00	QQQ	ETF	141.25	141.34	141.24	141.34	15947.0
2017-05-30 19:00:00	QQQ	ETF	141.35	141.35	141.33	141.34	880.0
2017-05-30 04:00:00	IWM	ETF	137.34	137.34	137.34	137.34	100.0
2017-05-30 05:00:00	IWM	ETF	137.24	137.24	137.11	137.11	4524.0
2017-05-30 06:00:00	IWM	ETF	137.11	137.11	136.99	137.01	2602.0
2017-05-30 07:00:00	IWM	ETF	136.98	136.99	136.81	136.81	44258.0
2017-05-30 08:00:00	IWM	ETF	136.77	137.1	136.67	137.09	59813.0
2017-05-30 09:00:00	IWM	ETF	137.17	137.44	136.84	136.86	2347142.0
2017-05-30 10:00:00	IWM	ETF	136.86	137.0	136.22	136.68	5831862.0
2017-05-30 11:00:00	IWM	ETF	136.68	136.92	136.37	136.5147	2718450.0
2017-05-30 12:00:00	IWM	ETF	136.52	136.81	136.39	136.48	1396067.0
2017-05-30 13:00:00	IWM	ETF	136.48	136.74	136.43	136.63	1131435.0
2017-05-30 14:00:00	IWM	ETF	136.63	136.72	136.46	136.71	1343211.0
2017-05-30 15:00:00	IWM	ETF	136.71	136.87	136.45	136.46	3679657.0
2017-05-30 16:00:00	IWM	ETF	136.46	136.53	136.3	136.52	3548445.0
2017-05-30 17:00:00	IWM	ETF	136.52	136.52	136.49	136.49	5766.0
2017-05-30 18:00:00	IWM	ETF	136.43	136.43	136.41	136.43	643.0
2017-05-30 19:00:00	IWM	ETF	136.47	136.58	136.47	136.58	4252.0
2017-05-30 07:00:00	DIA	ETF	210.35	210.35	210.25	210.25	200.0
2017-05-30 08:00:00	DIA	ETF	210.31	210.31	210.25	210.25	575.0

> showing 50 of 8,844 rows — these rows as CSV

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