PREVIEW / etf_1hour / 2022-08-12

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-08-12.parquet
  size:    450 KB
  rows:    15,990

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-12 04:00:00	SPY	ETF	422.0	422.64	422.0	422.03	33543.0
2022-08-12 05:00:00	SPY	ETF	422.12	422.45	421.96	422.33	21152.0
2022-08-12 06:00:00	SPY	ETF	422.2	422.2	421.42	421.6	51709.0
2022-08-12 07:00:00	SPY	ETF	421.51	421.61	420.96	421.43	265516.0
2022-08-12 08:00:00	SPY	ETF	421.46	422.5304	420.71	422.05	276035.0
2022-08-12 09:00:00	SPY	ETF	422.11	422.89	421.4585	422.6	3915374.0
2022-08-12 10:00:00	SPY	ETF	422.58	422.91	421.03	422.449	6571306.0
2022-08-12 11:00:00	SPY	ETF	422.45	423.83	422.32	423.42	4543311.0
2022-08-12 12:00:00	SPY	ETF	423.42	424.34	423.38	424.18	3343024.0
2022-08-12 13:00:00	SPY	ETF	424.18	425.03	424.0601	424.81	2970567.0
2022-08-12 14:00:00	SPY	ETF	424.82	425.81	424.7	425.72	4046416.0
2022-08-12 15:00:00	SPY	ETF	425.715	427.21	425.59	427.06	15156804.0
2022-08-12 16:00:00	SPY	ETF	427.06	427.1511	426.68	427.03	3742584.0
2022-08-12 17:00:00	SPY	ETF	427.03	427.15	426.76	426.8	95680.0
2022-08-12 18:00:00	SPY	ETF	426.92	426.99	426.73	426.95	12709.0
2022-08-12 19:00:00	SPY	ETF	426.99	427.19	426.9	427.19	20682.0
2022-08-12 04:00:00	QQQ	ETF	325.42	326.28	325.42	325.69	42601.0
2022-08-12 05:00:00	QQQ	ETF	325.8	326.28	325.62	325.99	45255.0
2022-08-12 06:00:00	QQQ	ETF	325.96	325.96	325.35	325.36	55986.0
2022-08-12 07:00:00	QQQ	ETF	325.34	325.65	324.77	325.22	209111.0
2022-08-12 08:00:00	QQQ	ETF	325.12	326.0204	324.323	325.92	301099.0
2022-08-12 09:00:00	QQQ	ETF	325.92	326.96	325.1001	326.7009	4305437.0
2022-08-12 10:00:00	QQQ	ETF	326.69	327.6	325.2356	326.8701	5322684.0
2022-08-12 11:00:00	QQQ	ETF	326.88	328.25	326.73	327.46	3417155.0
2022-08-12 12:00:00	QQQ	ETF	327.47	328.5	327.4	328.055	2189524.0
2022-08-12 13:00:00	QQQ	ETF	328.0501	328.82	327.92	328.63	1690446.0
2022-08-12 14:00:00	QQQ	ETF	328.63	329.58	328.59	329.58	2221606.0
2022-08-12 15:00:00	QQQ	ETF	329.5695	330.585	329.385	330.54	7985933.0
2022-08-12 16:00:00	QQQ	ETF	330.54	330.54	330.12	330.53	2157922.0
2022-08-12 17:00:00	QQQ	ETF	330.54	330.54	330.3	330.3	148561.0
2022-08-12 18:00:00	QQQ	ETF	330.31	330.49	330.3	330.32	18877.0
2022-08-12 19:00:00	QQQ	ETF	330.4	330.78	330.29	330.7	20147.0
2022-08-12 04:00:00	IWM	ETF	197.73	198.0	197.57	197.57	30072.0
2022-08-12 05:00:00	IWM	ETF	197.65	197.85	197.58	197.77	4794.0
2022-08-12 06:00:00	IWM	ETF	197.45	197.45	197.16	197.3	6957.0
2022-08-12 07:00:00	IWM	ETF	197.26	197.28	196.95	197.21	34787.0
2022-08-12 08:00:00	IWM	ETF	197.19	197.75	197.0	197.32	130827.0
2022-08-12 09:00:00	IWM	ETF	197.32	197.91	196.58	197.84	2170570.0
2022-08-12 10:00:00	IWM	ETF	197.77	198.2	196.98	198.07	2681265.0
2022-08-12 11:00:00	IWM	ETF	198.08	199.35	198.01	198.88	2582234.0
2022-08-12 12:00:00	IWM	ETF	198.89	199.62	198.82	199.31	1353603.0
2022-08-12 13:00:00	IWM	ETF	199.3	199.68	199.27	199.57	1181804.0
2022-08-12 14:00:00	IWM	ETF	199.58	200.14	199.5725	200.105	1248122.0
2022-08-12 15:00:00	IWM	ETF	200.11	200.43	200.01	200.36	3372162.0
2022-08-12 16:00:00	IWM	ETF	200.36	200.36	197.8161	200.3	922054.0
2022-08-12 17:00:00	IWM	ETF	200.25	200.4	200.15	200.32	386899.0
2022-08-12 18:00:00	IWM	ETF	200.32	200.4	200.29	200.4	12753.0
2022-08-12 19:00:00	IWM	ETF	200.4	200.49	200.3	200.49	17474.0
2022-08-12 04:00:00	DIA	ETF	335.24	335.26	335.24	335.26	200.0
2022-08-12 06:00:00	DIA	ETF	335.27	335.27	334.8	334.8	400.0

> showing 50 of 15,990 rows — these rows as CSV

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