PREVIEW / etf_1hour / 2018-05-21

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-05-21.parquet
  size:    299 KB
  rows:    9,862

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-05-21 04:00:00	SPY	ETF	272.83	272.95	272.67	272.94	37577.0
2018-05-21 05:00:00	SPY	ETF	272.98	273.05	272.92	272.94	11807.0
2018-05-21 06:00:00	SPY	ETF	273.01	273.11	272.9	273.0	57690.0
2018-05-21 07:00:00	SPY	ETF	272.98	273.0	272.89	272.92	166886.0
2018-05-21 08:00:00	SPY	ETF	272.92	273.06	271.33	272.97	701348.0
2018-05-21 09:00:00	SPY	ETF	272.95	273.78	272.85	273.275	8279688.0
2018-05-21 10:00:00	SPY	ETF	273.275	273.98	273.19	273.78	6318711.0
2018-05-21 11:00:00	SPY	ETF	273.7892	273.87	272.6	273.12	6896513.0
2018-05-21 12:00:00	SPY	ETF	273.13	273.61	273.02	273.36	7005787.0
2018-05-21 13:00:00	SPY	ETF	273.36	273.69	273.35	273.59	3025076.0
2018-05-21 14:00:00	SPY	ETF	273.6	273.62	272.8608	273.28	6091026.0
2018-05-21 15:00:00	SPY	ETF	273.27	273.42	272.9	273.36	9669440.0
2018-05-21 16:00:00	SPY	ETF	273.36	273.41	273.2	273.32	7844991.0
2018-05-21 17:00:00	SPY	ETF	273.33	273.37	273.23	273.24	91861.0
2018-05-21 18:00:00	SPY	ETF	273.27	273.32	273.0507	273.3	228804.0
2018-05-21 19:00:00	SPY	ETF	273.3	273.32	273.19	273.25	11690.0
2018-05-21 04:00:00	QQQ	ETF	168.41	168.59	168.4	168.59	6900.0
2018-05-21 05:00:00	QQQ	ETF	168.64	168.76	168.57	168.59	7090.0
2018-05-21 06:00:00	QQQ	ETF	168.59	168.71	168.51	168.62	4738.0
2018-05-21 07:00:00	QQQ	ETF	168.58	168.69	168.54	168.61	194016.0
2018-05-21 08:00:00	QQQ	ETF	168.6	168.88	168.51	168.79	343987.0
2018-05-21 09:00:00	QQQ	ETF	168.8	169.5	168.67	169.2595	3502505.0
2018-05-21 10:00:00	QQQ	ETF	169.26	169.37	168.91	169.0853	2233763.0
2018-05-21 11:00:00	QQQ	ETF	169.1	169.18	167.68	168.26	3407039.0
2018-05-21 12:00:00	QQQ	ETF	168.26	168.61	168.14	168.4658	1758643.0
2018-05-21 13:00:00	QQQ	ETF	168.47	168.78	168.4	168.52	975999.0
2018-05-21 14:00:00	QQQ	ETF	168.52	168.53	167.71	168.11	3309211.0
2018-05-21 15:00:00	QQQ	ETF	168.11	168.53	167.95	168.42	4587707.0
2018-05-21 16:00:00	QQQ	ETF	168.42	168.53	168.36	168.47	1010258.0
2018-05-21 17:00:00	QQQ	ETF	168.44	168.45	168.42	168.43	1841.0
2018-05-21 18:00:00	QQQ	ETF	168.43	168.44	168.34	168.44	12537.0
2018-05-21 19:00:00	QQQ	ETF	168.43	168.43	168.34	168.36	3900.0
2018-05-21 04:00:00	IWM	ETF	162.29	162.42	162.22	162.35	8100.0
2018-05-21 05:00:00	IWM	ETF	162.42	162.42	162.41	162.42	2300.0
2018-05-21 06:00:00	IWM	ETF	162.45	162.45	162.41	162.41	4900.0
2018-05-21 07:00:00	IWM	ETF	162.37	162.4	162.35	162.4	89121.0
2018-05-21 08:00:00	IWM	ETF	162.38	162.47	162.36	162.36	89667.0
2018-05-21 09:00:00	IWM	ETF	162.35	163.09	162.2	162.52	2004352.0
2018-05-21 10:00:00	IWM	ETF	162.53	163.17	162.43	163.16	1469449.0
2018-05-21 11:00:00	IWM	ETF	163.15	163.2054	162.47	163.02	1902734.0
2018-05-21 12:00:00	IWM	ETF	163.03	163.24	162.78	162.83	1229672.0
2018-05-21 13:00:00	IWM	ETF	162.84	163.0	162.74	162.9	665109.0
2018-05-21 14:00:00	IWM	ETF	162.9	162.97	162.59	162.825	1173789.0
2018-05-21 15:00:00	IWM	ETF	162.82	163.04	162.68	162.95	3500149.0
2018-05-21 16:00:00	IWM	ETF	162.96	163.18	162.9074	163.12	1028610.0
2018-05-21 17:00:00	IWM	ETF	163.03	163.12	162.96	163.08	34583.0
2018-05-21 18:00:00	IWM	ETF	163.06	163.1	163.01	163.1	6699.0
2018-05-21 19:00:00	IWM	ETF	163.1	163.1	163.03	163.03	3796.0
2018-05-21 04:00:00	DIA	ETF	249.33	249.33	249.11	249.11	3618.0
2018-05-21 05:00:00	DIA	ETF	249.26	249.4	249.26	249.4	320.0

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

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