PREVIEW / etf_1hour / 2018-02-27

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-02-27.parquet
  size:    310 KB
  rows:    10,114

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-27 04:00:00	SPY	ETF	277.8	277.8	277.52	277.74	9487.0
2018-02-27 05:00:00	SPY	ETF	277.83	278.13	277.71	277.93	21408.0
2018-02-27 06:00:00	SPY	ETF	277.87	278.0	277.42	277.64	65321.0
2018-02-27 07:00:00	SPY	ETF	277.56	278.22	277.53	278.08	497115.0
2018-02-27 08:00:00	SPY	ETF	277.99	278.35	277.55	278.03	1216553.0
2018-02-27 09:00:00	SPY	ETF	278.04	278.44	277.61	277.73	8516177.0
2018-02-27 10:00:00	SPY	ETF	277.73	278.92	276.62	277.0	15522894.0
2018-02-27 11:00:00	SPY	ETF	276.99	277.68	276.29	276.32	11045972.0
2018-02-27 12:00:00	SPY	ETF	276.305	277.18	275.66	277.13	10602227.0
2018-02-27 13:00:00	SPY	ETF	277.14	277.26	276.17	276.35	6551366.0
2018-02-27 14:00:00	SPY	ETF	276.36	276.59	275.58	276.03	8152380.0
2018-02-27 15:00:00	SPY	ETF	276.025	276.18	274.36	274.38	20796392.0
2018-02-27 16:00:00	SPY	ETF	274.38	274.92	274.1632	274.69	11681162.0
2018-02-27 17:00:00	SPY	ETF	274.65	277.1402	274.57	274.6	118611.0
2018-02-27 18:00:00	SPY	ETF	274.61	275.3	274.43	275.27	655058.0
2018-02-27 19:00:00	SPY	ETF	275.27	275.4	275.22	275.3	97258.0
2018-02-27 04:00:00	QQQ	ETF	170.2	170.24	169.96	170.11	79501.0
2018-02-27 05:00:00	QQQ	ETF	170.18	170.41	170.18	170.34	8590.0
2018-02-27 06:00:00	QQQ	ETF	170.24	170.24	169.96	170.1	53449.0
2018-02-27 07:00:00	QQQ	ETF	170.04	170.33	170.01	170.26	28299.0
2018-02-27 08:00:00	QQQ	ETF	170.07	170.51	170.06	170.4	253477.0
2018-02-27 09:00:00	QQQ	ETF	170.43	170.52	169.71	169.82	3558555.0
2018-02-27 10:00:00	QQQ	ETF	169.82	170.73	169.27	169.45	6263058.0
2018-02-27 11:00:00	QQQ	ETF	169.45	169.855	168.94	168.96	6145996.0
2018-02-27 12:00:00	QQQ	ETF	168.97	169.52	168.4	169.5	4657862.0
2018-02-27 13:00:00	QQQ	ETF	169.5	169.63	169.0598	169.16	3645593.0
2018-02-27 14:00:00	QQQ	ETF	169.18	169.43	168.82	169.0876	4362518.0
2018-02-27 15:00:00	QQQ	ETF	169.07	169.22	168.21	168.22	7249629.0
2018-02-27 16:00:00	QQQ	ETF	168.22	170.17	168.2	168.42	1766264.0
2018-02-27 17:00:00	QQQ	ETF	168.42	168.47	168.32	168.41	5939.0
2018-02-27 18:00:00	QQQ	ETF	168.41	168.76	168.41	168.7	41819.0
2018-02-27 19:00:00	QQQ	ETF	168.75	168.87	168.73	168.8	18370.0
2018-02-27 04:00:00	IWM	ETF	154.75	154.75	154.75	154.75	2500.0
2018-02-27 05:00:00	IWM	ETF	154.96	154.96	154.91	154.91	837.0
2018-02-27 06:00:00	IWM	ETF	154.86	154.86	154.5	154.63	5520.0
2018-02-27 07:00:00	IWM	ETF	154.67	155.11	154.67	155.06	14130.0
2018-02-27 08:00:00	IWM	ETF	154.8	155.24	154.79	155.18	81499.0
2018-02-27 09:00:00	IWM	ETF	155.17	155.88	155.07	155.22	2126452.0
2018-02-27 10:00:00	IWM	ETF	155.23	155.74	154.18	154.48	2760342.0
2018-02-27 11:00:00	IWM	ETF	154.48	154.75	153.57	153.69	3092341.0
2018-02-27 12:00:00	IWM	ETF	153.68	154.34	153.46	154.31	1480398.0
2018-02-27 13:00:00	IWM	ETF	154.3	154.35	153.78	153.86	1449181.0
2018-02-27 14:00:00	IWM	ETF	153.89	153.98	153.37	153.63	1437225.0
2018-02-27 15:00:00	IWM	ETF	153.62	153.73	152.75	152.75	3738637.0
2018-02-27 16:00:00	IWM	ETF	152.76	153.01	152.66	152.88	905459.0
2018-02-27 17:00:00	IWM	ETF	152.95	152.98	152.76	152.91	45463.0
2018-02-27 18:00:00	IWM	ETF	152.91	153.17	152.91	153.17	2748.0
2018-02-27 19:00:00	IWM	ETF	153.2	153.23	153.11	153.23	3900.0
2018-02-27 05:00:00	DIA	ETF	257.18	257.18	257.15	257.15	800.0
2018-02-27 06:00:00	DIA	ETF	256.81	256.81	256.65	256.65	2468.0

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

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