PREVIEW / etf_1hour / 2018-02-14

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-02-14.parquet
  size:    312 KB
  rows:    10,213

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
2018-02-14 04:00:00	SPY	ETF	267.3	267.46	267.02	267.02	37358.0
2018-02-14 05:00:00	SPY	ETF	267.02	267.27	266.85	267.07	13541.0
2018-02-14 06:00:00	SPY	ETF	267.05	267.32	267.0	267.19	19844.0
2018-02-14 07:00:00	SPY	ETF	267.17	267.26	266.97	267.0	152845.0
2018-02-14 08:00:00	SPY	ETF	267.17	267.44	262.62	264.1	7593266.0
2018-02-14 09:00:00	SPY	ETF	264.1	266.0763	263.55	265.08	16639298.0
2018-02-14 10:00:00	SPY	ETF	265.09	267.58	264.89	267.0	19246554.0
2018-02-14 11:00:00	SPY	ETF	267.01	267.83	266.5866	266.93	11679101.0
2018-02-14 12:00:00	SPY	ETF	266.96	268.27	266.71	268.12	6817800.0
2018-02-14 13:00:00	SPY	ETF	268.12	269.3	268.05	269.02	11834376.0
2018-02-14 14:00:00	SPY	ETF	269.0189	269.46	268.445	269.22	11079502.0
2018-02-14 15:00:00	SPY	ETF	269.22	270.0	269.22	269.71	26112856.0
2018-02-14 16:00:00	SPY	ETF	269.7	269.75	267.95	269.47	6799899.0
2018-02-14 17:00:00	SPY	ETF	269.48	269.6376	269.0	269.38	326791.0
2018-02-14 18:00:00	SPY	ETF	269.37	269.52	269.29	269.35	129389.0
2018-02-14 19:00:00	SPY	ETF	269.37	269.66	269.24	269.61	95499.0
2018-02-14 20:00:00	SPY	ETF	269.62	269.62	269.62	269.62	1186.0
2018-02-14 04:00:00	QQQ	ETF	160.67	160.77	160.47	160.47	42875.0
2018-02-14 05:00:00	QQQ	ETF	160.56	160.56	160.3	160.47	19392.0
2018-02-14 06:00:00	QQQ	ETF	160.43	160.6	160.43	160.48	36691.0
2018-02-14 07:00:00	QQQ	ETF	160.5	160.7	160.41	160.43	177040.0
2018-02-14 08:00:00	QQQ	ETF	160.43	160.68	155.88	158.65	1842943.0
2018-02-14 09:00:00	QQQ	ETF	158.6	160.15	158.0	159.47	7040966.0
2018-02-14 10:00:00	QQQ	ETF	159.49	161.375	159.3862	160.99	9043104.0
2018-02-14 11:00:00	QQQ	ETF	160.97	161.7	160.77	160.9633	4661024.0
2018-02-14 12:00:00	QQQ	ETF	160.97	161.86	160.68	161.765	4824443.0
2018-02-14 13:00:00	QQQ	ETF	161.77	162.3	161.72	162.11	4777651.0
2018-02-14 14:00:00	QQQ	ETF	162.11	162.48	162.04	162.31	3385680.0
2018-02-14 15:00:00	QQQ	ETF	162.32	162.93	162.32	162.71	8268829.0
2018-02-14 16:00:00	QQQ	ETF	162.71	162.98	159.56	162.69	1814654.0
2018-02-14 17:00:00	QQQ	ETF	162.83	162.83	162.65	162.65	160835.0
2018-02-14 18:00:00	QQQ	ETF	162.67	162.8	162.6	162.66	28336.0
2018-02-14 19:00:00	QQQ	ETF	162.7	162.87	162.57	162.83	15737.0
2018-02-14 04:00:00	IWM	ETF	149.37	149.6	149.05	149.05	11039.0
2018-02-14 05:00:00	IWM	ETF	149.11	149.27	149.01	149.15	6761.0
2018-02-14 06:00:00	IWM	ETF	149.11	149.21	149.11	149.21	650.0
2018-02-14 07:00:00	IWM	ETF	149.11	149.14	148.9	148.91	29791.0
2018-02-14 08:00:00	IWM	ETF	148.92	149.49	146.18	147.63	941880.0
2018-02-14 09:00:00	IWM	ETF	147.6	148.9	147.14	148.55	5621086.0
2018-02-14 10:00:00	IWM	ETF	148.56	150.26	148.23	149.65	5328243.0
2018-02-14 11:00:00	IWM	ETF	149.65	150.18	149.28	150.0	2702353.0
2018-02-14 12:00:00	IWM	ETF	150.01	150.26	149.77	150.03	1865096.0
2018-02-14 13:00:00	IWM	ETF	150.03	150.8899	149.97	150.7515	2843561.0
2018-02-14 14:00:00	IWM	ETF	150.76	151.379	150.76	151.05	2979764.0
2018-02-14 15:00:00	IWM	ETF	151.05	151.52	150.83	151.14	7574328.0
2018-02-14 16:00:00	IWM	ETF	151.13	151.32	149.62	151.21	1419533.0
2018-02-14 17:00:00	IWM	ETF	151.25	151.28	151.01	151.13	89635.0
2018-02-14 18:00:00	IWM	ETF	151.15	151.25	151.13	151.15	9047.0
2018-02-14 19:00:00	IWM	ETF	151.15	151.35	151.1	151.29	7281.0
2018-02-14 05:00:00	DIA	ETF	248.15	248.15	248.15	248.15	250.0

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

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