PREVIEW / etf_1hour / 2023-01-06

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-01-06.parquet
  size:    469 KB
  rows:    16,922

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
2023-01-06 04:00:00	SPY	ETF	380.0	380.0	378.99	379.48	38670.0
2023-01-06 05:00:00	SPY	ETF	379.38	379.93	379.17	379.38	21887.0
2023-01-06 06:00:00	SPY	ETF	379.38	380.04	379.3	379.66	73957.0
2023-01-06 07:00:00	SPY	ETF	379.55	379.66	379.13	379.44	235257.0
2023-01-06 08:00:00	SPY	ETF	379.43	384.04	378.43	383.73	3212830.0
2023-01-06 09:00:00	SPY	ETF	383.77	383.96	379.45	380.737	8589214.0
2023-01-06 10:00:00	SPY	ETF	380.76	385.57	380.75	385.27	13190620.0
2023-01-06 11:00:00	SPY	ETF	385.3	386.72	385.0	386.26	8592368.0
2023-01-06 12:00:00	SPY	ETF	386.26	386.51	385.06	385.46	4954754.0
2023-01-06 13:00:00	SPY	ETF	385.45	386.85	385.215	386.72	4698199.0
2023-01-06 14:00:00	SPY	ETF	386.72	388.79	386.72	388.52	9325344.0
2023-01-06 15:00:00	SPY	ETF	388.51	389.25	387.73	388.03	19241373.0
2023-01-06 16:00:00	SPY	ETF	388.03	390.0	387.58	387.78	6124487.0
2023-01-06 17:00:00	SPY	ETF	387.79	388.0	387.6	387.83	218602.0
2023-01-06 18:00:00	SPY	ETF	387.83	387.88	387.75	387.78	73255.0
2023-01-06 19:00:00	SPY	ETF	387.79	387.83	386.38	387.58	75725.0
2023-01-06 04:00:00	QQQ	ETF	262.0	262.0	260.7	261.17	54101.0
2023-01-06 05:00:00	QQQ	ETF	261.1	261.68	260.96	260.96	29936.0
2023-01-06 06:00:00	QQQ	ETF	261.0	261.42	260.77	261.03	25321.0
2023-01-06 07:00:00	QQQ	ETF	261.0	261.3	260.69	261.01	198380.0
2023-01-06 08:00:00	QQQ	ETF	261.04	265.22	260.01	264.61	2996001.0
2023-01-06 09:00:00	QQQ	ETF	264.62	264.75	260.34	261.47	6698672.0
2023-01-06 10:00:00	QQQ	ETF	261.5	265.9	261.5	265.62	8059117.0
2023-01-06 11:00:00	QQQ	ETF	265.65	267.0	265.23	266.51	5684239.0
2023-01-06 12:00:00	QQQ	ETF	266.52	266.89	265.88	266.24	2923222.0
2023-01-06 13:00:00	QQQ	ETF	266.26	267.76	266.14	267.6893	2900940.0
2023-01-06 14:00:00	QQQ	ETF	267.69	269.54	267.64	269.29	3851466.0
2023-01-06 15:00:00	QQQ	ETF	269.29	269.94	268.56	268.76	8195408.0
2023-01-06 16:00:00	QQQ	ETF	268.75	268.86	266.06	268.55	1876501.0
2023-01-06 17:00:00	QQQ	ETF	268.58	268.62	268.48	268.6	31496.0
2023-01-06 18:00:00	QQQ	ETF	268.6	268.68	268.57	268.63	34149.0
2023-01-06 19:00:00	QQQ	ETF	268.6301	268.69	267.28	268.5	37642.0
2023-01-06 04:00:00	IWM	ETF	173.9	173.94	173.53	173.85	26467.0
2023-01-06 05:00:00	IWM	ETF	173.73	174.05	173.63	173.82	8499.0
2023-01-06 06:00:00	IWM	ETF	173.82	174.1	173.7	173.84	10658.0
2023-01-06 07:00:00	IWM	ETF	173.83	173.96	173.71	173.76	18058.0
2023-01-06 08:00:00	IWM	ETF	173.87	176.2	173.41	176.11	565103.0
2023-01-06 09:00:00	IWM	ETF	176.11	176.17	173.87	174.37	2451448.0
2023-01-06 10:00:00	IWM	ETF	174.38	177.48	174.38	177.27	3021426.0
2023-01-06 11:00:00	IWM	ETF	177.315	177.885	176.84	177.64	2172444.0
2023-01-06 12:00:00	IWM	ETF	177.65	177.72	176.71	176.89	1285216.0
2023-01-06 13:00:00	IWM	ETF	176.89	177.52	176.85	177.32	1059862.0
2023-01-06 14:00:00	IWM	ETF	177.33	177.92	177.31	177.715	1755657.0
2023-01-06 15:00:00	IWM	ETF	177.71	178.04	177.38	177.6	2691331.0
2023-01-06 16:00:00	IWM	ETF	177.58	177.7	177.35	177.4296	1063199.0
2023-01-06 17:00:00	IWM	ETF	177.22	177.54	177.22	177.52	5027.0
2023-01-06 18:00:00	IWM	ETF	177.52	177.55	177.46	177.49	6099.0
2023-01-06 19:00:00	IWM	ETF	177.45	177.5	177.03	177.36	30807.0
2023-01-06 04:00:00	DIA	ETF	329.38	329.38	329.36	329.38	2500.0
2023-01-06 06:00:00	DIA	ETF	329.93	329.94	329.93	329.94	700.0

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

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