PREVIEW / etf_1hour / 2020-06-17

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-06-17.parquet
  size:    363 KB
  rows:    12,504

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-06-17 04:00:00	SPY	ETF	314.87	316.0	314.66	315.39	106015.0
2020-06-17 05:00:00	SPY	ETF	315.54	315.54	313.1	313.65	156801.0
2020-06-17 06:00:00	SPY	ETF	313.8	314.96	313.56	314.94	188625.0
2020-06-17 07:00:00	SPY	ETF	314.9	315.29	314.12	314.48	581554.0
2020-06-17 08:00:00	SPY	ETF	314.9	315.28	311.67	314.08	899104.0
2020-06-17 09:00:00	SPY	ETF	314.08	314.44	312.0202	312.6567	7607429.0
2020-06-17 10:00:00	SPY	ETF	312.65	313.46	311.16	312.82	20070203.0
2020-06-17 11:00:00	SPY	ETF	312.81	313.17	311.93	313.1	8242688.0
2020-06-17 12:00:00	SPY	ETF	313.11	313.98	312.46	313.54	5477123.0
2020-06-17 13:00:00	SPY	ETF	313.5484	314.39	313.515	313.68	5813364.0
2020-06-17 14:00:00	SPY	ETF	313.68	314.15	313.02	313.06	6998835.0
2020-06-17 15:00:00	SPY	ETF	313.05	313.055	310.86	311.56	20061224.0
2020-06-17 16:00:00	SPY	ETF	311.56	312.45	311.5	312.0	5545565.0
2020-06-17 17:00:00	SPY	ETF	312.07	312.07	311.55	311.65	249816.0
2020-06-17 18:00:00	SPY	ETF	311.69	312.18	311.21	311.65	344135.0
2020-06-17 19:00:00	SPY	ETF	311.87	312.05	310.41	310.4501	233012.0
2020-06-17 04:00:00	QQQ	ETF	244.6	245.22	244.47	245.11	100835.0
2020-06-17 05:00:00	QQQ	ETF	244.98	245.14	243.76	244.0	37688.0
2020-06-17 06:00:00	QQQ	ETF	244.01	244.84	243.98	244.79	111228.0
2020-06-17 07:00:00	QQQ	ETF	244.79	244.89	244.42	244.68	204148.0
2020-06-17 08:00:00	QQQ	ETF	244.7	245.0	242.79	244.38	259295.0
2020-06-17 09:00:00	QQQ	ETF	244.45	244.79	243.4202	243.8801	3820287.0
2020-06-17 10:00:00	QQQ	ETF	243.88	244.465	242.8004	244.24	5434377.0
2020-06-17 11:00:00	QQQ	ETF	244.22	244.54	243.685	244.44	3979764.0
2020-06-17 12:00:00	QQQ	ETF	244.46	245.125	244.03	245.06	2691391.0
2020-06-17 13:00:00	QQQ	ETF	245.0616	245.5	244.96	244.96	2182226.0
2020-06-17 14:00:00	QQQ	ETF	244.96	245.437	244.581	244.665	2562310.0
2020-06-17 15:00:00	QQQ	ETF	244.64	244.65	242.73	243.56	5555651.0
2020-06-17 16:00:00	QQQ	ETF	243.56	244.11	243.5	243.96	548429.0
2020-06-17 17:00:00	QQQ	ETF	244.0	244.04	243.7	243.75	10514.0
2020-06-17 18:00:00	QQQ	ETF	243.85	244.2	243.48	244.12	72537.0
2020-06-17 19:00:00	QQQ	ETF	244.01	244.17	243.09	243.16	122434.0
2020-06-17 04:00:00	IWM	ETF	145.47	146.4	145.38	146.06	141728.0
2020-06-17 05:00:00	IWM	ETF	146.01	146.18	144.52	144.78	19890.0
2020-06-17 06:00:00	IWM	ETF	144.7	145.74	144.7	145.72	101783.0
2020-06-17 07:00:00	IWM	ETF	145.63	146.09	145.63	145.83	126624.0
2020-06-17 08:00:00	IWM	ETF	145.85	146.1	144.64	144.9201	377445.0
2020-06-17 09:00:00	IWM	ETF	144.99	145.16	142.8875	143.29	3971296.0
2020-06-17 10:00:00	IWM	ETF	143.29	143.79	141.85	142.71	5973318.0
2020-06-17 11:00:00	IWM	ETF	142.7	143.255	141.86	143.22	2415324.0
2020-06-17 12:00:00	IWM	ETF	143.24	143.41	142.63	142.97	1806723.0
2020-06-17 13:00:00	IWM	ETF	142.97	143.54	142.92	143.015	1220327.0
2020-06-17 14:00:00	IWM	ETF	143.02	143.56	142.76	142.8	2034612.0
2020-06-17 15:00:00	IWM	ETF	142.79	142.79	141.32	141.71	8376694.0
2020-06-17 16:00:00	IWM	ETF	141.72	142.09	141.51	142.05	1166394.0
2020-06-17 17:00:00	IWM	ETF	142.05	142.24	141.66	141.7	44580.0
2020-06-17 18:00:00	IWM	ETF	141.68	142.06	141.39	141.61	246745.0
2020-06-17 19:00:00	IWM	ETF	141.68	141.8	140.68	140.75	161108.0
2020-06-17 04:00:00	DIA	ETF	265.34	266.98	265.34	266.45	3100.0
2020-06-17 05:00:00	DIA	ETF	266.22	266.22	263.91	263.91	5200.0

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

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