PREVIEW / etf_1hour / 2023-01-03

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-01-03.parquet
  size:    475 KB
  rows:    17,538

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-03 04:00:00	SPY	ETF	384.0	386.83	384.0	386.83	135764.0
2023-01-03 05:00:00	SPY	ETF	386.63	386.64	385.62	386.06	111257.0
2023-01-03 06:00:00	SPY	ETF	385.9	386.0	383.52	383.96	113506.0
2023-01-03 07:00:00	SPY	ETF	383.95	384.44	383.34	384.31	368618.0
2023-01-03 08:00:00	SPY	ETF	383.53	386.7204	382.77	384.69	833922.0
2023-01-03 09:00:00	SPY	ETF	384.66	386.43	381.6601	381.71	7856732.0
2023-01-03 10:00:00	SPY	ETF	381.77	382.58	380.07	382.04	7881844.0
2023-01-03 11:00:00	SPY	ETF	382.0499	382.33	378.65	379.07	7726948.0
2023-01-03 12:00:00	SPY	ETF	379.11	380.02	377.831	378.61	5064866.0
2023-01-03 13:00:00	SPY	ETF	378.63	379.99	378.34	379.83	3860740.0
2023-01-03 14:00:00	SPY	ETF	379.84	380.75	378.09	380.0399	6300646.0
2023-01-03 15:00:00	SPY	ETF	380.02	381.3	379.82	380.84	10809893.0
2023-01-03 16:00:00	SPY	ETF	380.84	380.93	380.16	380.69	2705860.0
2023-01-03 17:00:00	SPY	ETF	380.61	380.7	380.48	380.61	35501.0
2023-01-03 18:00:00	SPY	ETF	380.58	380.79	380.31	380.79	98177.0
2023-01-03 19:00:00	SPY	ETF	380.79	381.11	380.63	380.77	110350.0
2023-01-03 04:00:00	QQQ	ETF	268.8	269.79	268.0	269.79	101370.0
2023-01-03 05:00:00	QQQ	ETF	269.82	269.86	268.74	269.26	65335.0
2023-01-03 06:00:00	QQQ	ETF	269.23	269.35	267.12	267.66	174411.0
2023-01-03 07:00:00	QQQ	ETF	267.69	268.36	267.09	268.1	197731.0
2023-01-03 08:00:00	QQQ	ETF	267.775	269.5504	266.65	268.61	572540.0
2023-01-03 09:00:00	QQQ	ETF	268.58	270.155	265.59	265.6579	5944371.0
2023-01-03 10:00:00	QQQ	ETF	265.66	266.2	263.73	265.21	4826537.0
2023-01-03 11:00:00	QQQ	ETF	265.23	265.498	262.44	262.81	3945361.0
2023-01-03 12:00:00	QQQ	ETF	262.8	263.64	262.13	262.75	2880188.0
2023-01-03 13:00:00	QQQ	ETF	262.755	263.94	262.31	263.82	2190408.0
2023-01-03 14:00:00	QQQ	ETF	263.81	264.98	262.7604	264.35	3129750.0
2023-01-03 15:00:00	QQQ	ETF	264.36	265.2	264.12	264.46	4789693.0
2023-01-03 16:00:00	QQQ	ETF	264.45	264.55	263.94	264.42	1217163.0
2023-01-03 17:00:00	QQQ	ETF	264.49	264.5	264.276	264.3	29523.0
2023-01-03 18:00:00	QQQ	ETF	264.35	264.6	264.01	264.6	59826.0
2023-01-03 19:00:00	QQQ	ETF	264.58	264.91	264.57	264.64	61116.0
2023-01-03 04:00:00	IWM	ETF	175.12	176.78	175.12	176.72	23242.0
2023-01-03 05:00:00	IWM	ETF	176.74	176.74	176.29	176.5	28514.0
2023-01-03 06:00:00	IWM	ETF	176.49	176.49	175.48	175.6	48801.0
2023-01-03 07:00:00	IWM	ETF	175.56	175.88	175.25	175.8	81689.0
2023-01-03 08:00:00	IWM	ETF	175.542	176.15	174.36	176.03	126489.0
2023-01-03 09:00:00	IWM	ETF	176.0	177.32	174.6224	174.64	4287948.0
2023-01-03 10:00:00	IWM	ETF	174.66	175.225	173.61	175.18	2766119.0
2023-01-03 11:00:00	IWM	ETF	175.19	175.37	172.7	172.86	2163247.0
2023-01-03 12:00:00	IWM	ETF	172.85	173.76	172.37	172.97	1105476.0
2023-01-03 13:00:00	IWM	ETF	172.96	173.73	172.82	173.225	900535.0
2023-01-03 14:00:00	IWM	ETF	173.24	173.39	171.9	173.05	1755310.0
2023-01-03 15:00:00	IWM	ETF	173.05	173.74	172.77	173.35	2753144.0
2023-01-03 16:00:00	IWM	ETF	173.4	173.4387	173.03	173.29	872867.0
2023-01-03 17:00:00	IWM	ETF	173.14	173.23	173.08	173.23	9882.0
2023-01-03 18:00:00	IWM	ETF	173.11	173.35	173.05	173.35	12261.0
2023-01-03 19:00:00	IWM	ETF	173.35	173.48	173.23	173.32	27665.0
2023-01-03 04:00:00	DIA	ETF	333.0	334.81	333.0	334.69	2700.0
2023-01-03 05:00:00	DIA	ETF	334.77	334.77	334.23	334.23	200.0

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

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