PREVIEW / etf_1hour / 2022-08-11

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-08-11.parquet
  size:    459 KB
  rows:    16,355

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
2022-08-11 04:00:00	SPY	ETF	421.0	421.0	420.3	420.75	28261.0
2022-08-11 05:00:00	SPY	ETF	420.88	421.52	420.65	421.27	43817.0
2022-08-11 06:00:00	SPY	ETF	421.3	421.32	420.82	421.17	37406.0
2022-08-11 07:00:00	SPY	ETF	421.16	421.9	421.05	421.7	129720.0
2022-08-11 08:00:00	SPY	ETF	421.73	423.49	420.7112	423.35	877296.0
2022-08-11 09:00:00	SPY	ETF	423.37	423.53	422.24	423.32	5348067.0
2022-08-11 10:00:00	SPY	ETF	423.32	424.95	423.22	423.595	7920979.0
2022-08-11 11:00:00	SPY	ETF	423.59	423.67	421.1	421.62	6210630.0
2022-08-11 12:00:00	SPY	ETF	421.63	422.52	421.14	422.4	3425738.0
2022-08-11 13:00:00	SPY	ETF	422.4	423.0	421.74	421.95	3203984.0
2022-08-11 14:00:00	SPY	ETF	421.95	421.95	419.53	420.13	5565265.0
2022-08-11 15:00:00	SPY	ETF	420.14	420.36	419.21	420.01	9771162.0
2022-08-11 16:00:00	SPY	ETF	420.0	420.84	419.8394	420.73	2631534.0
2022-08-11 17:00:00	SPY	ETF	420.7	420.74	420.5	420.69	56561.0
2022-08-11 18:00:00	SPY	ETF	420.7	420.75	420.14	420.29	102835.0
2022-08-11 19:00:00	SPY	ETF	420.28	420.45	420.2	420.4	82586.0
2022-08-11 04:00:00	QQQ	ETF	326.51	327.15	325.88	326.31	96588.0
2022-08-11 05:00:00	QQQ	ETF	326.44	327.05	326.17	326.84	29144.0
2022-08-11 06:00:00	QQQ	ETF	326.82	326.82	326.24	326.59	42345.0
2022-08-11 07:00:00	QQQ	ETF	326.45	327.38	326.3	327.32	197184.0
2022-08-11 08:00:00	QQQ	ETF	326.4299	328.75	325.9396	328.64	1056424.0
2022-08-11 09:00:00	QQQ	ETF	328.64	328.82	327.47	328.38	5531151.0
2022-08-11 10:00:00	QQQ	ETF	328.38	330.36	327.69	328.1601	7119617.0
2022-08-11 11:00:00	QQQ	ETF	328.19	328.34	325.16	325.87	6183321.0
2022-08-11 12:00:00	QQQ	ETF	325.8802	326.85	325.4447	326.64	2963367.0
2022-08-11 13:00:00	QQQ	ETF	326.63	327.14	325.725	325.9	2211137.0
2022-08-11 14:00:00	QQQ	ETF	325.91	325.91	323.55	324.16	3701165.0
2022-08-11 15:00:00	QQQ	ETF	324.16	324.49	323.36	324.08	5581020.0
2022-08-11 16:00:00	QQQ	ETF	324.06	324.77	324.06	324.75	1435455.0
2022-08-11 17:00:00	QQQ	ETF	324.72	324.85	324.7	324.7	66010.0
2022-08-11 18:00:00	QQQ	ETF	324.74	324.74	324.15	324.39	110126.0
2022-08-11 19:00:00	QQQ	ETF	324.39	324.57	324.31	324.56	54631.0
2022-08-11 04:00:00	IWM	ETF	196.18	196.32	196.02	196.32	24223.0
2022-08-11 05:00:00	IWM	ETF	196.36	196.58	196.2	196.47	11337.0
2022-08-11 06:00:00	IWM	ETF	196.49	196.53	196.29	196.53	8894.0
2022-08-11 07:00:00	IWM	ETF	196.37	196.85	196.37	196.75	28158.0
2022-08-11 08:00:00	IWM	ETF	196.38	197.65	196.38	197.49	150906.0
2022-08-11 09:00:00	IWM	ETF	197.48	198.29	197.24	198.14	2506086.0
2022-08-11 10:00:00	IWM	ETF	198.17	199.53	198.07	198.76	4106312.0
2022-08-11 11:00:00	IWM	ETF	198.76	198.82	196.58	196.925	2774276.0
2022-08-11 12:00:00	IWM	ETF	196.95	197.7	196.48	197.65	1521285.0
2022-08-11 13:00:00	IWM	ETF	197.66	197.74	197.16	197.29	832163.0
2022-08-11 14:00:00	IWM	ETF	197.3	197.41	196.28	196.505	2051175.0
2022-08-11 15:00:00	IWM	ETF	196.51	196.63	196.04	196.38	3156121.0
2022-08-11 16:00:00	IWM	ETF	196.35	196.91	196.35	196.81	547187.0
2022-08-11 17:00:00	IWM	ETF	196.91	196.96	196.48	196.66	31058.0
2022-08-11 18:00:00	IWM	ETF	196.74	196.9	196.49	196.65	22632.0
2022-08-11 19:00:00	IWM	ETF	196.65	196.7	196.52	196.58	37501.0
2022-08-11 04:00:00	DIA	ETF	334.18	334.18	334.18	334.18	1470.0
2022-08-11 05:00:00	DIA	ETF	334.21	334.53	334.11	334.51	6600.0

> showing 50 of 16,355 rows — these rows as CSV

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