PREVIEW / etf_1hour / 2021-06-17

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-06-17.parquet
  size:    417 KB
  rows:    14,761

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-17 04:00:00	SPY	ETF	420.26	420.86	419.91	420.1	11199.0
2021-06-17 05:00:00	SPY	ETF	420.12	420.78	420.12	420.78	16636.0
2021-06-17 06:00:00	SPY	ETF	420.78	420.96	420.32	420.73	33615.0
2021-06-17 07:00:00	SPY	ETF	420.71	421.42	420.56	420.59	139030.0
2021-06-17 08:00:00	SPY	ETF	420.58	421.38	420.1	420.76	413705.0
2021-06-17 09:00:00	SPY	ETF	420.78	422.9	420.7	421.835	6836217.0
2021-06-17 10:00:00	SPY	ETF	421.84	422.9325	421.1	421.8899	8339097.0
2021-06-17 11:00:00	SPY	ETF	421.88	422.62	421.17	421.28	6356453.0
2021-06-17 12:00:00	SPY	ETF	421.29	421.415	419.32	421.12	8670781.0
2021-06-17 13:00:00	SPY	ETF	421.115	422.62	421.07	422.19	5841074.0
2021-06-17 14:00:00	SPY	ETF	422.18	422.36	421.64	421.81	4547116.0
2021-06-17 15:00:00	SPY	ETF	421.815	423.02	421.5827	421.98	11717153.0
2021-06-17 16:00:00	SPY	ETF	421.99	422.36	421.92	422.26	3944102.0
2021-06-17 17:00:00	SPY	ETF	422.0	422.24	421.97	422.24	4141965.0
2021-06-17 18:00:00	SPY	ETF	422.23	422.62	422.17	422.56	77931.0
2021-06-17 19:00:00	SPY	ETF	422.5	422.61	422.17	422.31	41942.0
2021-06-17 04:00:00	QQQ	ETF	338.92	339.38	338.4	338.65	74827.0
2021-06-17 05:00:00	QQQ	ETF	338.67	339.3	338.6	339.29	31723.0
2021-06-17 06:00:00	QQQ	ETF	339.29	339.52	338.7	339.27	82252.0
2021-06-17 07:00:00	QQQ	ETF	339.24	339.94	339.18	339.22	187445.0
2021-06-17 08:00:00	QQQ	ETF	339.21	341.265	338.69	339.38	269828.0
2021-06-17 09:00:00	QQQ	ETF	339.46	342.39	339.27	342.16	4080099.0
2021-06-17 10:00:00	QQQ	ETF	342.18	344.68	341.95	344.04	7016394.0
2021-06-17 11:00:00	QQQ	ETF	344.045	346.2	343.96	344.99	8198001.0
2021-06-17 12:00:00	QQQ	ETF	345.0	345.26	343.02	344.13	6162507.0
2021-06-17 13:00:00	QQQ	ETF	344.15	346.135	344.125	345.62	4423326.0
2021-06-17 14:00:00	QQQ	ETF	345.61	345.96	345.25	345.52	2715750.0
2021-06-17 15:00:00	QQQ	ETF	345.54	346.38	345.2	345.34	6711189.0
2021-06-17 16:00:00	QQQ	ETF	345.35	346.0	345.27	345.85	2118472.0
2021-06-17 17:00:00	QQQ	ETF	345.71	345.85	345.34	345.76	221307.0
2021-06-17 18:00:00	QQQ	ETF	345.8	346.16	345.78	346.15	86008.0
2021-06-17 19:00:00	QQQ	ETF	346.12	346.13	345.78	345.86	86425.0
2021-06-17 04:00:00	IWM	ETF	228.64	229.08	228.35	228.57	14911.0
2021-06-17 05:00:00	IWM	ETF	228.82	228.96	228.77	228.96	4048.0
2021-06-17 06:00:00	IWM	ETF	228.94	229.0	228.59	228.7	20320.0
2021-06-17 07:00:00	IWM	ETF	228.86	229.42	228.78	228.81	38516.0
2021-06-17 08:00:00	IWM	ETF	229.18	229.2	228.38	229.03	116182.0
2021-06-17 09:00:00	IWM	ETF	229.05	230.2	229.03	229.243	2722143.0
2021-06-17 10:00:00	IWM	ETF	229.25	229.665	228.01	228.3	4233984.0
2021-06-17 11:00:00	IWM	ETF	228.29	228.39	226.11	226.13	4217400.0
2021-06-17 12:00:00	IWM	ETF	226.12	226.62	224.52	225.99	4636560.0
2021-06-17 13:00:00	IWM	ETF	225.98	227.37	225.82	227.0	2499004.0
2021-06-17 14:00:00	IWM	ETF	227.01	227.09	226.46	226.81	2362949.0
2021-06-17 15:00:00	IWM	ETF	226.81	227.79	226.58	227.27	5048059.0
2021-06-17 16:00:00	IWM	ETF	227.29	227.47	227.06	227.26	873670.0
2021-06-17 17:00:00	IWM	ETF	227.2	227.29	227.15	227.2	300729.0
2021-06-17 18:00:00	IWM	ETF	227.27	227.59	227.17	227.34	277136.0
2021-06-17 19:00:00	IWM	ETF	227.639	227.639	227.36	227.49	15066.0
2021-06-17 04:00:00	DIA	ETF	339.21	339.69	339.1	339.1	13505.0
2021-06-17 05:00:00	DIA	ETF	339.49	339.5	339.49	339.5	532.0

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

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