PREVIEW / etf_1hour / 2023-09-19

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-09-19.parquet
  size:    468 KB
  rows:    17,048

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-09-19 04:00:00	SPY	ETF	444.06	444.36	444.05	444.3	8012.0
2023-09-19 05:00:00	SPY	ETF	444.21	444.5	444.05	444.39	15864.0
2023-09-19 06:00:00	SPY	ETF	444.33	444.56	444.2	444.25	25931.0
2023-09-19 07:00:00	SPY	ETF	444.24	444.36	443.96	444.13	145826.0
2023-09-19 08:00:00	SPY	ETF	444.21	444.41	443.24	443.27	384545.0
2023-09-19 09:00:00	SPY	ETF	443.23	443.34	442.15	442.19	4896746.0
2023-09-19 10:00:00	SPY	ETF	442.19	442.235	440.51	440.58	8836441.0
2023-09-19 11:00:00	SPY	ETF	440.58	441.04	440.44	440.86	5221260.0
2023-09-19 12:00:00	SPY	ETF	440.85	440.86	439.94	440.61	4735658.0
2023-09-19 13:00:00	SPY	ETF	440.61	442.27	440.5	442.15	5831144.0
2023-09-19 14:00:00	SPY	ETF	442.15	443.29	441.97	442.1	7131786.0
2023-09-19 15:00:00	SPY	ETF	442.095	443.18	441.88	442.75	9746086.0
2023-09-19 16:00:00	SPY	ETF	442.74	443.04	441.0099	442.81	2179359.0
2023-09-19 17:00:00	SPY	ETF	442.88	442.88	442.75	442.79	17895.0
2023-09-19 18:00:00	SPY	ETF	442.78	442.91	442.75	442.8	34757.0
2023-09-19 19:00:00	SPY	ETF	442.75	442.9	442.73	442.89	11801.0
2023-09-19 04:00:00	QQQ	ETF	370.75	371.25	370.75	371.16	17962.0
2023-09-19 05:00:00	QQQ	ETF	371.12	371.36	370.9	371.26	11450.0
2023-09-19 06:00:00	QQQ	ETF	371.2	371.39	371.09	371.09	16986.0
2023-09-19 07:00:00	QQQ	ETF	371.06	371.44	370.82	371.06	53569.0
2023-09-19 08:00:00	QQQ	ETF	371.06	371.41	369.99	370.0201	232163.0
2023-09-19 09:00:00	QQQ	ETF	370.02	370.11	368.09	368.1099	4511585.0
2023-09-19 10:00:00	QQQ	ETF	368.12	368.43	366.8	366.93	6005533.0
2023-09-19 11:00:00	QQQ	ETF	366.92	367.929	366.85	367.8366	2932157.0
2023-09-19 12:00:00	QQQ	ETF	367.8467	368.18	367.05	368.095	2022136.0
2023-09-19 13:00:00	QQQ	ETF	368.12	369.93	367.99	369.77	3927318.0
2023-09-19 14:00:00	QQQ	ETF	369.78	370.63	369.19	369.19	3574784.0
2023-09-19 15:00:00	QQQ	ETF	369.185	370.185	368.932	369.87	4689544.0
2023-09-19 16:00:00	QQQ	ETF	369.87	370.14	369.85	370.0	963068.0
2023-09-19 17:00:00	QQQ	ETF	369.98	370.0	369.93	369.94	13362.0
2023-09-19 18:00:00	QQQ	ETF	369.93	370.09	369.8721	369.91	18640.0
2023-09-19 19:00:00	QQQ	ETF	369.92	370.05	369.85	370.03	33069.0
2023-09-19 04:00:00	IWM	ETF	182.74	182.78	182.7	182.76	9124.0
2023-09-19 05:00:00	IWM	ETF	182.71	183.01	182.7	182.95	3323.0
2023-09-19 06:00:00	IWM	ETF	182.98	183.08	182.88	182.88	6514.0
2023-09-19 07:00:00	IWM	ETF	182.91	182.93	182.7	182.83	26632.0
2023-09-19 08:00:00	IWM	ETF	182.86	183.0596	182.18	182.48	88690.0
2023-09-19 09:00:00	IWM	ETF	182.46	183.3	181.845	181.99	3133931.0
2023-09-19 10:00:00	IWM	ETF	181.99	182.11	181.66	181.705	2853361.0
2023-09-19 11:00:00	IWM	ETF	181.7	181.83	181.4	181.78	2202766.0
2023-09-19 12:00:00	IWM	ETF	181.775	181.78	181.07	181.32	1476537.0
2023-09-19 13:00:00	IWM	ETF	181.339	181.91	181.29	181.785	1595154.0
2023-09-19 14:00:00	IWM	ETF	181.79	182.14	181.65	181.7	1990081.0
2023-09-19 15:00:00	IWM	ETF	181.69	182.045	181.625	181.68	3559942.0
2023-09-19 16:00:00	IWM	ETF	181.68	182.3131	181.5667	181.81	1504100.0
2023-09-19 17:00:00	IWM	ETF	181.76	181.86	181.76	181.82	40831.0
2023-09-19 18:00:00	IWM	ETF	181.79	181.85	181.75	181.81	4590.0
2023-09-19 19:00:00	IWM	ETF	181.81	181.87	181.79	181.8	22828.0
2023-09-19 04:00:00	DIA	ETF	346.5	346.55	346.5	346.55	223.0
2023-09-19 07:00:00	DIA	ETF	346.46	346.46	346.46	346.46	400.0

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

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