PREVIEW / etf_1hour / 2022-12-27

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-12-27.parquet
  size:    476 KB
  rows:    17,531

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-12-27 04:00:00	SPY	ETF	384.17	385.52	384.17	385.46	38492.0
2022-12-27 05:00:00	SPY	ETF	385.46	385.71	385.38	385.38	20899.0
2022-12-27 06:00:00	SPY	ETF	385.45	385.47	385.16	385.33	15891.0
2022-12-27 07:00:00	SPY	ETF	385.27	385.27	384.13	384.37	188235.0
2022-12-27 08:00:00	SPY	ETF	385.11	385.55	382.96	382.96	415677.0
2022-12-27 09:00:00	SPY	ETF	382.94	383.35	380.03	380.5114	4987016.0
2022-12-27 10:00:00	SPY	ETF	380.52	383.15	379.65	381.925	7510475.0
2022-12-27 11:00:00	SPY	ETF	381.93	382.9	381.61	382.29	3955711.0
2022-12-27 12:00:00	SPY	ETF	382.32	383.12	381.465	382.105	3100335.0
2022-12-27 13:00:00	SPY	ETF	382.11	382.61	381.01	381.18	3041311.0
2022-12-27 14:00:00	SPY	ETF	381.15	381.69	380.5	381.3399	4483811.0
2022-12-27 15:00:00	SPY	ETF	381.34	382.36	380.71	381.39	8574220.0
2022-12-27 16:00:00	SPY	ETF	381.39	381.76	381.37	381.5	1372562.0
2022-12-27 17:00:00	SPY	ETF	381.45	381.55	381.4	381.55	10870.0
2022-12-27 18:00:00	SPY	ETF	381.55	381.78	381.29	381.31	58533.0
2022-12-27 19:00:00	SPY	ETF	381.4	381.7	381.0	381.09	67872.0
2022-12-27 04:00:00	QQQ	ETF	269.29	269.44	268.31	268.99	73320.0
2022-12-27 05:00:00	QQQ	ETF	268.98	269.24	268.85	268.85	24155.0
2022-12-27 06:00:00	QQQ	ETF	268.85	269.06	268.6	268.73	28478.0
2022-12-27 07:00:00	QQQ	ETF	268.73	268.75	267.43	267.63	186509.0
2022-12-27 08:00:00	QQQ	ETF	268.6603	269.45	266.52	266.86	365749.0
2022-12-27 09:00:00	QQQ	ETF	266.83	267.36	263.23	263.85	4135442.0
2022-12-27 10:00:00	QQQ	ETF	263.82	265.98	263.03	264.87	5535740.0
2022-12-27 11:00:00	QQQ	ETF	264.9	265.5	264.34	264.745	3067079.0
2022-12-27 12:00:00	QQQ	ETF	264.74	265.48	263.86	264.425	3046970.0
2022-12-27 13:00:00	QQQ	ETF	264.405	264.84	263.47	263.62	2031675.0
2022-12-27 14:00:00	QQQ	ETF	263.62	264.08	263.16	263.72	2714388.0
2022-12-27 15:00:00	QQQ	ETF	263.73	264.55	263.3323	263.54	5388651.0
2022-12-27 16:00:00	QQQ	ETF	263.535	263.92	263.3995	263.41	1362587.0
2022-12-27 17:00:00	QQQ	ETF	263.46	263.5	263.35	263.46	26195.0
2022-12-27 18:00:00	QQQ	ETF	263.51	263.71	263.33	263.41	41437.0
2022-12-27 19:00:00	QQQ	ETF	263.48	263.7	262.95	262.98	77221.0
2022-12-27 04:00:00	IWM	ETF	175.36	175.97	175.06	175.97	16954.0
2022-12-27 05:00:00	IWM	ETF	175.96	176.04	175.88	175.93	8984.0
2022-12-27 06:00:00	IWM	ETF	175.85	175.92	175.76	175.86	6722.0
2022-12-27 07:00:00	IWM	ETF	175.79	175.85	175.35	175.4	19333.0
2022-12-27 08:00:00	IWM	ETF	175.75	175.76	174.46	174.46	91097.0
2022-12-27 09:00:00	IWM	ETF	174.44	174.68	172.73	173.06	1820160.0
2022-12-27 10:00:00	IWM	ETF	173.06	174.57	172.83	173.81	1878668.0
2022-12-27 11:00:00	IWM	ETF	173.82	174.19	173.63	173.91	1130741.0
2022-12-27 12:00:00	IWM	ETF	173.95	174.28	173.34	173.67	794911.0
2022-12-27 13:00:00	IWM	ETF	173.67	173.93	173.0301	173.09	766939.0
2022-12-27 14:00:00	IWM	ETF	173.08	173.275	172.58	173.08	1088985.0
2022-12-27 15:00:00	IWM	ETF	173.1	173.42	173.03	173.24	1766870.0
2022-12-27 16:00:00	IWM	ETF	173.22	173.32	173.12	173.2	449700.0
2022-12-27 17:00:00	IWM	ETF	173.14	173.22	172.98	173.07	5179.0
2022-12-27 18:00:00	IWM	ETF	173.19	173.35	173.09	173.16	12736.0
2022-12-27 19:00:00	IWM	ETF	173.22	173.22	172.96	172.96	36562.0
2022-12-27 04:00:00	DIA	ETF	333.6	334.0	333.43	334.0	2401.0
2022-12-27 05:00:00	DIA	ETF	333.99	334.21	333.99	334.21	400.0

> showing 50 of 17,531 rows — these rows as CSV

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