PREVIEW / etf_1hour / 2019-02-05

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-02-05.parquet
  size:    324 KB
  rows:    10,656

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-02-05 04:00:00	SPY	ETF	272.0	272.2	272.0	272.09	11123.0
2019-02-05 05:00:00	SPY	ETF	272.05	272.32	272.05	272.19	10955.0
2019-02-05 06:00:00	SPY	ETF	272.26	272.52	272.24	272.34	42628.0
2019-02-05 07:00:00	SPY	ETF	272.32	272.47	272.19	272.35	103002.0
2019-02-05 08:00:00	SPY	ETF	272.32	272.48	271.49	272.39	253221.0
2019-02-05 09:00:00	SPY	ETF	272.38	272.9	272.28	272.81	7886043.0
2019-02-05 10:00:00	SPY	ETF	272.815	273.29	272.5	273.2515	8984108.0
2019-02-05 11:00:00	SPY	ETF	273.26	273.37	272.6	272.9417	6927036.0
2019-02-05 12:00:00	SPY	ETF	272.94	273.02	271.97	272.085	7216574.0
2019-02-05 13:00:00	SPY	ETF	272.0815	272.48	271.88	272.435	5571848.0
2019-02-05 14:00:00	SPY	ETF	272.44	273.11	272.43	273.09	10084829.0
2019-02-05 15:00:00	SPY	ETF	273.08	273.44	272.91	273.19	17464901.0
2019-02-05 16:00:00	SPY	ETF	273.18	273.29	272.72	272.81	12259755.0
2019-02-05 17:00:00	SPY	ETF	272.8	273.1	272.77	272.85	65305.0
2019-02-05 18:00:00	SPY	ETF	272.79	272.92	272.73	272.92	37159.0
2019-02-05 19:00:00	SPY	ETF	272.83	273.0	272.74	272.88	36660.0
2019-02-05 04:00:00	QQQ	ETF	168.99	169.17	168.99	169.1	4867.0
2019-02-05 05:00:00	QQQ	ETF	169.15	169.27	169.14	169.21	7996.0
2019-02-05 06:00:00	QQQ	ETF	169.26	169.39	169.22	169.35	20067.0
2019-02-05 07:00:00	QQQ	ETF	169.29	169.52	169.23	169.43	89087.0
2019-02-05 08:00:00	QQQ	ETF	169.23	169.63	168.82	169.6101	205960.0
2019-02-05 09:00:00	QQQ	ETF	169.63	170.755	169.55	170.53	4288392.0
2019-02-05 10:00:00	QQQ	ETF	170.52	171.09	170.3	171.0	3825560.0
2019-02-05 11:00:00	QQQ	ETF	171.0	171.09	170.46	170.85	2871322.0
2019-02-05 12:00:00	QQQ	ETF	170.845	170.91	169.98	170.08	2492844.0
2019-02-05 13:00:00	QQQ	ETF	170.09	170.5399	169.97	170.52	2216725.0
2019-02-05 14:00:00	QQQ	ETF	170.52	170.9899	170.51	170.9501	2440192.0
2019-02-05 15:00:00	QQQ	ETF	170.96	171.23	170.88	171.03	5459171.0
2019-02-05 16:00:00	QQQ	ETF	171.03	171.0552	170.55	170.72	1075017.0
2019-02-05 17:00:00	QQQ	ETF	170.7	170.85	170.69	170.75	57131.0
2019-02-05 18:00:00	QQQ	ETF	170.75	170.83	170.67	170.81	48551.0
2019-02-05 19:00:00	QQQ	ETF	170.75	170.87	170.71	170.8	23767.0
2019-02-05 04:00:00	IWM	ETF	151.01	151.06	151.01	151.06	4200.0
2019-02-05 05:00:00	IWM	ETF	151.04	151.07	151.04	151.07	1116.0
2019-02-05 06:00:00	IWM	ETF	151.19	151.2	151.09	151.1	22000.0
2019-02-05 07:00:00	IWM	ETF	151.08	151.15	151.04	151.11	1233.0
2019-02-05 08:00:00	IWM	ETF	151.1	151.1	150.99	151.05	11228.0
2019-02-05 09:00:00	IWM	ETF	151.0	151.55	150.99	151.49	1858481.0
2019-02-05 10:00:00	IWM	ETF	151.47	151.6	151.25	151.43	1879475.0
2019-02-05 11:00:00	IWM	ETF	151.43	151.53	150.64	150.75	2381828.0
2019-02-05 12:00:00	IWM	ETF	150.76	150.82	150.24	150.34	2148941.0
2019-02-05 13:00:00	IWM	ETF	150.33	150.9	150.33	150.84	1114667.0
2019-02-05 14:00:00	IWM	ETF	150.85	151.185	150.8236	151.17	1767684.0
2019-02-05 15:00:00	IWM	ETF	151.18	151.4	151.01	151.13	3387709.0
2019-02-05 16:00:00	IWM	ETF	151.12	151.1509	150.576	150.91	1120225.0
2019-02-05 17:00:00	IWM	ETF	150.9	151.02	150.9	150.95	39548.0
2019-02-05 18:00:00	IWM	ETF	150.9	151.0	150.9	150.9	8831.0
2019-02-05 19:00:00	IWM	ETF	150.91	150.96	150.9	150.94	7300.0
2019-02-05 04:00:00	DIA	ETF	252.5	252.89	252.5	252.89	702.0
2019-02-05 06:00:00	DIA	ETF	253.05	253.27	253.05	253.12	510.0

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

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