PREVIEW / etf_1hour / 2023-11-13

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-11-13.parquet
  size:    494 KB
  rows:    18,097

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-13 04:00:00	SPY	ETF	439.4	439.91	439.4	439.91	15816.0
2023-11-13 05:00:00	SPY	ETF	439.82	440.14	439.54	440.13	25443.0
2023-11-13 06:00:00	SPY	ETF	440.15	440.15	439.69	440.01	22464.0
2023-11-13 07:00:00	SPY	ETF	440.01	440.09	439.63	439.86	83179.0
2023-11-13 08:00:00	SPY	ETF	439.93	440.23	438.6	439.27	343840.0
2023-11-13 09:00:00	SPY	ETF	439.3	439.59	438.42	438.865	5635005.0
2023-11-13 10:00:00	SPY	ETF	438.86	439.945	438.55	439.72	7307782.0
2023-11-13 11:00:00	SPY	ETF	439.72	441.33	439.54	440.99	6228336.0
2023-11-13 12:00:00	SPY	ETF	441.01	441.15	440.19	440.5495	3706423.0
2023-11-13 13:00:00	SPY	ETF	440.54	441.03	439.9	440.5299	3766132.0
2023-11-13 14:00:00	SPY	ETF	440.5216	441.12	440.3701	440.59	3487375.0
2023-11-13 15:00:00	SPY	ETF	440.59	440.94	440.1	440.2	6798083.0
2023-11-13 16:00:00	SPY	ETF	440.2	440.7898	440.18	440.47	1823605.0
2023-11-13 17:00:00	SPY	ETF	440.4	440.49	440.19	440.4	47959.0
2023-11-13 18:00:00	SPY	ETF	440.39	440.45	440.31	440.38	17092.0
2023-11-13 19:00:00	SPY	ETF	440.38	440.49	440.25	440.39	52625.0
2023-11-13 04:00:00	QQQ	ETF	377.14	377.42	376.92	377.31	52317.0
2023-11-13 05:00:00	QQQ	ETF	377.27	377.7	377.08	377.68	25873.0
2023-11-13 06:00:00	QQQ	ETF	377.67	377.7	377.27	377.61	25062.0
2023-11-13 07:00:00	QQQ	ETF	377.62	377.69	377.34	377.6	83818.0
2023-11-13 08:00:00	QQQ	ETF	377.7	378.673	376.43	376.97	342085.0
2023-11-13 09:00:00	QQQ	ETF	376.98	377.08	375.24	375.84	5946327.0
2023-11-13 10:00:00	QQQ	ETF	375.85	377.26	375.57	376.95	6239056.0
2023-11-13 11:00:00	QQQ	ETF	376.95	378.28	376.86	377.8095	4060942.0
2023-11-13 12:00:00	QQQ	ETF	377.81	377.96	377.06	377.51	3296500.0
2023-11-13 13:00:00	QQQ	ETF	377.5	378.08	377.01	377.53	3001081.0
2023-11-13 14:00:00	QQQ	ETF	377.53	378.25	377.32	377.815	3000211.0
2023-11-13 15:00:00	QQQ	ETF	377.81	378.1	377.11	377.26	5527673.0
2023-11-13 16:00:00	QQQ	ETF	377.25	377.51	377.19	377.46	1091035.0
2023-11-13 17:00:00	QQQ	ETF	377.45	377.64	377.43	377.54	38096.0
2023-11-13 18:00:00	QQQ	ETF	377.51	377.52	377.33	377.5	187985.0
2023-11-13 19:00:00	QQQ	ETF	377.48	377.62	377.4	377.59	63486.0
2023-11-13 04:00:00	IWM	ETF	168.69	168.85	168.68	168.8	23712.0
2023-11-13 05:00:00	IWM	ETF	168.71	168.8	168.6	168.8	8643.0
2023-11-13 06:00:00	IWM	ETF	168.76	168.76	168.57	168.68	5738.0
2023-11-13 07:00:00	IWM	ETF	168.71	168.71	168.44	168.54	40301.0
2023-11-13 08:00:00	IWM	ETF	168.5695	169.0	168.02	168.49	168196.0
2023-11-13 09:00:00	IWM	ETF	168.49	168.62	167.64	167.8	3512410.0
2023-11-13 10:00:00	IWM	ETF	167.8	168.51	167.52	168.42	3117264.0
2023-11-13 11:00:00	IWM	ETF	168.42	169.77	168.41	169.47	4458384.0
2023-11-13 12:00:00	IWM	ETF	169.48	169.55	168.96	169.25	1871498.0
2023-11-13 13:00:00	IWM	ETF	169.245	169.535	168.95	169.2	1746662.0
2023-11-13 14:00:00	IWM	ETF	169.2	169.37	169.02	169.23	1347412.0
2023-11-13 15:00:00	IWM	ETF	169.235	169.48	169.14	169.16	4236584.0
2023-11-13 16:00:00	IWM	ETF	169.17	169.3786	169.15	169.28	1117338.0
2023-11-13 17:00:00	IWM	ETF	169.25	169.32	169.19	169.25	4058.0
2023-11-13 18:00:00	IWM	ETF	169.27	169.32	169.23	169.23	13222.0
2023-11-13 19:00:00	IWM	ETF	169.24	169.25	169.14	169.19	54237.0
2023-11-13 04:00:00	DIA	ETF	342.64	343.01	342.64	343.01	740.0
2023-11-13 05:00:00	DIA	ETF	342.91	342.91	342.91	342.91	300.0

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

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