PREVIEW / etf_1hour / 2021-01-22

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-01-22.parquet
  size:    420 KB
  rows:    14,328

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-01-22 04:00:00	SPY	ETF	382.59	382.71	381.38	381.73	44202.0
2021-01-22 05:00:00	SPY	ETF	381.6	382.05	381.36	381.43	88515.0
2021-01-22 06:00:00	SPY	ETF	381.59	381.62	381.02	381.61	206733.0
2021-01-22 07:00:00	SPY	ETF	381.46	381.78	380.97	381.64	423067.0
2021-01-22 08:00:00	SPY	ETF	381.6	383.4	381.0	381.72	534863.0
2021-01-22 09:00:00	SPY	ETF	381.66	383.0707	381.59	382.9299	4842578.0
2021-01-22 10:00:00	SPY	ETF	382.915	383.32	381.835	382.75	5358118.0
2021-01-22 11:00:00	SPY	ETF	382.74	383.695	382.6	383.61	3709666.0
2021-01-22 12:00:00	SPY	ETF	383.61	383.84	383.28	383.4831	2248470.0
2021-01-22 13:00:00	SPY	ETF	383.483	383.73	382.94	383.22	2381432.0
2021-01-22 14:00:00	SPY	ETF	383.225	383.76	383.025	383.73	3364499.0
2021-01-22 15:00:00	SPY	ETF	383.732	384.08	382.8	382.86	7837384.0
2021-01-22 16:00:00	SPY	ETF	382.85	383.1	382.63	382.64	5040773.0
2021-01-22 17:00:00	SPY	ETF	382.74	382.88	382.66	382.72	201532.0
2021-01-22 18:00:00	SPY	ETF	382.7	382.88	382.5	382.6	50815.0
2021-01-22 19:00:00	SPY	ETF	382.66	382.83	382.52	382.74	64309.0
2021-01-22 04:00:00	QQQ	ETF	325.21	325.21	324.42	324.82	52321.0
2021-01-22 05:00:00	QQQ	ETF	324.76	324.99	324.51	324.64	53767.0
2021-01-22 06:00:00	QQQ	ETF	324.74	324.75	324.33	324.66	43596.0
2021-01-22 07:00:00	QQQ	ETF	324.74	324.92	324.15	324.62	151177.0
2021-01-22 08:00:00	QQQ	ETF	324.61	326.36	324.17	324.73	301759.0
2021-01-22 09:00:00	QQQ	ETF	324.66	326.35	324.64	326.1528	2846580.0
2021-01-22 10:00:00	QQQ	ETF	326.16	326.36	324.71	325.3702	2855110.0
2021-01-22 11:00:00	QQQ	ETF	325.38	326.0	325.0599	325.78	1566226.0
2021-01-22 12:00:00	QQQ	ETF	325.8	326.04	325.4216	325.54	1228320.0
2021-01-22 13:00:00	QQQ	ETF	325.54	326.02	325.13	325.55	1103999.0
2021-01-22 14:00:00	QQQ	ETF	325.5263	326.3496	325.37	326.2801	1364164.0
2021-01-22 15:00:00	QQQ	ETF	326.29	326.46	325.41	325.46	3674708.0
2021-01-22 16:00:00	QQQ	ETF	325.46	325.7	325.2	325.42	1217149.0
2021-01-22 17:00:00	QQQ	ETF	325.58	325.58	325.15	325.4	210688.0
2021-01-22 18:00:00	QQQ	ETF	325.39	325.6	325.38	325.5	30658.0
2021-01-22 19:00:00	QQQ	ETF	325.5	325.81	325.49	325.6	23257.0
2021-01-22 04:00:00	IWM	ETF	211.48	211.96	210.6	210.6	29442.0
2021-01-22 05:00:00	IWM	ETF	210.62	210.82	210.45	210.45	29271.0
2021-01-22 06:00:00	IWM	ETF	210.59	210.71	210.1	210.7	95545.0
2021-01-22 07:00:00	IWM	ETF	210.53	210.8	210.19	210.59	50172.0
2021-01-22 08:00:00	IWM	ETF	210.68	212.15	210.16	210.17	157937.0
2021-01-22 09:00:00	IWM	ETF	210.13	211.7	209.54	211.55	3359681.0
2021-01-22 10:00:00	IWM	ETF	211.56	212.05	210.6	211.68	2911583.0
2021-01-22 11:00:00	IWM	ETF	211.69	212.51	211.38	212.31	1768213.0
2021-01-22 12:00:00	IWM	ETF	212.31	212.995	211.98	212.82	1773504.0
2021-01-22 13:00:00	IWM	ETF	212.88	213.08	212.3	212.59	1259832.0
2021-01-22 14:00:00	IWM	ETF	212.6	213.775	212.28	213.75	2100541.0
2021-01-22 15:00:00	IWM	ETF	213.75	215.33	213.69	215.03	4317295.0
2021-01-22 16:00:00	IWM	ETF	215.0	215.2844	213.0293	214.45	2070242.0
2021-01-22 17:00:00	IWM	ETF	214.6	215.0	214.6	214.75	23339.0
2021-01-22 18:00:00	IWM	ETF	214.72	214.87	214.63	214.87	3538.0
2021-01-22 19:00:00	IWM	ETF	214.88	214.89	214.31	214.69	4634.0
2021-01-22 04:00:00	DIA	ETF	310.06	310.1	309.5	309.52	1300.0
2021-01-22 05:00:00	DIA	ETF	309.5	309.62	309.48	309.48	5237.0

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

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