PREVIEW / etf_1hour / 2019-02-01

all etf 1-hour files

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

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-01 04:00:00	SPY	ETF	270.07	270.24	270.0	270.07	17581.0
2019-02-01 05:00:00	SPY	ETF	270.07	270.2	269.9	269.98	16846.0
2019-02-01 06:00:00	SPY	ETF	270.01	270.14	269.82	269.89	43298.0
2019-02-01 07:00:00	SPY	ETF	269.92	269.94	269.5	269.51	187234.0
2019-02-01 08:00:00	SPY	ETF	269.5	270.55	269.3	270.39	1753909.0
2019-02-01 09:00:00	SPY	ETF	270.39	270.49	269.53	269.55	9872803.0
2019-02-01 10:00:00	SPY	ETF	269.56	271.2	269.555	270.14	14568449.0
2019-02-01 11:00:00	SPY	ETF	270.14	271.02	269.8	270.98	8154088.0
2019-02-01 12:00:00	SPY	ETF	270.99	271.01	270.0	270.305	6000551.0
2019-02-01 13:00:00	SPY	ETF	270.3	270.47	269.8	270.1399	5583141.0
2019-02-01 14:00:00	SPY	ETF	270.135	270.15	269.29	269.461	11187678.0
2019-02-01 15:00:00	SPY	ETF	269.45	270.24	269.18	270.09	16333947.0
2019-02-01 16:00:00	SPY	ETF	270.08	270.22	270.01	270.15	10638784.0
2019-02-01 17:00:00	SPY	ETF	270.15	270.15	270.06	270.12	25455.0
2019-02-01 18:00:00	SPY	ETF	270.1	270.18	270.01	270.18	17096.0
2019-02-01 19:00:00	SPY	ETF	270.12	270.14	270.04	270.07	22583.0
2019-02-01 04:00:00	QQQ	ETF	167.89	167.89	167.49	167.6	34895.0
2019-02-01 05:00:00	QQQ	ETF	167.58	167.72	167.46	167.54	27446.0
2019-02-01 06:00:00	QQQ	ETF	167.52	167.63	167.35	167.42	42939.0
2019-02-01 07:00:00	QQQ	ETF	167.42	167.56	167.22	167.23	156349.0
2019-02-01 08:00:00	QQQ	ETF	167.24	167.89	167.0	167.65	464670.0
2019-02-01 09:00:00	QQQ	ETF	167.66	168.25	167.24	167.38	4614227.0
2019-02-01 10:00:00	QQQ	ETF	167.375	168.6	167.375	167.8	5172916.0
2019-02-01 11:00:00	QQQ	ETF	167.8	168.46	167.605	168.3797	2359808.0
2019-02-01 12:00:00	QQQ	ETF	168.39	168.39	167.62	167.78	2518111.0
2019-02-01 13:00:00	QQQ	ETF	167.77	167.9023	167.24	167.5733	2061171.0
2019-02-01 14:00:00	QQQ	ETF	167.58	167.5899	167.02	167.11	2703441.0
2019-02-01 15:00:00	QQQ	ETF	167.1	167.48	166.99	167.43	4787882.0
2019-02-01 16:00:00	QQQ	ETF	167.43	167.51	167.27	167.47	1178535.0
2019-02-01 17:00:00	QQQ	ETF	167.49	167.49	167.28	167.32	3516.0
2019-02-01 18:00:00	QQQ	ETF	167.35	167.38	167.31	167.35	7499.0
2019-02-01 19:00:00	QQQ	ETF	167.35	167.35	167.25	167.35	13918.0
2019-02-01 04:00:00	IWM	ETF	149.28	149.28	149.28	149.28	165.0
2019-02-01 05:00:00	IWM	ETF	149.15	149.15	149.15	149.15	100.0
2019-02-01 06:00:00	IWM	ETF	149.19	149.19	149.19	149.19	1000.0
2019-02-01 07:00:00	IWM	ETF	149.07	149.07	149.02	149.02	8240.0
2019-02-01 08:00:00	IWM	ETF	149.06	149.47	148.79	149.44	56820.0
2019-02-01 09:00:00	IWM	ETF	149.45	149.5	148.64	148.64	1725817.0
2019-02-01 10:00:00	IWM	ETF	148.72	149.62	148.65	148.82	3426700.0
2019-02-01 11:00:00	IWM	ETF	148.78	149.68	148.6726	149.65	1257692.0
2019-02-01 12:00:00	IWM	ETF	149.66	149.68	148.96	149.24	1398295.0
2019-02-01 13:00:00	IWM	ETF	149.24	149.48	149.19	149.3375	985216.0
2019-02-01 14:00:00	IWM	ETF	149.33	149.34	148.7	148.8	1537723.0
2019-02-01 15:00:00	IWM	ETF	148.8015	149.42	148.58	149.24	3201684.0
2019-02-01 16:00:00	IWM	ETF	149.22	149.47	149.16	149.36	1469784.0
2019-02-01 17:00:00	IWM	ETF	149.39	149.39	149.3	149.3	4901.0
2019-02-01 18:00:00	IWM	ETF	149.3	149.3	149.26	149.26	660.0
2019-02-01 19:00:00	IWM	ETF	149.26	149.39	149.22	149.39	16300.0
2019-02-01 05:00:00	DIA	ETF	250.47	250.47	250.47	250.47	200.0
2019-02-01 06:00:00	DIA	ETF	250.4	250.4	250.4	250.4	400.0

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

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