PREVIEW / etf_1hour / 2017-01-27

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-01-27.parquet
  size:    267 KB
  rows:    8,608

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-01-27 04:00:00	SPY	ETF	229.55	229.55	229.28	229.28	5615.0
2017-01-27 05:00:00	SPY	ETF	229.27	229.38	229.18	229.34	7062.0
2017-01-27 06:00:00	SPY	ETF	229.38	229.46	229.32	229.36	5215.0
2017-01-27 07:00:00	SPY	ETF	229.34	229.55	229.27	229.52	94746.0
2017-01-27 08:00:00	SPY	ETF	229.52	229.58	229.31	229.48	180625.0
2017-01-27 09:00:00	SPY	ETF	229.45	229.59	228.9	229.0347	5522062.0
2017-01-27 10:00:00	SPY	ETF	229.03	229.13	228.79	228.84	6477017.0
2017-01-27 11:00:00	SPY	ETF	228.849	229.1	228.835	229.07	7419703.0
2017-01-27 12:00:00	SPY	ETF	229.07	229.17	228.89	229.0	4403408.0
2017-01-27 13:00:00	SPY	ETF	229.0098	229.04	228.89	228.91	4521380.0
2017-01-27 14:00:00	SPY	ETF	228.91	229.02	228.87	228.96	4787359.0
2017-01-27 15:00:00	SPY	ETF	228.96	229.06	228.76	228.99	11552098.0
2017-01-27 16:00:00	SPY	ETF	229.0	229.0807	228.94	229.01	13275138.0
2017-01-27 17:00:00	SPY	ETF	229.01	229.02	228.92	228.97	130234.0
2017-01-27 18:00:00	SPY	ETF	228.97	228.97	228.93	228.95	31666.0
2017-01-27 19:00:00	SPY	ETF	228.97	229.0	228.95	229.0	14436.0
2017-01-27 05:00:00	QQQ	ETF	125.45	125.45	125.45	125.45	100.0
2017-01-27 06:00:00	QQQ	ETF	125.49	125.52	125.47	125.51	5600.0
2017-01-27 07:00:00	QQQ	ETF	125.54	125.64	125.54	125.64	4715.0
2017-01-27 08:00:00	QQQ	ETF	125.62	125.7	125.47	125.7	105031.0
2017-01-27 09:00:00	QQQ	ETF	125.68	125.9211	125.4507	125.55	3610446.0
2017-01-27 10:00:00	QQQ	ETF	125.55	125.731	125.39	125.66	2220601.0
2017-01-27 11:00:00	QQQ	ETF	125.66	125.78	125.58	125.7	1115419.0
2017-01-27 12:00:00	QQQ	ETF	125.7	125.805	125.69	125.77	921314.0
2017-01-27 13:00:00	QQQ	ETF	125.78	125.79	125.674	125.68	840965.0
2017-01-27 14:00:00	QQQ	ETF	125.69	125.7663	125.65	125.7499	992874.0
2017-01-27 15:00:00	QQQ	ETF	125.7479	125.82	125.58	125.8	2387772.0
2017-01-27 16:00:00	QQQ	ETF	125.8	125.87	125.6311	125.87	874525.0
2017-01-27 17:00:00	QQQ	ETF	125.85	125.85	125.79	125.8	31742.0
2017-01-27 18:00:00	QQQ	ETF	125.8	125.8	125.79	125.8	4501.0
2017-01-27 19:00:00	QQQ	ETF	125.79	125.81	125.77	125.81	10442.0
2017-01-27 06:00:00	IWM	ETF	136.79	136.8	136.79	136.8	5000.0
2017-01-27 07:00:00	IWM	ETF	136.83	136.85	136.82	136.85	1309.0
2017-01-27 08:00:00	IWM	ETF	136.88	136.98	136.74	136.85	62087.0
2017-01-27 09:00:00	IWM	ETF	136.86	137.04	136.01	136.07	2377066.0
2017-01-27 10:00:00	IWM	ETF	136.06	136.39	135.69	135.75	3098870.0
2017-01-27 11:00:00	IWM	ETF	135.745	135.96	135.67	135.92	2644866.0
2017-01-27 12:00:00	IWM	ETF	135.9275	135.99	135.65	135.8	1342971.0
2017-01-27 13:00:00	IWM	ETF	135.81	136.29	135.77	136.12	1813342.0
2017-01-27 14:00:00	IWM	ETF	136.12	136.34	136.07	136.21	1261086.0
2017-01-27 15:00:00	IWM	ETF	136.205	136.23	136.03	136.21	3009312.0
2017-01-27 16:00:00	IWM	ETF	136.19	136.19	135.94	136.02	1467252.0
2017-01-27 17:00:00	IWM	ETF	136.07	136.11	136.0	136.02	4255.0
2017-01-27 18:00:00	IWM	ETF	136.01	136.08	136.01	136.08	700.0
2017-01-27 19:00:00	IWM	ETF	136.05	136.05	135.99	136.01	1008.0
2017-01-27 08:00:00	DIA	ETF	201.0	201.01	200.75	200.75	2400.0
2017-01-27 09:00:00	DIA	ETF	200.77	200.87	200.54	200.65	973041.0
2017-01-27 10:00:00	DIA	ETF	200.648	200.77	200.45	200.5	362692.0
2017-01-27 11:00:00	DIA	ETF	200.49	200.705	200.4811	200.7	234665.0
2017-01-27 12:00:00	DIA	ETF	200.7	200.78	200.48	200.59	200898.0

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

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