PREVIEW / etf_1hour / 2019-01-17

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-01-17.parquet
  size:    323 KB
  rows:    10,606

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
2019-01-17 04:00:00	SPY	ETF	259.76	259.91	259.31	259.49	37414.0
2019-01-17 05:00:00	SPY	ETF	259.6	260.02	259.6	260.02	66191.0
2019-01-17 06:00:00	SPY	ETF	260.07	260.18	259.79	259.93	66255.0
2019-01-17 07:00:00	SPY	ETF	260.0	260.0	259.5	259.72	203287.0
2019-01-17 08:00:00	SPY	ETF	259.82	260.32	259.1	260.06	603635.0
2019-01-17 09:00:00	SPY	ETF	260.04	261.2	259.9	261.04	9449011.0
2019-01-17 10:00:00	SPY	ETF	261.03	261.27	260.54	261.11	8176775.0
2019-01-17 11:00:00	SPY	ETF	261.11	261.7	261.1	261.505	7021777.0
2019-01-17 12:00:00	SPY	ETF	261.51	261.7	261.17	261.28	5090734.0
2019-01-17 13:00:00	SPY	ETF	261.28	261.96	261.26	261.86	5401753.0
2019-01-17 14:00:00	SPY	ETF	261.86	263.92	261.51	262.61	23516649.0
2019-01-17 15:00:00	SPY	ETF	262.62	263.06	261.94	262.98	21612259.0
2019-01-17 16:00:00	SPY	ETF	262.97	263.3	262.62	263.15	12347906.0
2019-01-17 17:00:00	SPY	ETF	263.13	263.2	263.02	263.09	122722.0
2019-01-17 18:00:00	SPY	ETF	263.02	263.07	262.72	262.81	1028097.0
2019-01-17 19:00:00	SPY	ETF	262.78	263.74	262.71	263.3	153674.0
2019-01-17 04:00:00	QQQ	ETF	161.59	161.59	161.11	161.19	26278.0
2019-01-17 05:00:00	QQQ	ETF	161.35	161.48	161.26	161.46	23405.0
2019-01-17 06:00:00	QQQ	ETF	161.5	161.61	161.42	161.45	10791.0
2019-01-17 07:00:00	QQQ	ETF	161.51	161.59	161.27	161.53	95272.0
2019-01-17 08:00:00	QQQ	ETF	161.54	162.4	160.87	161.8701	383940.0
2019-01-17 09:00:00	QQQ	ETF	161.87	162.7797	161.57	162.65	3616251.0
2019-01-17 10:00:00	QQQ	ETF	162.6566	162.83	162.24	162.57	3385578.0
2019-01-17 11:00:00	QQQ	ETF	162.56	162.86	162.52	162.65	2359114.0
2019-01-17 12:00:00	QQQ	ETF	162.66	162.82	162.45	162.5	1668999.0
2019-01-17 13:00:00	QQQ	ETF	162.5	162.9	162.5	162.719	1960344.0
2019-01-17 14:00:00	QQQ	ETF	162.71	164.36	162.52	163.31	8953541.0
2019-01-17 15:00:00	QQQ	ETF	163.32	163.68	162.91	163.63	7818333.0
2019-01-17 16:00:00	QQQ	ETF	163.63	164.01	163.14	163.63	2264920.0
2019-01-17 17:00:00	QQQ	ETF	163.6	163.6	163.48	163.5	36252.0
2019-01-17 18:00:00	QQQ	ETF	163.51	163.51	163.24	163.31	180648.0
2019-01-17 19:00:00	QQQ	ETF	163.29	163.92	163.29	163.71	67680.0
2019-01-17 04:00:00	IWM	ETF	143.9	143.9	143.76	143.79	1400.0
2019-01-17 05:00:00	IWM	ETF	143.81	143.9	143.81	143.9	1730.0
2019-01-17 06:00:00	IWM	ETF	143.9	143.9	143.89	143.89	900.0
2019-01-17 07:00:00	IWM	ETF	143.72	143.77	143.61	143.76	24200.0
2019-01-17 08:00:00	IWM	ETF	143.7401	144.05	143.7401	143.92	115092.0
2019-01-17 09:00:00	IWM	ETF	143.92	144.98	143.88	144.94	1632544.0
2019-01-17 10:00:00	IWM	ETF	144.94	145.13	144.54	144.83	2391846.0
2019-01-17 11:00:00	IWM	ETF	144.83	145.3	144.74	145.1	1408360.0
2019-01-17 12:00:00	IWM	ETF	145.11	145.36	144.98	145.055	996319.0
2019-01-17 13:00:00	IWM	ETF	145.04	145.43	145.03	145.4	1041115.0
2019-01-17 14:00:00	IWM	ETF	145.4	146.33	144.99	145.54	3893831.0
2019-01-17 15:00:00	IWM	ETF	145.5585	146.09	145.27	145.86	4375903.0
2019-01-17 16:00:00	IWM	ETF	145.83	145.99	145.6	145.99	1033936.0
2019-01-17 17:00:00	IWM	ETF	145.85	145.97	145.85	145.97	4900.0
2019-01-17 18:00:00	IWM	ETF	145.85	145.87	145.66	145.68	29339.0
2019-01-17 19:00:00	IWM	ETF	145.83	146.2	145.83	146.03	8980.0
2019-01-17 04:00:00	DIA	ETF	241.02	241.02	240.8	240.8	563.0
2019-01-17 05:00:00	DIA	ETF	241.04	241.1	241.04	241.1	300.0

> showing 50 of 10,606 rows — these rows as CSV

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