PREVIEW / etf_1hour / 2023-11-10

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-11-10.parquet
  size:    497 KB
  rows:    18,093

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-10 04:00:00	SPY	ETF	434.51	434.51	433.66	434.34	42740.0
2023-11-10 05:00:00	SPY	ETF	434.17	434.2	433.52	433.76	24843.0
2023-11-10 06:00:00	SPY	ETF	433.68	433.84	433.31	433.82	45645.0
2023-11-10 07:00:00	SPY	ETF	433.84	434.94	433.66	434.89	217089.0
2023-11-10 08:00:00	SPY	ETF	434.75	435.9	433.67	435.79	612368.0
2023-11-10 09:00:00	SPY	ETF	435.78	436.24	434.88	435.83	6633750.0
2023-11-10 10:00:00	SPY	ETF	435.8	435.82	434.43	435.3895	8746073.0
2023-11-10 11:00:00	SPY	ETF	435.38	436.9	435.355	436.76	6919327.0
2023-11-10 12:00:00	SPY	ETF	436.77	439.03	436.71	438.785	8595729.0
2023-11-10 13:00:00	SPY	ETF	438.79	439.77	438.21	439.5299	7671078.0
2023-11-10 14:00:00	SPY	ETF	439.53	439.96	439.415	439.6599	5947554.0
2023-11-10 15:00:00	SPY	ETF	439.66	440.93	439.6119	440.6	18180095.0
2023-11-10 16:00:00	SPY	ETF	440.6	441.09	434.5004	440.0	4352971.0
2023-11-10 17:00:00	SPY	ETF	440.0	440.15	439.75	439.8	238202.0
2023-11-10 18:00:00	SPY	ETF	439.8	440.19	439.75	439.9601	82014.0
2023-11-10 19:00:00	SPY	ETF	439.96	440.2	439.85	440.2	34907.0
2023-11-10 04:00:00	QQQ	ETF	369.95	370.0	368.98	369.76	74498.0
2023-11-10 05:00:00	QQQ	ETF	369.73	369.73	369.21	369.61	39197.0
2023-11-10 06:00:00	QQQ	ETF	369.5	369.5	368.97	369.43	47324.0
2023-11-10 07:00:00	QQQ	ETF	369.47	370.735	369.29	370.6	224079.0
2023-11-10 08:00:00	QQQ	ETF	369.4603	371.65	369.14	371.61	538500.0
2023-11-10 09:00:00	QQQ	ETF	371.58	373.29	371.28	373.03	5679989.0
2023-11-10 10:00:00	QQQ	ETF	373.02	373.08	371.69	372.93	6443523.0
2023-11-10 11:00:00	QQQ	ETF	372.93	374.81	372.89	374.79	5147659.0
2023-11-10 12:00:00	QQQ	ETF	374.785	376.91	374.6699	376.54	5356519.0
2023-11-10 13:00:00	QQQ	ETF	376.54	377.64	376.04	377.4003	5228710.0
2023-11-10 14:00:00	QQQ	ETF	377.41	377.93	377.26	377.66	3598291.0
2023-11-10 15:00:00	QQQ	ETF	377.67	378.54	377.59	378.37	9567751.0
2023-11-10 16:00:00	QQQ	ETF	378.37	378.749	377.91	378.01	2514129.0
2023-11-10 17:00:00	QQQ	ETF	378.02	378.1	377.7	377.84	126285.0
2023-11-10 18:00:00	QQQ	ETF	377.81	377.98	377.77	377.8624	15703.0
2023-11-10 19:00:00	QQQ	ETF	377.93	378.09	377.81	378.08	34319.0
2023-11-10 04:00:00	IWM	ETF	167.9	167.9	167.59	167.8	15408.0
2023-11-10 05:00:00	IWM	ETF	167.78	167.78	167.31	167.33	9339.0
2023-11-10 06:00:00	IWM	ETF	167.24	167.34	167.07	167.34	11027.0
2023-11-10 07:00:00	IWM	ETF	167.35	167.96	167.28	167.89	114369.0
2023-11-10 08:00:00	IWM	ETF	167.2706	168.16	167.2196	168.01	251848.0
2023-11-10 09:00:00	IWM	ETF	168.01	168.57	167.25	168.14	4198478.0
2023-11-10 10:00:00	IWM	ETF	168.12	168.13	166.7901	167.04	4182825.0
2023-11-10 11:00:00	IWM	ETF	167.03	167.76	167.0	167.51	2638592.0
2023-11-10 12:00:00	IWM	ETF	167.505	168.72	167.48	168.585	2647224.0
2023-11-10 13:00:00	IWM	ETF	168.58	169.295	168.431	169.0899	3280126.0
2023-11-10 14:00:00	IWM	ETF	169.09	169.71	169.09	169.36	2995681.0
2023-11-10 15:00:00	IWM	ETF	169.36	169.46	169.01	169.13	6319564.0
2023-11-10 16:00:00	IWM	ETF	169.11	169.2941	168.69	168.76	2222650.0
2023-11-10 17:00:00	IWM	ETF	168.75	169.0	168.42	168.71	158839.0
2023-11-10 18:00:00	IWM	ETF	168.68	168.88	168.61	168.83	18556.0
2023-11-10 19:00:00	IWM	ETF	168.82	168.82	168.62	168.62	6564.0
2023-11-10 04:00:00	DIA	ETF	339.44	339.86	339.44	339.86	725.0
2023-11-10 05:00:00	DIA	ETF	339.5	339.7	339.46	339.46	850.0

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

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