PREVIEW / etf_1hour / 2023-11-08

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-11-08.parquet
  size:    495 KB
  rows:    18,202

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-11-08 04:00:00	SPY	ETF	436.64	436.82	436.39	436.68	17853.0
2023-11-08 05:00:00	SPY	ETF	436.71	436.84	436.48	436.8	7056.0
2023-11-08 06:00:00	SPY	ETF	436.81	437.2	436.81	437.02	17701.0
2023-11-08 07:00:00	SPY	ETF	437.01	437.2	436.78	437.2	52683.0
2023-11-08 08:00:00	SPY	ETF	436.9	437.44	436.22	437.22	162543.0
2023-11-08 09:00:00	SPY	ETF	437.28	438.09	437.25	437.71	5357224.0
2023-11-08 10:00:00	SPY	ETF	437.71	437.82	436.51	436.585	7511502.0
2023-11-08 11:00:00	SPY	ETF	436.595	437.17	436.03	436.09	5878804.0
2023-11-08 12:00:00	SPY	ETF	436.09	436.1467	434.87	435.8188	5903399.0
2023-11-08 13:00:00	SPY	ETF	435.83	436.7	435.61	436.565	5679571.0
2023-11-08 14:00:00	SPY	ETF	436.555	437.2	436.44	436.51	4491796.0
2023-11-08 15:00:00	SPY	ETF	436.52	437.8	436.49	437.2	11309604.0
2023-11-08 16:00:00	SPY	ETF	437.2	437.25	436.72	436.72	3110123.0
2023-11-08 17:00:00	SPY	ETF	436.72	436.85	436.68	436.68	57740.0
2023-11-08 18:00:00	SPY	ETF	436.63	436.63	436.37	436.62	115987.0
2023-11-08 19:00:00	SPY	ETF	436.65	436.74	436.52	436.63	32842.0
2023-11-08 04:00:00	QQQ	ETF	372.3	372.54	372.0	372.39	32351.0
2023-11-08 05:00:00	QQQ	ETF	372.33	372.59	372.16	372.5	20863.0
2023-11-08 06:00:00	QQQ	ETF	372.57	372.79	372.41	372.57	55770.0
2023-11-08 07:00:00	QQQ	ETF	372.6	372.82	372.33	372.82	78983.0
2023-11-08 08:00:00	QQQ	ETF	372.4703	373.09	371.85	372.73	193966.0
2023-11-08 09:00:00	QQQ	ETF	372.72	373.79	372.68	373.0993	4702618.0
2023-11-08 10:00:00	QQQ	ETF	373.11	373.2306	371.78	371.98	4928906.0
2023-11-08 11:00:00	QQQ	ETF	371.975	372.61	371.68	371.84	4026718.0
2023-11-08 12:00:00	QQQ	ETF	371.85	371.91	370.62	371.6302	3124204.0
2023-11-08 13:00:00	QQQ	ETF	371.6	372.56	371.4001	372.36	3308074.0
2023-11-08 14:00:00	QQQ	ETF	372.355	373.045	372.17	372.2596	2652066.0
2023-11-08 15:00:00	QQQ	ETF	372.26	373.22	372.24	372.97	4520297.0
2023-11-08 16:00:00	QQQ	ETF	372.98	372.98	372.4	372.4	571784.0
2023-11-08 17:00:00	QQQ	ETF	372.4	372.55	372.37	372.4	49220.0
2023-11-08 18:00:00	QQQ	ETF	372.36	372.36	372.0546	372.35	105042.0
2023-11-08 19:00:00	QQQ	ETF	372.36	372.5	372.25	372.3	36621.0
2023-11-08 04:00:00	IWM	ETF	171.54	171.55	171.45	171.46	7109.0
2023-11-08 05:00:00	IWM	ETF	171.41	171.48	171.25	171.48	10800.0
2023-11-08 06:00:00	IWM	ETF	171.5	171.9	171.5	171.74	32297.0
2023-11-08 07:00:00	IWM	ETF	171.68	171.79	171.5	171.74	125091.0
2023-11-08 08:00:00	IWM	ETF	171.7588	171.91	171.2896	171.85	137263.0
2023-11-08 09:00:00	IWM	ETF	171.86	172.18	170.76	171.67	4811426.0
2023-11-08 10:00:00	IWM	ETF	171.67	171.68	169.7939	169.82	5621685.0
2023-11-08 11:00:00	IWM	ETF	169.815	170.265	169.5118	169.93	5552515.0
2023-11-08 12:00:00	IWM	ETF	169.925	169.97	169.3024	169.59	3091990.0
2023-11-08 13:00:00	IWM	ETF	169.58	170.075	169.475	169.93	2758268.0
2023-11-08 14:00:00	IWM	ETF	169.93	170.175	169.83	169.88	2031891.0
2023-11-08 15:00:00	IWM	ETF	169.88	170.05	169.495	169.88	6677278.0
2023-11-08 16:00:00	IWM	ETF	169.88	169.91	169.64	169.67	4353987.0
2023-11-08 17:00:00	IWM	ETF	169.81	169.87	169.67	169.76	61704.0
2023-11-08 18:00:00	IWM	ETF	169.73	169.73	169.53	169.72	38328.0
2023-11-08 19:00:00	IWM	ETF	169.74	169.78	169.64	169.7094	20097.0
2023-11-08 04:00:00	DIA	ETF	341.65	341.66	341.61	341.61	671.0
2023-11-08 05:00:00	DIA	ETF	341.4	341.61	341.4	341.61	1250.0

> showing 50 of 18,202 rows — these rows as CSV

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