PREVIEW / etf_1hour / 2021-06-08

all etf 1-hour files

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

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-08 04:00:00	SPY	ETF	422.07	422.41	421.95	422.41	76976.0
2021-06-08 05:00:00	SPY	ETF	422.35	422.79	422.28	422.66	34876.0
2021-06-08 06:00:00	SPY	ETF	422.59	422.59	421.0	422.5	308803.0
2021-06-08 07:00:00	SPY	ETF	422.5	423.03	422.37	423.03	110170.0
2021-06-08 08:00:00	SPY	ETF	422.66	423.38	421.4896	423.08	229176.0
2021-06-08 09:00:00	SPY	ETF	423.07	423.32	421.64	421.77	5064433.0
2021-06-08 10:00:00	SPY	ETF	421.75	422.26	421.54	421.88	5020248.0
2021-06-08 11:00:00	SPY	ETF	421.89	422.22	420.32	422.025	7769031.0
2021-06-08 12:00:00	SPY	ETF	422.02	422.65	421.92	422.57	3177826.0
2021-06-08 13:00:00	SPY	ETF	422.57	422.655	422.17	422.23	2324155.0
2021-06-08 14:00:00	SPY	ETF	422.24	422.79	422.14	422.745	2568843.0
2021-06-08 15:00:00	SPY	ETF	422.75	422.94	422.2425	422.27	8154145.0
2021-06-08 16:00:00	SPY	ETF	422.27	422.4	422.05	422.25	2014907.0
2021-06-08 17:00:00	SPY	ETF	422.25	422.28	422.2	422.23	9771.0
2021-06-08 18:00:00	SPY	ETF	422.28	422.4	421.97	422.4	56124.0
2021-06-08 19:00:00	SPY	ETF	422.4	422.4999	422.28	422.38	28959.0
2021-06-08 04:00:00	QQQ	ETF	336.84	337.19	336.44	337.19	19955.0
2021-06-08 05:00:00	QQQ	ETF	337.17	337.66	337.16	337.61	14488.0
2021-06-08 06:00:00	QQQ	ETF	337.59	337.6	336.12	337.55	285509.0
2021-06-08 07:00:00	QQQ	ETF	337.48	338.33	337.4	338.31	123294.0
2021-06-08 08:00:00	QQQ	ETF	337.3196	338.8	336.14	338.38	337409.0
2021-06-08 09:00:00	QQQ	ETF	338.34	339.29	337.22	337.41	3885086.0
2021-06-08 10:00:00	QQQ	ETF	337.41	337.79	336.39	336.62	3788498.0
2021-06-08 11:00:00	QQQ	ETF	336.64	337.02	335.03	336.035	3967464.0
2021-06-08 12:00:00	QQQ	ETF	336.03	337.05	335.9	337.0	1673242.0
2021-06-08 13:00:00	QQQ	ETF	337.0	337.0057	336.32	336.46	1366676.0
2021-06-08 14:00:00	QQQ	ETF	336.4592	337.24	336.31	337.18	1546222.0
2021-06-08 15:00:00	QQQ	ETF	337.1782	337.36	336.63	336.65	3461176.0
2021-06-08 16:00:00	QQQ	ETF	336.65	336.95	336.61	336.72	2608900.0
2021-06-08 17:00:00	QQQ	ETF	336.64	336.76	336.62	336.71	19484.0
2021-06-08 18:00:00	QQQ	ETF	336.71	336.99	336.6	336.99	47112.0
2021-06-08 19:00:00	QQQ	ETF	336.96	337.01	336.79	336.93	23287.0
2021-06-08 04:00:00	IWM	ETF	230.55	230.57	230.31	230.55	17200.0
2021-06-08 05:00:00	IWM	ETF	230.59	231.01	230.52	230.77	20699.0
2021-06-08 06:00:00	IWM	ETF	230.78	230.85	229.64	230.71	50800.0
2021-06-08 07:00:00	IWM	ETF	230.7	231.06	230.56	231.06	50150.0
2021-06-08 08:00:00	IWM	ETF	230.91	231.35	230.69	231.25	108889.0
2021-06-08 09:00:00	IWM	ETF	231.36	231.83	230.54	231.06	2978211.0
2021-06-08 10:00:00	IWM	ETF	231.06	232.48	230.83	231.9	3646459.0
2021-06-08 11:00:00	IWM	ETF	231.915	231.92	229.98	231.47	2952487.0
2021-06-08 12:00:00	IWM	ETF	231.46	232.24	231.44	232.16	1528179.0
2021-06-08 13:00:00	IWM	ETF	232.15	232.68	232.08	232.41	1476310.0
2021-06-08 14:00:00	IWM	ETF	232.41	233.15	232.35	233.05	2012492.0
2021-06-08 15:00:00	IWM	ETF	233.05	233.4818	232.83	232.89	4518939.0
2021-06-08 16:00:00	IWM	ETF	232.89	233.19	232.7	232.85	3073430.0
2021-06-08 17:00:00	IWM	ETF	232.98	232.98	232.72	232.81	318230.0
2021-06-08 18:00:00	IWM	ETF	232.73	232.99	232.67	232.97	26056.0
2021-06-08 19:00:00	IWM	ETF	232.99	233.05	232.93	232.98	20629.0
2021-06-08 04:00:00	DIA	ETF	346.13	346.15	346.13	346.15	200.0
2021-06-08 05:00:00	DIA	ETF	346.46	346.46	346.46	346.46	400.0

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

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