PREVIEW / etf_1hour / 2022-02-03

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-02-03.parquet
  size:    458 KB
  rows:    16,375

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-02-03 04:00:00	SPY	ETF	453.28	453.57	452.03	452.07	37935.0
2022-02-03 05:00:00	SPY	ETF	452.19	452.79	451.93	452.19	50303.0
2022-02-03 06:00:00	SPY	ETF	452.2	452.64	451.59	452.5	48546.0
2022-02-03 07:00:00	SPY	ETF	452.44	453.59	451.9	453.15	435550.0
2022-02-03 08:00:00	SPY	ETF	452.9	457.693	450.71	450.78	819212.0
2022-02-03 09:00:00	SPY	ETF	450.75	452.34	450.0	450.27	11586263.0
2022-02-03 10:00:00	SPY	ETF	450.29	452.92	450.05	451.98	12359935.0
2022-02-03 11:00:00	SPY	ETF	451.97	452.97	450.17	450.21	7710110.0
2022-02-03 12:00:00	SPY	ETF	450.21	450.63	449.15	449.91	8249758.0
2022-02-03 13:00:00	SPY	ETF	449.9199	450.7049	449.04	449.9728	6350900.0
2022-02-03 14:00:00	SPY	ETF	449.97	450.59	447.7	448.27	8932395.0
2022-02-03 15:00:00	SPY	ETF	448.265	449.37	445.71	446.65	25135324.0
2022-02-03 16:00:00	SPY	ETF	446.68	452.0	446.4033	451.65	5669371.0
2022-02-03 17:00:00	SPY	ETF	451.83	452.0	446.6	451.2	294932.0
2022-02-03 18:00:00	SPY	ETF	451.24	451.89	446.6	451.39	259370.0
2022-02-03 19:00:00	SPY	ETF	451.45	451.85	451.07	451.29	68890.0
2022-02-03 04:00:00	QQQ	ETF	361.06	362.08	360.0	360.62	99290.0
2022-02-03 05:00:00	QQQ	ETF	360.62	361.01	360.3	360.37	57071.0
2022-02-03 06:00:00	QQQ	ETF	360.56	360.99	359.66	360.76	267713.0
2022-02-03 07:00:00	QQQ	ETF	360.83	361.55	359.85	361.02	553520.0
2022-02-03 08:00:00	QQQ	ETF	360.6401	368.766	358.3	358.5	932658.0
2022-02-03 09:00:00	QQQ	ETF	358.39	360.86	357.87	358.7	10875771.0
2022-02-03 10:00:00	QQQ	ETF	358.7	361.93	357.99	359.62	10552908.0
2022-02-03 11:00:00	QQQ	ETF	359.62	361.0	357.6	357.66	7070828.0
2022-02-03 12:00:00	QQQ	ETF	357.67	358.3	356.74	357.67	6791891.0
2022-02-03 13:00:00	QQQ	ETF	357.68	358.73	356.87	357.4439	4512395.0
2022-02-03 14:00:00	QQQ	ETF	357.42	358.36	355.16	355.77	6238850.0
2022-02-03 15:00:00	QQQ	ETF	355.77	356.98	352.46	353.6	14444957.0
2022-02-03 16:00:00	QQQ	ETF	353.6	361.19	353.0	361.0	6584839.0
2022-02-03 17:00:00	QQQ	ETF	361.0	361.28	353.55	359.54	741432.0
2022-02-03 18:00:00	QQQ	ETF	359.54	360.51	359.4	359.87	465960.0
2022-02-03 19:00:00	QQQ	ETF	360.03	360.44	359.58	360.04	216079.0
2022-02-03 04:00:00	IWM	ETF	200.03	200.12	199.25	199.25	9619.0
2022-02-03 05:00:00	IWM	ETF	199.35	199.8	199.29	199.4	4777.0
2022-02-03 06:00:00	IWM	ETF	199.43	199.89	199.4	199.89	32487.0
2022-02-03 07:00:00	IWM	ETF	199.79	200.65	199.58	200.58	100747.0
2022-02-03 08:00:00	IWM	ETF	200.5	200.55	198.78	198.78	190727.0
2022-02-03 09:00:00	IWM	ETF	198.84	200.61	198.46	199.02	5339963.0
2022-02-03 10:00:00	IWM	ETF	199.03	201.24	198.65	200.53	4480889.0
2022-02-03 11:00:00	IWM	ETF	200.52	200.705	198.64	198.65	3998649.0
2022-02-03 12:00:00	IWM	ETF	198.64	199.04	198.27	198.67	3229602.0
2022-02-03 13:00:00	IWM	ETF	198.67	199.34	197.93	198.81	2498911.0
2022-02-03 14:00:00	IWM	ETF	198.8	199.2	197.54	197.94	2834562.0
2022-02-03 15:00:00	IWM	ETF	197.94	198.63	197.05	197.46	5080687.0
2022-02-03 16:00:00	IWM	ETF	197.47	198.91	197.39	198.64	1587192.0
2022-02-03 17:00:00	IWM	ETF	199.1	200.0	197.53	198.89	313932.0
2022-02-03 18:00:00	IWM	ETF	198.72	199.17	197.53	198.75	84407.0
2022-02-03 19:00:00	IWM	ETF	198.85	199.15	198.7	198.89	24142.0
2022-02-03 04:00:00	DIA	ETF	355.65	355.68	355.14	355.14	17351.0
2022-02-03 05:00:00	DIA	ETF	355.15	355.15	354.64	354.68	9200.0

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

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