PREVIEW / etf_1hour / 2017-03-20

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-03-20.parquet
  size:    268 KB
  rows:    8,622

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-03-20 04:00:00	SPY	ETF	237.06	237.07	236.88	236.88	2270.0
2017-03-20 05:00:00	SPY	ETF	236.91	236.92	236.78	236.78	10799.0
2017-03-20 06:00:00	SPY	ETF	236.87	236.97	236.82	236.97	124608.0
2017-03-20 07:00:00	SPY	ETF	236.95	237.1	236.94	237.04	158009.0
2017-03-20 08:00:00	SPY	ETF	237.03	237.1	236.79	236.83	561043.0
2017-03-20 09:00:00	SPY	ETF	236.84	237.06	236.7	236.88	5491897.0
2017-03-20 10:00:00	SPY	ETF	236.87	237.36	236.84	237.26	9468810.0
2017-03-20 11:00:00	SPY	ETF	237.26	237.32	236.98	237.1666	4382892.0
2017-03-20 12:00:00	SPY	ETF	237.17	237.19	236.92	237.1	3819045.0
2017-03-20 13:00:00	SPY	ETF	237.0938	237.1	236.5	236.67	4859522.0
2017-03-20 14:00:00	SPY	ETF	236.6773	236.815	236.32	236.52	5946719.0
2017-03-20 15:00:00	SPY	ETF	236.525	237.015	236.48	236.74	12431358.0
2017-03-20 16:00:00	SPY	ETF	236.74	236.83	236.43	236.71	4459935.0
2017-03-20 17:00:00	SPY	ETF	236.71	236.77	236.65	236.67	53591.0
2017-03-20 18:00:00	SPY	ETF	236.67	237.23	236.67	236.72	54535.0
2017-03-20 19:00:00	SPY	ETF	236.71	236.75	236.6	236.75	1041389.0
2017-03-20 04:00:00	QQQ	ETF	131.59	131.59	131.59	131.59	500.0
2017-03-20 05:00:00	QQQ	ETF	131.56	131.56	131.53	131.53	1000.0
2017-03-20 06:00:00	QQQ	ETF	131.51	131.58	131.51	131.58	20398.0
2017-03-20 07:00:00	QQQ	ETF	131.58	131.64	131.58	131.63	59432.0
2017-03-20 08:00:00	QQQ	ETF	131.63	131.63	131.56	131.6	44164.0
2017-03-20 09:00:00	QQQ	ETF	131.6	131.8	131.56	131.739	1451675.0
2017-03-20 10:00:00	QQQ	ETF	131.73	132.11	131.73	132.01	1755188.0
2017-03-20 11:00:00	QQQ	ETF	132.005	132.0524	131.85	131.92	872392.0
2017-03-20 12:00:00	QQQ	ETF	131.9256	131.949	131.78	131.91	887235.0
2017-03-20 13:00:00	QQQ	ETF	131.905	131.91	131.53	131.64	1066820.0
2017-03-20 14:00:00	QQQ	ETF	131.6467	131.71	131.4601	131.58	1310213.0
2017-03-20 15:00:00	QQQ	ETF	131.58	131.85	131.56	131.8	1912264.0
2017-03-20 16:00:00	QQQ	ETF	131.81	131.88	131.77	131.85	173523.0
2017-03-20 17:00:00	QQQ	ETF	131.88	131.88	131.82	131.84	2760.0
2017-03-20 18:00:00	QQQ	ETF	131.82	131.82	131.82	131.82	200.0
2017-03-20 19:00:00	QQQ	ETF	131.81	131.85	131.77	131.77	6400.0
2017-03-20 04:00:00	IWM	ETF	138.36	138.36	138.19	138.19	1300.0
2017-03-20 05:00:00	IWM	ETF	138.15	138.15	138.06	138.06	2350.0
2017-03-20 06:00:00	IWM	ETF	138.08	138.1	138.08	138.1	21000.0
2017-03-20 07:00:00	IWM	ETF	138.2	138.29	138.2	138.29	50721.0
2017-03-20 08:00:00	IWM	ETF	138.23	138.29	138.02	138.09	120101.0
2017-03-20 09:00:00	IWM	ETF	138.13	138.52	137.63	137.83	2860558.0
2017-03-20 10:00:00	IWM	ETF	137.82	138.3	137.78	138.06	2559488.0
2017-03-20 11:00:00	IWM	ETF	138.05	138.11	137.75	137.99	1528814.0
2017-03-20 12:00:00	IWM	ETF	138.01	138.13	137.805	138.07	1470703.0
2017-03-20 13:00:00	IWM	ETF	138.07	138.09	137.49	137.74	1738746.0
2017-03-20 14:00:00	IWM	ETF	137.735	137.81	137.37	137.6	1740243.0
2017-03-20 15:00:00	IWM	ETF	137.59	137.98	137.51	137.83	3037904.0
2017-03-20 16:00:00	IWM	ETF	137.84	137.92	137.71	137.81	814928.0
2017-03-20 17:00:00	IWM	ETF	137.83	137.9	137.69	137.7	179929.0
2017-03-20 19:00:00	IWM	ETF	137.75	137.75	137.75	137.75	1000.0
2017-03-20 08:00:00	DIA	ETF	208.85	208.85	208.8	208.85	3073.0
2017-03-20 09:00:00	DIA	ETF	208.85	208.94	208.62	208.89	286438.0
2017-03-20 10:00:00	DIA	ETF	208.87	209.27	208.87	209.21	301818.0

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

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