PREVIEW / etf_1hour / 2020-07-02

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-07-02.parquet
  size:    367 KB
  rows:    12,694

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-07-02 04:00:00	SPY	ETF	312.0	313.13	312.0	312.53	51911.0
2020-07-02 05:00:00	SPY	ETF	312.51	312.68	312.02	312.31	25439.0
2020-07-02 06:00:00	SPY	ETF	312.3	312.63	311.96	312.6	120896.0
2020-07-02 07:00:00	SPY	ETF	312.55	312.95	312.5	312.85	147595.0
2020-07-02 08:00:00	SPY	ETF	312.6001	314.74	309.7733	314.7	2280450.0
2020-07-02 09:00:00	SPY	ETF	314.67	315.4767	314.14	315.37	8281505.0
2020-07-02 10:00:00	SPY	ETF	315.385	315.7	312.78	312.91	11105353.0
2020-07-02 11:00:00	SPY	ETF	312.91	313.85	312.04	313.61	6877078.0
2020-07-02 12:00:00	SPY	ETF	313.61	313.8	312.86	313.7075	4770210.0
2020-07-02 13:00:00	SPY	ETF	313.7	314.2	313.38	313.76	4852843.0
2020-07-02 14:00:00	SPY	ETF	313.76	314.4	313.51	314.09	5860292.0
2020-07-02 15:00:00	SPY	ETF	314.09	314.21	311.51	312.18	17635083.0
2020-07-02 16:00:00	SPY	ETF	312.18	313.02	311.8239	312.58	5686086.0
2020-07-02 17:00:00	SPY	ETF	312.52	312.69	312.38	312.45	568977.0
2020-07-02 18:00:00	SPY	ETF	312.5	313.18	312.43	312.98	119831.0
2020-07-02 19:00:00	SPY	ETF	313.03	313.15	312.7	312.8	56908.0
2020-07-02 04:00:00	QQQ	ETF	250.59	252.03	250.32	251.88	24773.0
2020-07-02 05:00:00	QQQ	ETF	251.74	251.87	251.45	251.52	7943.0
2020-07-02 06:00:00	QQQ	ETF	251.65	251.65	251.37	251.62	14055.0
2020-07-02 07:00:00	QQQ	ETF	251.61	252.24	251.58	252.22	92626.0
2020-07-02 08:00:00	QQQ	ETF	251.5204	253.25	250.92	253.1	688667.0
2020-07-02 09:00:00	QQQ	ETF	253.1	254.22	252.91	254.08	3961499.0
2020-07-02 10:00:00	QQQ	ETF	254.075	254.27	252.705	253.04	5265974.0
2020-07-02 11:00:00	QQQ	ETF	253.03	253.41	251.99	253.3	3731740.0
2020-07-02 12:00:00	QQQ	ETF	253.3	253.55	252.74	253.43	2316782.0
2020-07-02 13:00:00	QQQ	ETF	253.42	253.77	253.1501	253.27	1849184.0
2020-07-02 14:00:00	QQQ	ETF	253.28	253.8	253.0501	253.715	1929504.0
2020-07-02 15:00:00	QQQ	ETF	253.73	253.84	251.71	252.11	5774344.0
2020-07-02 16:00:00	QQQ	ETF	252.15	252.67	252.0294	252.49	1196798.0
2020-07-02 17:00:00	QQQ	ETF	252.54	252.54	252.31	252.44	8928.0
2020-07-02 18:00:00	QQQ	ETF	252.5	252.8	252.5	252.6	26277.0
2020-07-02 19:00:00	QQQ	ETF	252.66	252.72	252.42	252.5	33515.0
2020-07-02 04:00:00	IWM	ETF	143.0	143.75	142.61	143.5	22944.0
2020-07-02 05:00:00	IWM	ETF	143.4	143.45	142.9	142.92	7383.0
2020-07-02 06:00:00	IWM	ETF	143.15	143.4	142.9	143.4	30025.0
2020-07-02 07:00:00	IWM	ETF	143.32	143.73	143.25	143.32	39860.0
2020-07-02 08:00:00	IWM	ETF	143.3999	144.98	143.0	144.86	508326.0
2020-07-02 09:00:00	IWM	ETF	144.84	145.27	144.14	145.13	3522382.0
2020-07-02 10:00:00	IWM	ETF	145.135	145.28	142.79	142.965	5065820.0
2020-07-02 11:00:00	IWM	ETF	142.965	143.755	141.8909	143.48	3817309.0
2020-07-02 12:00:00	IWM	ETF	143.5	143.53	142.77	142.97	1526575.0
2020-07-02 13:00:00	IWM	ETF	142.96	143.38	142.805	142.97	1383113.0
2020-07-02 14:00:00	IWM	ETF	142.97	143.445	142.8	143.06	1230005.0
2020-07-02 15:00:00	IWM	ETF	143.06	143.135	141.91	142.39	3226678.0
2020-07-02 16:00:00	IWM	ETF	142.4	142.82	141.8909	142.66	967952.0
2020-07-02 17:00:00	IWM	ETF	142.83	142.83	142.6	142.6	1305.0
2020-07-02 18:00:00	IWM	ETF	142.68	142.85	142.66	142.79	21620.0
2020-07-02 19:00:00	IWM	ETF	142.76	142.88	142.6	142.65	8300.0
2020-07-02 04:00:00	DIA	ETF	259.2	260.1	259.2	259.7	4904.0
2020-07-02 05:00:00	DIA	ETF	259.51	259.65	259.2	259.36	2015.0

> showing 50 of 12,694 rows — these rows as CSV

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