PREVIEW / etf_1hour / 2019-05-02

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-05-02.parquet
  size:    326 KB
  rows:    10,672

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-05-02 04:00:00	SPY	ETF	292.11	292.43	292.04	292.4	35014.0
2019-05-02 05:00:00	SPY	ETF	292.34	292.6	292.34	292.6	35404.0
2019-05-02 06:00:00	SPY	ETF	292.51	292.56	292.23	292.3	93507.0
2019-05-02 07:00:00	SPY	ETF	292.3	292.33	291.92	292.07	176367.0
2019-05-02 08:00:00	SPY	ETF	292.08	292.4	291.52	291.71	418449.0
2019-05-02 09:00:00	SPY	ETF	291.7	292.3	291.3399	292.1669	6172749.0
2019-05-02 10:00:00	SPY	ETF	292.165	292.7	291.6	291.61	7772146.0
2019-05-02 11:00:00	SPY	ETF	291.62	291.95	289.52	290.01	15114947.0
2019-05-02 12:00:00	SPY	ETF	290.0	290.79	289.72	290.52	8755348.0
2019-05-02 13:00:00	SPY	ETF	290.52	291.37	290.0999	290.985	6785488.0
2019-05-02 14:00:00	SPY	ETF	290.98	291.48	290.4	290.76	5256794.0
2019-05-02 15:00:00	SPY	ETF	290.75	291.3277	290.66	291.27	9554030.0
2019-05-02 16:00:00	SPY	ETF	291.26	291.37	290.93	291.31	2952843.0
2019-05-02 17:00:00	SPY	ETF	291.3	291.35	291.24	291.27	146836.0
2019-05-02 18:00:00	SPY	ETF	291.29	291.51	291.23	291.32	36484.0
2019-05-02 19:00:00	SPY	ETF	291.41	291.47	291.35	291.37	19843.0
2019-05-02 04:00:00	QQQ	ETF	189.05	189.24	188.93	189.24	51362.0
2019-05-02 05:00:00	QQQ	ETF	189.21	189.45	189.18	189.45	63923.0
2019-05-02 06:00:00	QQQ	ETF	189.44	189.44	189.21	189.26	25423.0
2019-05-02 07:00:00	QQQ	ETF	189.27	189.3	189.01	189.2	93279.0
2019-05-02 08:00:00	QQQ	ETF	189.2801	189.2801	188.74	188.88	189528.0
2019-05-02 09:00:00	QQQ	ETF	188.86	189.4	188.61	189.222	3622171.0
2019-05-02 10:00:00	QQQ	ETF	189.23	189.85	188.87	188.89	3585672.0
2019-05-02 11:00:00	QQQ	ETF	188.91	189.25	186.87	187.19	8516240.0
2019-05-02 12:00:00	QQQ	ETF	187.19	187.94	187.05	187.49	5765488.0
2019-05-02 13:00:00	QQQ	ETF	187.49	188.31	187.135	187.95	4526071.0
2019-05-02 14:00:00	QQQ	ETF	187.9502	188.41	187.57	187.8509	2864344.0
2019-05-02 15:00:00	QQQ	ETF	187.85	188.28	187.75	188.19	4855980.0
2019-05-02 16:00:00	QQQ	ETF	188.2	188.27	187.89	188.22	957937.0
2019-05-02 17:00:00	QQQ	ETF	188.16	188.22	188.16	188.2	13511.0
2019-05-02 18:00:00	QQQ	ETF	188.16	188.39	188.16	188.3	31107.0
2019-05-02 19:00:00	QQQ	ETF	188.32	188.41	188.3	188.36	56016.0
2019-05-02 04:00:00	IWM	ETF	156.57	157.1	156.57	157.1	2389.0
2019-05-02 05:00:00	IWM	ETF	157.23	157.23	157.23	157.23	2500.0
2019-05-02 06:00:00	IWM	ETF	157.09	157.09	157.09	157.09	500.0
2019-05-02 07:00:00	IWM	ETF	157.08	157.08	156.81	156.87	14800.0
2019-05-02 08:00:00	IWM	ETF	156.89	156.89	156.54	156.64	54507.0
2019-05-02 09:00:00	IWM	ETF	156.58	157.71	156.37	157.67	2540022.0
2019-05-02 10:00:00	IWM	ETF	157.66	158.15	156.97	156.99	3180816.0
2019-05-02 11:00:00	IWM	ETF	157.0	157.17	155.6764	156.11	4096766.0
2019-05-02 12:00:00	IWM	ETF	156.11	156.94	155.83	156.93	2935633.0
2019-05-02 13:00:00	IWM	ETF	156.925	157.46	156.57	156.98	2226201.0
2019-05-02 14:00:00	IWM	ETF	156.9701	157.35	156.8001	157.07	1168328.0
2019-05-02 15:00:00	IWM	ETF	157.07	157.52	156.95	157.51	3032872.0
2019-05-02 16:00:00	IWM	ETF	157.51	157.68	157.22	157.67	465846.0
2019-05-02 17:00:00	IWM	ETF	157.67	157.67	157.56	157.65	3527.0
2019-05-02 18:00:00	IWM	ETF	157.61	157.76	157.59	157.71	12900.0
2019-05-02 19:00:00	IWM	ETF	157.72	157.72	157.64	157.64	7000.0
2019-05-02 06:00:00	DIA	ETF	264.58	264.6	264.32	264.34	5700.0
2019-05-02 07:00:00	DIA	ETF	264.35	264.35	264.19	264.19	1282.0

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

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