PREVIEW / etf_1hour / 2018-04-23

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-04-23.parquet
  size:    295 KB
  rows:    9,705

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
2018-04-23 04:00:00	SPY	ETF	266.82	266.82	266.28	266.44	21680.0
2018-04-23 05:00:00	SPY	ETF	266.48	266.48	266.29	266.42	15621.0
2018-04-23 06:00:00	SPY	ETF	266.38	266.82	266.3	266.74	84865.0
2018-04-23 07:00:00	SPY	ETF	266.78	267.04	266.66	266.99	176338.0
2018-04-23 08:00:00	SPY	ETF	266.78	267.56	266.6	267.38	540998.0
2018-04-23 09:00:00	SPY	ETF	267.37	267.37	266.39	267.03	5654912.0
2018-04-23 10:00:00	SPY	ETF	267.04	267.23	266.37	267.02	8127732.0
2018-04-23 11:00:00	SPY	ETF	267.02	267.89	266.905	267.42	7461724.0
2018-04-23 12:00:00	SPY	ETF	267.42	267.55	266.56	266.79	5134749.0
2018-04-23 13:00:00	SPY	ETF	266.79	267.08	266.52	266.92	5225729.0
2018-04-23 14:00:00	SPY	ETF	266.91	267.0	265.35	265.62	9418523.0
2018-04-23 15:00:00	SPY	ETF	265.62	266.62	265.53	266.58	13498923.0
2018-04-23 16:00:00	SPY	ETF	266.59	266.95	266.1416	266.77	9207247.0
2018-04-23 17:00:00	SPY	ETF	266.78	266.83	266.71	266.72	39134.0
2018-04-23 18:00:00	SPY	ETF	266.74	266.95	266.74	266.86	38119.0
2018-04-23 19:00:00	SPY	ETF	266.86	267.22	266.83	267.12	43059.0
2018-04-23 04:00:00	QQQ	ETF	162.37	162.42	162.1	162.2	12608.0
2018-04-23 05:00:00	QQQ	ETF	162.24	162.35	162.14	162.29	29770.0
2018-04-23 06:00:00	QQQ	ETF	162.29	162.65	162.23	162.54	25035.0
2018-04-23 07:00:00	QQQ	ETF	162.55	162.9	162.53	162.83	111518.0
2018-04-23 08:00:00	QQQ	ETF	162.6699	163.18	162.17	163.08	217174.0
2018-04-23 09:00:00	QQQ	ETF	163.12	163.17	162.03	162.57	3957048.0
2018-04-23 10:00:00	QQQ	ETF	162.57	163.32	162.27	163.19	3529717.0
2018-04-23 11:00:00	QQQ	ETF	163.19	163.73	163.07	163.29	3310733.0
2018-04-23 12:00:00	QQQ	ETF	163.31	163.37	162.217	162.37	2509195.0
2018-04-23 13:00:00	QQQ	ETF	162.36	162.54	162.12	162.34	2381270.0
2018-04-23 14:00:00	QQQ	ETF	162.34	162.36	161.02	161.24	5411228.0
2018-04-23 15:00:00	QQQ	ETF	161.24	162.0	161.13	161.9	5437048.0
2018-04-23 16:00:00	QQQ	ETF	161.9	162.85	161.71	162.07	2614397.0
2018-04-23 17:00:00	QQQ	ETF	162.13	162.13	161.97	162.03	11835.0
2018-04-23 18:00:00	QQQ	ETF	162.03	162.2	162.03	162.14	33159.0
2018-04-23 19:00:00	QQQ	ETF	162.17	162.34	162.14	162.32	36200.0
2018-04-23 04:00:00	IWM	ETF	155.5	155.5	155.15	155.25	1514.0
2018-04-23 05:00:00	IWM	ETF	155.3	155.3	155.3	155.3	500.0
2018-04-23 06:00:00	IWM	ETF	155.28	155.51	155.28	155.51	3650.0
2018-04-23 07:00:00	IWM	ETF	155.45	155.63	155.45	155.63	17593.0
2018-04-23 08:00:00	IWM	ETF	155.455	155.85	155.455	155.8	24338.0
2018-04-23 09:00:00	IWM	ETF	155.78	155.96	155.05	155.71	1540138.0
2018-04-23 10:00:00	IWM	ETF	155.72	155.9	155.29	155.8	1827262.0
2018-04-23 11:00:00	IWM	ETF	155.8	156.29	155.7	155.8368	1525458.0
2018-04-23 12:00:00	IWM	ETF	155.84	155.86	155.0	155.19	1246488.0
2018-04-23 13:00:00	IWM	ETF	155.18	155.46	155.07	155.37	1022104.0
2018-04-23 14:00:00	IWM	ETF	155.37	155.4	154.57	154.74	1979735.0
2018-04-23 15:00:00	IWM	ETF	154.73	155.37	154.67	155.31	2352610.0
2018-04-23 16:00:00	IWM	ETF	155.32	155.53	155.17	155.37	514027.0
2018-04-23 17:00:00	IWM	ETF	155.32	155.32	155.32	155.32	492.0
2018-04-23 18:00:00	IWM	ETF	155.32	155.48	155.32	155.48	4498.0
2018-04-23 19:00:00	IWM	ETF	155.47	155.59	155.47	155.59	1800.0
2018-04-23 05:00:00	DIA	ETF	244.12	244.12	244.1	244.1	3000.0
2018-04-23 06:00:00	DIA	ETF	244.33	244.58	244.33	244.58	200.0

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

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