PREVIEW / etf_1hour / 2019-01-28

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-01-28.parquet
  size:    324 KB
  rows:    10,762

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-28 04:00:00	SPY	ETF	264.64	264.8	264.41	264.75	23565.0
2019-01-28 05:00:00	SPY	ETF	264.8	264.8	264.52	264.57	24962.0
2019-01-28 06:00:00	SPY	ETF	264.56	264.87	264.56	264.68	37425.0
2019-01-28 07:00:00	SPY	ETF	264.7	264.98	264.41	264.55	204093.0
2019-01-28 08:00:00	SPY	ETF	264.57	265.18	264.17	264.35	300602.0
2019-01-28 09:00:00	SPY	ETF	264.38	264.39	262.33	262.71	11667821.0
2019-01-28 10:00:00	SPY	ETF	262.71	263.49	262.21	262.67	14369794.0
2019-01-28 11:00:00	SPY	ETF	262.68	263.2	261.98	262.0135	13323341.0
2019-01-28 12:00:00	SPY	ETF	262.02	262.87	261.79	262.47	8118847.0
2019-01-28 13:00:00	SPY	ETF	262.44	263.5	262.31	263.26	6847958.0
2019-01-28 14:00:00	SPY	ETF	263.27	263.75	262.81	263.53	7699409.0
2019-01-28 15:00:00	SPY	ETF	263.52	263.83	263.11	263.79	15370105.0
2019-01-28 16:00:00	SPY	ETF	263.78	263.85	263.56	263.65	5770454.0
2019-01-28 17:00:00	SPY	ETF	263.64	263.69	263.53	263.6	78450.0
2019-01-28 18:00:00	SPY	ETF	263.6	263.6	263.12	263.16	130877.0
2019-01-28 19:00:00	SPY	ETF	263.12	263.74	262.54	262.56	434150.0
2019-01-28 04:00:00	QQQ	ETF	164.41	164.48	164.18	164.33	8978.0
2019-01-28 05:00:00	QQQ	ETF	164.39	164.44	164.27	164.27	23688.0
2019-01-28 06:00:00	QQQ	ETF	164.29	164.44	164.26	164.26	12974.0
2019-01-28 07:00:00	QQQ	ETF	164.28	164.56	164.24	164.27	153566.0
2019-01-28 08:00:00	QQQ	ETF	164.26	164.82	164.05	164.29	180662.0
2019-01-28 09:00:00	QQQ	ETF	164.31	164.32	161.86	162.35	6190472.0
2019-01-28 10:00:00	QQQ	ETF	162.34	162.91	161.99	162.38	4392721.0
2019-01-28 11:00:00	QQQ	ETF	162.35	162.79	161.88	161.93	3384363.0
2019-01-28 12:00:00	QQQ	ETF	161.92	162.51	161.75	162.18	2195191.0
2019-01-28 13:00:00	QQQ	ETF	162.18	162.94	162.06	162.72	2196468.0
2019-01-28 14:00:00	QQQ	ETF	162.73	163.1	162.44	162.91	2242538.0
2019-01-28 15:00:00	QQQ	ETF	162.91	163.12	162.66	163.09	4552504.0
2019-01-28 16:00:00	QQQ	ETF	163.09	163.17	162.9	162.96	3485542.0
2019-01-28 17:00:00	QQQ	ETF	162.99	162.99	162.84	162.9	30465.0
2019-01-28 18:00:00	QQQ	ETF	162.87	162.87	162.54	162.55	47519.0
2019-01-28 19:00:00	QQQ	ETF	162.54	162.54	162.16	162.17	105278.0
2019-01-28 04:00:00	IWM	ETF	146.75	146.75	146.58	146.68	1069.0
2019-01-28 05:00:00	IWM	ETF	146.67	146.68	146.63	146.64	12500.0
2019-01-28 06:00:00	IWM	ETF	146.65	146.66	146.57	146.57	4332.0
2019-01-28 07:00:00	IWM	ETF	146.58	146.69	146.49	146.5	22775.0
2019-01-28 08:00:00	IWM	ETF	146.6	147.02	146.33	146.35	29488.0
2019-01-28 09:00:00	IWM	ETF	146.31	146.31	145.65	145.82	3283556.0
2019-01-28 10:00:00	IWM	ETF	145.81	146.87	145.66	146.58	2886550.0
2019-01-28 11:00:00	IWM	ETF	146.57	146.91	145.38	145.38	3582068.0
2019-01-28 12:00:00	IWM	ETF	145.39	146.43	145.37	146.2338	2018464.0
2019-01-28 13:00:00	IWM	ETF	146.24	146.62	146.14	146.52	1854201.0
2019-01-28 14:00:00	IWM	ETF	146.52	146.6	145.98	146.42	2063110.0
2019-01-28 15:00:00	IWM	ETF	146.43	146.66	146.12	146.53	4161293.0
2019-01-28 16:00:00	IWM	ETF	146.54	146.61	146.39	146.55	1484636.0
2019-01-28 17:00:00	IWM	ETF	146.52	146.52	146.52	146.52	765.0
2019-01-28 18:00:00	IWM	ETF	146.36	146.36	146.14	146.14	9093.0
2019-01-28 19:00:00	IWM	ETF	146.15	146.15	145.81	145.81	21941.0
2019-01-28 04:00:00	DIA	ETF	246.1	246.1	246.1	246.1	500.0
2019-01-28 05:00:00	DIA	ETF	246.2	246.2	246.2	246.2	600.0

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

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