PREVIEW / etf_1hour / 2020-09-02

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-09-02.parquet
  size:    386 KB
  rows:    13,080

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
2020-09-02 04:00:00	SPY	ETF	354.51	355.26	354.44	355.1	33268.0
2020-09-02 05:00:00	SPY	ETF	355.23	355.53	355.03	355.5	25289.0
2020-09-02 06:00:00	SPY	ETF	355.47	355.62	355.01	355.1	114033.0
2020-09-02 07:00:00	SPY	ETF	355.0	355.12	354.69	354.69	167700.0
2020-09-02 08:00:00	SPY	ETF	354.68	355.4104	353.6	354.71	230827.0
2020-09-02 09:00:00	SPY	ETF	354.68	354.92	353.53	353.75	7877776.0
2020-09-02 10:00:00	SPY	ETF	353.76	355.29	353.43	354.89	8989743.0
2020-09-02 11:00:00	SPY	ETF	354.88	355.08	353.66	354.785	7700908.0
2020-09-02 12:00:00	SPY	ETF	354.785	355.78	354.54	355.575	5074925.0
2020-09-02 13:00:00	SPY	ETF	355.58	356.739	355.4	356.43	4605893.0
2020-09-02 14:00:00	SPY	ETF	356.44	356.93	355.81	356.75	5674460.0
2020-09-02 15:00:00	SPY	ETF	356.75	358.75	356.67	357.68	22597797.0
2020-09-02 16:00:00	SPY	ETF	357.67	358.1528	357.62	357.76	3622772.0
2020-09-02 17:00:00	SPY	ETF	357.86	357.9	357.7	357.87	300456.0
2020-09-02 18:00:00	SPY	ETF	357.82	358.12	357.5	358.11	114245.0
2020-09-02 19:00:00	SPY	ETF	358.13	358.63	358.06	358.43	135327.0
2020-09-02 04:00:00	QQQ	ETF	303.0	303.55	302.95	303.51	66863.0
2020-09-02 05:00:00	QQQ	ETF	303.52	304.02	303.26	303.99	33434.0
2020-09-02 06:00:00	QQQ	ETF	303.78	303.86	303.0	303.29	196460.0
2020-09-02 07:00:00	QQQ	ETF	303.19	303.47	303.0	303.02	197617.0
2020-09-02 08:00:00	QQQ	ETF	303.21	303.7804	299.92	303.36	321833.0
2020-09-02 09:00:00	QQQ	ETF	303.31	303.54	298.61	298.78	8294292.0
2020-09-02 10:00:00	QQQ	ETF	298.82	301.34	298.76	300.53	8056075.0
2020-09-02 11:00:00	QQQ	ETF	300.55	300.68	296.89	299.105	7310811.0
2020-09-02 12:00:00	QQQ	ETF	299.1	301.05	298.78	300.73	4274175.0
2020-09-02 13:00:00	QQQ	ETF	300.72	302.4	300.44	301.82	3773209.0
2020-09-02 14:00:00	QQQ	ETF	301.82	302.5	301.11	301.92	2826916.0
2020-09-02 15:00:00	QQQ	ETF	301.93	303.5	301.83	302.73	7191165.0
2020-09-02 16:00:00	QQQ	ETF	302.72	303.2	302.42	302.68	1099789.0
2020-09-02 17:00:00	QQQ	ETF	302.66	302.76	302.52	302.6	152274.0
2020-09-02 18:00:00	QQQ	ETF	302.62	303.01	302.47	302.95	52179.0
2020-09-02 19:00:00	QQQ	ETF	302.95	303.36	302.89	302.98	158511.0
2020-09-02 04:00:00	IWM	ETF	157.8	158.47	157.8	158.37	15024.0
2020-09-02 05:00:00	IWM	ETF	158.43	158.49	158.2	158.37	8128.0
2020-09-02 06:00:00	IWM	ETF	158.43	158.48	158.12	158.3	4264.0
2020-09-02 07:00:00	IWM	ETF	158.23	158.28	158.0	158.0	9032.0
2020-09-02 08:00:00	IWM	ETF	158.24	158.24	157.72	157.83	189401.0
2020-09-02 09:00:00	IWM	ETF	157.82	157.97	156.175	156.51	2020748.0
2020-09-02 10:00:00	IWM	ETF	156.51	157.66	156.38	157.33	2238711.0
2020-09-02 11:00:00	IWM	ETF	157.34	157.67	156.9	157.54	1749153.0
2020-09-02 12:00:00	IWM	ETF	157.53	157.89	157.34	157.6501	991457.0
2020-09-02 13:00:00	IWM	ETF	157.65	157.87	157.35	157.56	845827.0
2020-09-02 14:00:00	IWM	ETF	157.56	158.17	157.28	158.1	1405222.0
2020-09-02 15:00:00	IWM	ETF	158.11	158.98	157.99	158.45	3116855.0
2020-09-02 16:00:00	IWM	ETF	158.46	158.71	158.42	158.59	575670.0
2020-09-02 17:00:00	IWM	ETF	158.75	158.75	158.4	158.5	28733.0
2020-09-02 18:00:00	IWM	ETF	158.58	158.69	158.36	158.69	18880.0
2020-09-02 19:00:00	IWM	ETF	158.71	158.9	158.71	158.8	11891.0
2020-09-02 04:00:00	DIA	ETF	288.22	288.81	288.17	288.57	8747.0
2020-09-02 05:00:00	DIA	ETF	288.89	288.9	288.89	288.9	200.0

> showing 50 of 13,080 rows — these rows as CSV

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