PREVIEW / etf_1hour / 2021-06-16

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-06-16.parquet
  size:    408 KB
  rows:    14,316

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
2021-06-16 04:00:00	SPY	ETF	424.22	424.23	423.88	424.22	9434.0
2021-06-16 05:00:00	SPY	ETF	424.3	424.32	423.93	424.14	13612.0
2021-06-16 06:00:00	SPY	ETF	424.15	424.69	424.06	424.27	23241.0
2021-06-16 07:00:00	SPY	ETF	424.2	424.3	424.08	424.12	31258.0
2021-06-16 08:00:00	SPY	ETF	424.2401	424.43	423.98	424.35	64505.0
2021-06-16 09:00:00	SPY	ETF	424.4	424.87	424.13	424.3088	2964566.0
2021-06-16 10:00:00	SPY	ETF	424.3	424.58	424.05	424.215	3367375.0
2021-06-16 11:00:00	SPY	ETF	424.21	424.57	424.1	424.23	2055207.0
2021-06-16 12:00:00	SPY	ETF	424.235	424.34	423.23	423.51	3395981.0
2021-06-16 13:00:00	SPY	ETF	423.515	423.62	422.6	423.135	4114894.0
2021-06-16 14:00:00	SPY	ETF	423.13	423.13	419.92	421.6611	22876068.0
2021-06-16 15:00:00	SPY	ETF	421.67	423.59	421.41	422.12	16818857.0
2021-06-16 16:00:00	SPY	ETF	422.13	422.45	420.94	421.01	3181015.0
2021-06-16 17:00:00	SPY	ETF	421.0	421.15	420.91	421.14	240108.0
2021-06-16 18:00:00	SPY	ETF	421.15	422.11	420.8	420.98	108174.0
2021-06-16 19:00:00	SPY	ETF	420.9	421.0	420.0	420.35	82815.0
2021-06-16 04:00:00	QQQ	ETF	342.42	342.45	342.17	342.41	34107.0
2021-06-16 05:00:00	QQQ	ETF	342.45	342.49	342.14	342.33	14618.0
2021-06-16 06:00:00	QQQ	ETF	342.39	342.63	342.33	342.4	34214.0
2021-06-16 07:00:00	QQQ	ETF	342.38	342.58	342.24	342.26	57844.0
2021-06-16 08:00:00	QQQ	ETF	342.5704	342.6096	342.0	342.58	108309.0
2021-06-16 09:00:00	QQQ	ETF	342.58	343.65	342.54	343.46	2647771.0
2021-06-16 10:00:00	QQQ	ETF	343.48	343.84	342.715	342.99	2977230.0
2021-06-16 11:00:00	QQQ	ETF	342.99	343.06	342.11	342.17	2410874.0
2021-06-16 12:00:00	QQQ	ETF	342.16	342.6208	340.96	341.9582	2854692.0
2021-06-16 13:00:00	QQQ	ETF	341.95	342.5	341.665	341.91	2595273.0
2021-06-16 14:00:00	QQQ	ETF	341.88	341.9	337.45	339.56	17765030.0
2021-06-16 15:00:00	QQQ	ETF	339.55	342.3	339.325	340.94	11015222.0
2021-06-16 16:00:00	QQQ	ETF	340.96	341.11	339.85	339.85	1233756.0
2021-06-16 17:00:00	QQQ	ETF	339.85	340.12	339.85	340.1	107557.0
2021-06-16 18:00:00	QQQ	ETF	340.1	340.1	339.5	339.56	100013.0
2021-06-16 19:00:00	QQQ	ETF	339.49	339.58	338.75	338.76	214098.0
2021-06-16 04:00:00	IWM	ETF	230.05	230.1	230.04	230.1	3730.0
2021-06-16 05:00:00	IWM	ETF	230.04	230.06	229.74	230.04	3010.0
2021-06-16 06:00:00	IWM	ETF	230.01	230.34	230.01	230.09	4500.0
2021-06-16 07:00:00	IWM	ETF	229.95	229.97	229.69	229.8	21899.0
2021-06-16 08:00:00	IWM	ETF	229.8699	230.2904	229.58	229.77	50103.0
2021-06-16 09:00:00	IWM	ETF	229.84	229.9	228.4	228.68	2254715.0
2021-06-16 10:00:00	IWM	ETF	228.69	229.455	228.43	229.31	1992092.0
2021-06-16 11:00:00	IWM	ETF	229.31	230.68	229.22	230.4101	1261750.0
2021-06-16 12:00:00	IWM	ETF	230.42	230.5925	228.74	228.98	1644049.0
2021-06-16 13:00:00	IWM	ETF	228.99	229.36	228.415	229.24	1684736.0
2021-06-16 14:00:00	IWM	ETF	229.23	229.64	227.64	228.91	5304183.0
2021-06-16 15:00:00	IWM	ETF	228.9	230.63	228.71	229.88	4468039.0
2021-06-16 16:00:00	IWM	ETF	229.87	230.28	229.0	229.03	1080431.0
2021-06-16 17:00:00	IWM	ETF	228.94	229.87	228.94	229.1	371391.0
2021-06-16 18:00:00	IWM	ETF	229.1	229.21	228.9	229.21	27518.0
2021-06-16 19:00:00	IWM	ETF	229.13	229.15	228.57	228.6	70100.0
2021-06-16 04:00:00	DIA	ETF	342.89	342.89	342.6	342.6	500.0
2021-06-16 05:00:00	DIA	ETF	342.9	342.92	342.62	342.62	1400.0

> showing 50 of 14,316 rows — these rows as CSV

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