PREVIEW / etf_1hour / 2021-12-21

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-12-21.parquet
  size:    451 KB
  rows:    16,114

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-12-21 04:00:00	SPY	ETF	457.56	458.43	457.2	457.2	40339.0
2021-12-21 05:00:00	SPY	ETF	457.1	458.41	457.09	458.41	14271.0
2021-12-21 06:00:00	SPY	ETF	458.37	459.6	458.34	459.41	112134.0
2021-12-21 07:00:00	SPY	ETF	459.47	459.75	459.19	459.56	177838.0
2021-12-21 08:00:00	SPY	ETF	459.62	459.69	455.321	459.17	567816.0
2021-12-21 09:00:00	SPY	ETF	459.16	459.5	457.1	457.39	6262911.0
2021-12-21 10:00:00	SPY	ETF	457.4	458.77	456.31	457.48	7648576.0
2021-12-21 11:00:00	SPY	ETF	457.475	460.36	457.21	459.785	6833524.0
2021-12-21 12:00:00	SPY	ETF	459.78	461.94	459.7	461.86	5173727.0
2021-12-21 13:00:00	SPY	ETF	461.87	462.54	461.265	462.1475	5264139.0
2021-12-21 14:00:00	SPY	ETF	462.15	462.78	461.71	462.77	4870186.0
2021-12-21 15:00:00	SPY	ETF	462.77	463.21	461.23	463.05	13193948.0
2021-12-21 16:00:00	SPY	ETF	463.03	463.44	462.53	463.23	3474529.0
2021-12-21 17:00:00	SPY	ETF	463.3	463.36	463.0499	463.05	135928.0
2021-12-21 18:00:00	SPY	ETF	463.11	463.22	462.69	462.84	129739.0
2021-12-21 19:00:00	SPY	ETF	462.78	463.06	462.5	462.71	74790.0
2021-12-21 04:00:00	QQQ	ETF	383.99	384.42	383.17	383.28	69866.0
2021-12-21 05:00:00	QQQ	ETF	383.18	383.95	382.92	383.87	53145.0
2021-12-21 06:00:00	QQQ	ETF	383.89	385.07	383.78	384.85	73240.0
2021-12-21 07:00:00	QQQ	ETF	384.85	385.41	384.61	385.23	121518.0
2021-12-21 08:00:00	QQQ	ETF	384.7101	385.5	380.975	385.01	244193.0
2021-12-21 09:00:00	QQQ	ETF	385.0	385.04	381.61	381.63	5068840.0
2021-12-21 10:00:00	QQQ	ETF	381.64	382.67	380.201	381.81	6224302.0
2021-12-21 11:00:00	QQQ	ETF	381.805	384.985	381.52	384.4899	4338281.0
2021-12-21 12:00:00	QQQ	ETF	384.47	386.61	384.25	386.55	3218373.0
2021-12-21 13:00:00	QQQ	ETF	386.56	388.02	386.09	387.77	3028443.0
2021-12-21 14:00:00	QQQ	ETF	387.79	389.21	387.67	389.2	3910938.0
2021-12-21 15:00:00	QQQ	ETF	389.21	389.53	387.62	389.22	8231998.0
2021-12-21 16:00:00	QQQ	ETF	389.21	389.35	388.85	389.19	1973506.0
2021-12-21 17:00:00	QQQ	ETF	389.27	389.32	389.05	389.06	82672.0
2021-12-21 18:00:00	QQQ	ETF	389.06	389.35	388.74	388.87	59592.0
2021-12-21 19:00:00	QQQ	ETF	388.82	389.08	388.42	388.4304	147338.0
2021-12-21 04:00:00	IWM	ETF	213.26	213.84	213.15	213.21	17721.0
2021-12-21 05:00:00	IWM	ETF	213.12	214.23	213.12	214.23	12140.0
2021-12-21 06:00:00	IWM	ETF	214.1	215.26	214.1	215.03	173085.0
2021-12-21 07:00:00	IWM	ETF	215.01	215.01	214.72	214.84	121168.0
2021-12-21 08:00:00	IWM	ETF	213.6396	215.18	213.6396	214.52	192873.0
2021-12-21 09:00:00	IWM	ETF	214.52	216.09	214.165	214.9	4573561.0
2021-12-21 10:00:00	IWM	ETF	214.91	217.22	214.91	215.94	5746276.0
2021-12-21 11:00:00	IWM	ETF	215.91	217.14	215.62	216.875	3198470.0
2021-12-21 12:00:00	IWM	ETF	216.87	217.6	216.785	217.5	2501703.0
2021-12-21 13:00:00	IWM	ETF	217.49	218.1599	217.21	217.9	1992084.0
2021-12-21 14:00:00	IWM	ETF	217.9	218.11	217.4179	218.03	1898593.0
2021-12-21 15:00:00	IWM	ETF	218.03	218.385	217.29	218.18	5808002.0
2021-12-21 16:00:00	IWM	ETF	218.18	218.8	218.07	218.67	1779779.0
2021-12-21 17:00:00	IWM	ETF	218.55	219.0	218.18	218.65	213941.0
2021-12-21 18:00:00	IWM	ETF	218.68	218.72	218.18	218.26	28771.0
2021-12-21 19:00:00	IWM	ETF	218.19	218.45	218.06	218.17	32215.0
2021-12-21 04:00:00	DIA	ETF	350.95	351.49	350.95	351.29	555.0
2021-12-21 05:00:00	DIA	ETF	351.59	351.59	351.59	351.59	100.0

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

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