PREVIEW / etf_1hour / 2021-06-09

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-06-09.parquet
  size:    406 KB
  rows:    14,146

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-09 04:00:00	SPY	ETF	422.35	422.75	422.35	422.72	5670.0
2021-06-09 05:00:00	SPY	ETF	422.68	422.68	422.35	422.48	2755.0
2021-06-09 06:00:00	SPY	ETF	422.6	422.71	422.4	422.6	9229.0
2021-06-09 07:00:00	SPY	ETF	422.68	422.99	422.14	422.97	121906.0
2021-06-09 08:00:00	SPY	ETF	422.95	423.12	422.19	422.95	355533.0
2021-06-09 09:00:00	SPY	ETF	422.99	423.26	422.43	422.83	4610604.0
2021-06-09 10:00:00	SPY	ETF	422.84	423.0699	422.32	422.8382	4347266.0
2021-06-09 11:00:00	SPY	ETF	422.83	423.12	422.21	422.475	3229631.0
2021-06-09 12:00:00	SPY	ETF	422.47	422.7901	422.39	422.74	2031346.0
2021-06-09 13:00:00	SPY	ETF	422.75	422.9717	422.52	422.64	2507301.0
2021-06-09 14:00:00	SPY	ETF	422.65	422.88	422.36	422.43	3419720.0
2021-06-09 15:00:00	SPY	ETF	422.43	422.435	421.41	421.62	9698899.0
2021-06-09 16:00:00	SPY	ETF	421.61	422.05	421.5338	421.92	3075326.0
2021-06-09 17:00:00	SPY	ETF	421.86	421.93	421.65	421.87	125832.0
2021-06-09 18:00:00	SPY	ETF	421.92	422.09	421.65	422.02	69120.0
2021-06-09 19:00:00	SPY	ETF	422.02	422.1	421.78	421.85	30420.0
2021-06-09 04:00:00	QQQ	ETF	337.06	337.4	337.03	337.32	13295.0
2021-06-09 05:00:00	QQQ	ETF	337.26	337.26	336.9	337.06	18351.0
2021-06-09 06:00:00	QQQ	ETF	337.23	337.77	337.14	337.7	20604.0
2021-06-09 07:00:00	QQQ	ETF	337.71	337.98	337.2	337.85	90054.0
2021-06-09 08:00:00	QQQ	ETF	337.7204	338.19	336.66	337.99	246386.0
2021-06-09 09:00:00	QQQ	ETF	337.9896	338.97	337.51	338.2	4094348.0
2021-06-09 10:00:00	QQQ	ETF	338.16	338.38	337.06	337.61	2732492.0
2021-06-09 11:00:00	QQQ	ETF	337.595	338.05	336.86	337.19	1461606.0
2021-06-09 12:00:00	QQQ	ETF	337.18	338.13	337.07	338.09	1930408.0
2021-06-09 13:00:00	QQQ	ETF	338.11	338.295	337.8	337.91	1702745.0
2021-06-09 14:00:00	QQQ	ETF	337.93	338.16	337.4	337.4201	1730819.0
2021-06-09 15:00:00	QQQ	ETF	337.42	337.51	336.651	336.84	3749038.0
2021-06-09 16:00:00	QQQ	ETF	336.83	336.95	336.68	336.73	1071367.0
2021-06-09 17:00:00	QQQ	ETF	336.65	336.8	336.61	336.7	25554.0
2021-06-09 18:00:00	QQQ	ETF	336.7	337.02	336.7	336.84	49757.0
2021-06-09 19:00:00	QQQ	ETF	336.87	337.03	336.74	336.78	38656.0
2021-06-09 04:00:00	IWM	ETF	233.12	233.46	233.09	233.43	8100.0
2021-06-09 05:00:00	IWM	ETF	233.36	233.36	233.16	233.23	1400.0
2021-06-09 06:00:00	IWM	ETF	233.29	233.39	233.21	233.33	2700.0
2021-06-09 07:00:00	IWM	ETF	233.41	233.6	232.92	233.56	40690.0
2021-06-09 08:00:00	IWM	ETF	233.44	233.69	233.2	233.49	186618.0
2021-06-09 09:00:00	IWM	ETF	233.41	233.7	232.19	232.62	2392277.0
2021-06-09 10:00:00	IWM	ETF	232.63	233.12	232.24	232.42	1797221.0
2021-06-09 11:00:00	IWM	ETF	232.4	232.78	231.83	232.09	1363334.0
2021-06-09 12:00:00	IWM	ETF	232.07	232.87	231.965	232.8599	881208.0
2021-06-09 13:00:00	IWM	ETF	232.86	232.935	231.98	232.27	1102518.0
2021-06-09 14:00:00	IWM	ETF	232.27	232.45	232.06	232.27	1616205.0
2021-06-09 15:00:00	IWM	ETF	232.25	232.34	230.98	231.37	3377070.0
2021-06-09 16:00:00	IWM	ETF	231.34	231.53	231.3	231.41	1698993.0
2021-06-09 17:00:00	IWM	ETF	231.34	231.55	231.25	231.32	194295.0
2021-06-09 18:00:00	IWM	ETF	231.4	231.6	231.28	231.53	40249.0
2021-06-09 19:00:00	IWM	ETF	231.49	231.65	231.35	231.47	34188.0
2021-06-09 04:00:00	DIA	ETF	346.37	346.37	346.37	346.37	103.0
2021-06-09 05:00:00	DIA	ETF	346.15	346.25	346.12	346.18	700.0

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

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