PREVIEW / etf_1hour / 2019-02-22

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-02-22.parquet
  size:    321 KB
  rows:    10,621

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-22 04:00:00	SPY	ETF	278.02	278.35	278.02	278.2	18070.0
2019-02-22 05:00:00	SPY	ETF	278.13	278.52	278.13	278.41	17858.0
2019-02-22 06:00:00	SPY	ETF	278.49	278.64	278.38	278.5	27946.0
2019-02-22 07:00:00	SPY	ETF	278.57	278.65	278.4	278.45	103389.0
2019-02-22 08:00:00	SPY	ETF	278.46	278.61	277.39	278.07	417640.0
2019-02-22 09:00:00	SPY	ETF	278.07	278.47	277.82	278.47	6411257.0
2019-02-22 10:00:00	SPY	ETF	278.46	278.84	278.25	278.7367	8728538.0
2019-02-22 11:00:00	SPY	ETF	278.74	279.27	278.6	279.1	7670472.0
2019-02-22 12:00:00	SPY	ETF	279.1	279.36	278.85	278.9717	6733571.0
2019-02-22 13:00:00	SPY	ETF	278.98	279.0	278.62	278.8917	6390442.0
2019-02-22 14:00:00	SPY	ETF	278.9	279.14	278.04	278.22	13302957.0
2019-02-22 15:00:00	SPY	ETF	278.21	279.22	278.12	279.15	17662688.0
2019-02-22 16:00:00	SPY	ETF	279.15	279.41	278.87	279.41	6928626.0
2019-02-22 17:00:00	SPY	ETF	279.39	279.41	279.04	279.34	1415382.0
2019-02-22 18:00:00	SPY	ETF	279.34	279.35	279.29	279.35	17477.0
2019-02-22 19:00:00	SPY	ETF	279.32	279.4	279.32	279.37	25603.0
2019-02-22 04:00:00	QQQ	ETF	171.93	172.13	171.93	172.04	14870.0
2019-02-22 05:00:00	QQQ	ETF	172.01	172.36	172.01	172.3	22501.0
2019-02-22 06:00:00	QQQ	ETF	172.29	172.42	172.23	172.41	33550.0
2019-02-22 07:00:00	QQQ	ETF	172.4	172.49	172.26	172.28	104788.0
2019-02-22 08:00:00	QQQ	ETF	172.34	172.44	171.62	171.95	443613.0
2019-02-22 09:00:00	QQQ	ETF	171.94	172.4499	171.9	172.445	3007717.0
2019-02-22 10:00:00	QQQ	ETF	172.43	172.73	172.11	172.64	4748426.0
2019-02-22 11:00:00	QQQ	ETF	172.65	173.01	172.53	172.86	2963390.0
2019-02-22 12:00:00	QQQ	ETF	172.85	173.0	172.63	172.715	2567091.0
2019-02-22 13:00:00	QQQ	ETF	172.72	172.75	172.5	172.69	1620153.0
2019-02-22 14:00:00	QQQ	ETF	172.69	172.85	171.98	172.16	2998454.0
2019-02-22 15:00:00	QQQ	ETF	172.15	172.9	172.06	172.89	4817801.0
2019-02-22 16:00:00	QQQ	ETF	172.88	172.98	172.6	172.98	1061305.0
2019-02-22 17:00:00	QQQ	ETF	172.92	172.98	172.89	172.98	38260.0
2019-02-22 18:00:00	QQQ	ETF	172.98	172.98	172.92	172.97	3292.0
2019-02-22 19:00:00	QQQ	ETF	172.97	172.99	172.92	172.97	10278.0
2019-02-22 04:00:00	IWM	ETF	157.26	157.36	157.26	157.3	2300.0
2019-02-22 05:00:00	IWM	ETF	157.32	157.51	157.32	157.45	20000.0
2019-02-22 06:00:00	IWM	ETF	157.48	157.52	157.41	157.41	5049.0
2019-02-22 07:00:00	IWM	ETF	157.45	157.47	157.38	157.38	29847.0
2019-02-22 08:00:00	IWM	ETF	157.44	157.44	157.22	157.27	61748.0
2019-02-22 09:00:00	IWM	ETF	157.28	157.68	157.1	157.58	1787030.0
2019-02-22 10:00:00	IWM	ETF	157.59	157.87	157.49	157.84	1871960.0
2019-02-22 11:00:00	IWM	ETF	157.84	158.17	157.74	158.13	2258046.0
2019-02-22 12:00:00	IWM	ETF	158.12	158.27	157.85	157.93	1098172.0
2019-02-22 13:00:00	IWM	ETF	157.9329	158.01	157.76	157.94	1051570.0
2019-02-22 14:00:00	IWM	ETF	157.94	158.07	157.53	157.69	1657559.0
2019-02-22 15:00:00	IWM	ETF	157.68	158.24	157.6517	158.16	3010300.0
2019-02-22 16:00:00	IWM	ETF	158.15	158.35	158.02	158.35	1228819.0
2019-02-22 17:00:00	IWM	ETF	158.3	158.3	158.26	158.28	11101.0
2019-02-22 18:00:00	IWM	ETF	158.15	158.27	158.15	158.23	800.0
2019-02-22 19:00:00	IWM	ETF	158.29	158.35	158.29	158.35	2714.0
2019-02-22 04:00:00	DIA	ETF	258.84	259.17	258.84	259.16	400.0
2019-02-22 05:00:00	DIA	ETF	259.2	259.36	259.2	259.36	1900.0

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

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