PREVIEW / etf_1hour / 2017-12-18

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-12-18.parquet
  size:    298 KB
  rows:    9,925

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
2017-12-18 04:00:00	SPY	ETF	267.54	267.95	267.5	267.9	13016.0
2017-12-18 05:00:00	SPY	ETF	267.91	267.95	267.84	267.9	9190.0
2017-12-18 06:00:00	SPY	ETF	267.9	267.99	267.89	267.89	17255.0
2017-12-18 07:00:00	SPY	ETF	267.81	268.02	267.81	267.94	193541.0
2017-12-18 08:00:00	SPY	ETF	267.95	268.17	267.8	268.01	402549.0
2017-12-18 09:00:00	SPY	ETF	268.0	268.6	267.94	268.44	9020471.0
2017-12-18 10:00:00	SPY	ETF	268.445	268.52	268.15	268.26	7637495.0
2017-12-18 11:00:00	SPY	ETF	268.26	268.52	268.1025	268.47	7944741.0
2017-12-18 12:00:00	SPY	ETF	268.47	268.56	268.34	268.41	6747222.0
2017-12-18 13:00:00	SPY	ETF	268.4	268.5137	268.18	268.23	7510396.0
2017-12-18 14:00:00	SPY	ETF	268.22	268.4	268.14	268.39	5473720.0
2017-12-18 15:00:00	SPY	ETF	268.39	268.459	268.0	268.18	17747123.0
2017-12-18 16:00:00	SPY	ETF	268.19	268.3622	268.05	268.28	18998976.0
2017-12-18 17:00:00	SPY	ETF	268.24	268.33	268.1545	268.3	119767.0
2017-12-18 18:00:00	SPY	ETF	268.27	268.34	268.21	268.26	251241.0
2017-12-18 19:00:00	SPY	ETF	268.27	268.28	268.2	268.23	27370.0
2017-12-18 04:00:00	QQQ	ETF	158.35	158.6	158.35	158.59	36950.0
2017-12-18 05:00:00	QQQ	ETF	158.59	158.59	158.49	158.57	19455.0
2017-12-18 06:00:00	QQQ	ETF	158.58	158.69	158.58	158.59	31813.0
2017-12-18 07:00:00	QQQ	ETF	158.55	158.59	158.47	158.48	56919.0
2017-12-18 08:00:00	QQQ	ETF	158.53	158.53	158.25	158.34	180451.0
2017-12-18 09:00:00	QQQ	ETF	158.34	158.49	158.07	158.39	3494008.0
2017-12-18 10:00:00	QQQ	ETF	158.39	158.59	158.335	158.38	3061074.0
2017-12-18 11:00:00	QQQ	ETF	158.37	158.64	158.22	158.55	1491815.0
2017-12-18 12:00:00	QQQ	ETF	158.55	158.77	158.54	158.72	1904824.0
2017-12-18 13:00:00	QQQ	ETF	158.7128	158.74	158.58	158.675	1493717.0
2017-12-18 14:00:00	QQQ	ETF	158.68	158.72	158.58	158.7	2234900.0
2017-12-18 15:00:00	QQQ	ETF	158.7	158.72	158.42	158.58	5397979.0
2017-12-18 16:00:00	QQQ	ETF	158.585	158.64	158.5158	158.6	1857739.0
2017-12-18 17:00:00	QQQ	ETF	158.63	158.66	158.63	158.63	1081667.0
2017-12-18 18:00:00	QQQ	ETF	158.61	158.65	158.57	158.62	8821.0
2017-12-18 19:00:00	QQQ	ETF	158.64	158.65	158.57	158.57	9399.0
2017-12-18 04:00:00	IWM	ETF	153.3	153.68	153.27	153.68	16473.0
2017-12-18 05:00:00	IWM	ETF	153.55	153.61	153.53	153.53	7000.0
2017-12-18 06:00:00	IWM	ETF	153.61	153.71	153.61	153.61	3737.0
2017-12-18 07:00:00	IWM	ETF	153.67	153.75	153.61	153.61	16275.0
2017-12-18 08:00:00	IWM	ETF	153.62	153.68	153.55	153.67	64553.0
2017-12-18 09:00:00	IWM	ETF	153.59	154.72	153.46	154.72	3351789.0
2017-12-18 10:00:00	IWM	ETF	154.72	154.72	154.17	154.42	2336461.0
2017-12-18 11:00:00	IWM	ETF	154.42	154.54	154.21	154.43	2181735.0
2017-12-18 12:00:00	IWM	ETF	154.43	154.55	153.91	153.99	1818805.0
2017-12-18 13:00:00	IWM	ETF	153.99	154.119	153.85	153.88	1315090.0
2017-12-18 14:00:00	IWM	ETF	153.89	154.13	153.83	154.08	1669727.0
2017-12-18 15:00:00	IWM	ETF	154.08	154.32	153.87	154.29	3896642.0
2017-12-18 16:00:00	IWM	ETF	154.3	154.4	154.09	154.24	2593605.0
2017-12-18 17:00:00	IWM	ETF	154.31	154.31	154.3	154.3	628656.0
2017-12-18 18:00:00	IWM	ETF	154.3	154.3	154.2	154.3	5470.0
2017-12-18 19:00:00	IWM	ETF	154.26	154.26	154.19	154.21	6030.0
2017-12-18 05:00:00	DIA	ETF	247.05	247.05	247.05	247.05	100.0
2017-12-18 06:00:00	DIA	ETF	247.43	247.5	247.43	247.5	1432.0

> showing 50 of 9,925 rows — these rows as CSV

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