PREVIEW / etf_1hour / 2018-12-26

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-12-26.parquet
  size:    352 KB
  rows:    11,474

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-12-26 04:00:00	SPY	ETF	234.05	235.1	233.71	234.95	29493.0
2018-12-26 05:00:00	SPY	ETF	234.9	235.2	234.11	234.42	105566.0
2018-12-26 06:00:00	SPY	ETF	234.45	235.05	234.44	234.7	142441.0
2018-12-26 07:00:00	SPY	ETF	234.65	235.95	234.5	235.8	345905.0
2018-12-26 08:00:00	SPY	ETF	234.7	235.87	231.99	235.22	1311615.0
2018-12-26 09:00:00	SPY	ETF	235.15	237.85	234.86	235.59	20707628.0
2018-12-26 10:00:00	SPY	ETF	235.59	235.95	233.76	234.1	27620142.0
2018-12-26 11:00:00	SPY	ETF	234.11	238.38	234.06	238.32	21775760.0
2018-12-26 12:00:00	SPY	ETF	238.32	240.63	238.21	240.3566	25082793.0
2018-12-26 13:00:00	SPY	ETF	240.36	241.305	238.53	241.2721	21051532.0
2018-12-26 14:00:00	SPY	ETF	241.28	241.48	239.84	241.4	21354564.0
2018-12-26 15:00:00	SPY	ETF	241.42	246.0	241.06	245.945	54806459.0
2018-12-26 16:00:00	SPY	ETF	245.97	246.9	244.0844	245.93	18638809.0
2018-12-26 17:00:00	SPY	ETF	245.94	246.24	245.85	246.17	402678.0
2018-12-26 18:00:00	SPY	ETF	246.2	246.26	245.4	245.5	399984.0
2018-12-26 19:00:00	SPY	ETF	245.5	245.68	244.9	245.05	350949.0
2018-12-26 04:00:00	QQQ	ETF	143.3	143.92	142.95	143.88	14147.0
2018-12-26 05:00:00	QQQ	ETF	143.8	143.8	143.36	143.45	60455.0
2018-12-26 06:00:00	QQQ	ETF	143.42	143.83	143.4	143.71	35069.0
2018-12-26 07:00:00	QQQ	ETF	143.66	144.67	143.66	144.67	165909.0
2018-12-26 08:00:00	QQQ	ETF	144.62	144.74	141.99	144.56	280843.0
2018-12-26 09:00:00	QQQ	ETF	144.54	146.95	144.31	145.47	10972338.0
2018-12-26 10:00:00	QQQ	ETF	145.47	145.95	144.09	144.24	11601390.0
2018-12-26 11:00:00	QQQ	ETF	144.28	147.36	144.13	147.33	10495055.0
2018-12-26 12:00:00	QQQ	ETF	147.32	149.16	147.17	148.9391	10651483.0
2018-12-26 13:00:00	QQQ	ETF	148.94	149.58	147.785	149.54	8012610.0
2018-12-26 14:00:00	QQQ	ETF	149.54	149.71	148.58	149.6597	8152245.0
2018-12-26 15:00:00	QQQ	ETF	149.64	152.48	149.34	152.46	21228189.0
2018-12-26 16:00:00	QQQ	ETF	152.46	153.19	152.23	152.45	4100088.0
2018-12-26 17:00:00	QQQ	ETF	152.46	152.6	152.33	152.6	76829.0
2018-12-26 18:00:00	QQQ	ETF	152.6	152.6	152.0	152.07	157012.0
2018-12-26 19:00:00	QQQ	ETF	152.02	152.29	151.69	151.78	133425.0
2018-12-26 04:00:00	IWM	ETF	125.45	125.89	125.45	125.89	274.0
2018-12-26 05:00:00	IWM	ETF	125.81	125.81	125.81	125.81	500.0
2018-12-26 06:00:00	IWM	ETF	125.9	126.0	125.9	126.0	389.0
2018-12-26 07:00:00	IWM	ETF	125.85	126.69	125.85	126.6	54704.0
2018-12-26 08:00:00	IWM	ETF	125.8	126.63	125.8	126.26	71834.0
2018-12-26 09:00:00	IWM	ETF	126.09	127.37	126.03	126.9	3859593.0
2018-12-26 10:00:00	IWM	ETF	126.87	127.05	125.81	126.02	4394901.0
2018-12-26 11:00:00	IWM	ETF	126.04	128.12	125.84	128.11	4869139.0
2018-12-26 12:00:00	IWM	ETF	128.1	129.63	127.8872	129.3	5512004.0
2018-12-26 13:00:00	IWM	ETF	129.31	129.96	128.69	129.9075	4012292.0
2018-12-26 14:00:00	IWM	ETF	129.91	130.3	129.46	130.27	3501416.0
2018-12-26 15:00:00	IWM	ETF	130.26	132.1	130.07	131.93	8976021.0
2018-12-26 16:00:00	IWM	ETF	131.93	132.17	131.79	131.79	1324687.0
2018-12-26 17:00:00	IWM	ETF	131.71	131.93	131.71	131.9	107926.0
2018-12-26 18:00:00	IWM	ETF	131.9	131.98	131.47	131.52	289560.0
2018-12-26 19:00:00	IWM	ETF	131.55	131.57	131.2	131.2	3924.0
2018-12-26 04:00:00	DIA	ETF	217.4	218.59	217.11	218.59	4043.0
2018-12-26 05:00:00	DIA	ETF	217.89	217.89	217.81	217.81	889.0

> showing 50 of 11,474 rows — these rows as CSV

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