PREVIEW / etf_1hour / 2023-04-25

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-04-25.parquet
  size:    471 KB
  rows:    17,229

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-04-25 04:00:00	SPY	ETF	410.67	411.18	409.86	410.5	46001.0
2023-04-25 05:00:00	SPY	ETF	410.5	410.68	410.3	410.65	35504.0
2023-04-25 06:00:00	SPY	ETF	410.7	410.84	410.39	410.73	227870.0
2023-04-25 07:00:00	SPY	ETF	410.81	411.11	410.42	410.8	254986.0
2023-04-25 08:00:00	SPY	ETF	410.89	411.9	410.3496	410.79	570970.0
2023-04-25 09:00:00	SPY	ETF	410.77	412.27	410.04	410.28	6250917.0
2023-04-25 10:00:00	SPY	ETF	410.27	410.79	409.13	409.83	9705830.0
2023-04-25 11:00:00	SPY	ETF	409.84	410.41	408.95	409.0399	6761430.0
2023-04-25 12:00:00	SPY	ETF	409.03	409.29	408.43	408.65	5559047.0
2023-04-25 13:00:00	SPY	ETF	408.65	408.91	406.825	406.975	8783588.0
2023-04-25 14:00:00	SPY	ETF	406.9726	407.4	406.575	406.6482	8690875.0
2023-04-25 15:00:00	SPY	ETF	406.63	407.43	406.02	406.12	16349308.0
2023-04-25 16:00:00	SPY	ETF	406.12	408.4884	405.96	407.7	5728464.0
2023-04-25 17:00:00	SPY	ETF	407.8	408.04	407.64	407.95	102259.0
2023-04-25 18:00:00	SPY	ETF	407.95	408.38	407.68	407.89	150282.0
2023-04-25 19:00:00	SPY	ETF	407.87	408.0	407.64	407.9	93926.0
2023-04-25 04:00:00	QQQ	ETF	314.92	315.14	313.78	314.5	95114.0
2023-04-25 05:00:00	QQQ	ETF	314.45	314.62	314.25	314.6	22014.0
2023-04-25 06:00:00	QQQ	ETF	314.66	314.87	314.35	314.68	72982.0
2023-04-25 07:00:00	QQQ	ETF	314.71	315.0	314.48	314.67	200883.0
2023-04-25 08:00:00	QQQ	ETF	314.75	316.186	313.8904	314.57	237559.0
2023-04-25 09:00:00	QQQ	ETF	314.56	314.97	313.78	314.1092	4170005.0
2023-04-25 10:00:00	QQQ	ETF	314.08	314.63	312.9	313.41	6631154.0
2023-04-25 11:00:00	QQQ	ETF	313.42	313.97	312.6	312.6601	4163541.0
2023-04-25 12:00:00	QQQ	ETF	312.67	312.77	311.8813	312.33	4028932.0
2023-04-25 13:00:00	QQQ	ETF	312.34	312.7899	311.07	311.235	5372699.0
2023-04-25 14:00:00	QQQ	ETF	311.225	311.48	310.52	310.79	5110561.0
2023-04-25 15:00:00	QQQ	ETF	310.78	311.32	309.89	309.94	9319645.0
2023-04-25 16:00:00	QQQ	ETF	309.96	313.16	309.8	312.63	5125973.0
2023-04-25 17:00:00	QQQ	ETF	312.7	313.34	312.62	313.34	304221.0
2023-04-25 18:00:00	QQQ	ETF	313.2	314.37	312.78	313.75	850104.0
2023-04-25 19:00:00	QQQ	ETF	313.75	313.8	313.48	313.63	283329.0
2023-04-25 04:00:00	IWM	ETF	175.19	175.21	174.58	175.21	18299.0
2023-04-25 05:00:00	IWM	ETF	175.24	175.4	175.02	175.39	5750.0
2023-04-25 06:00:00	IWM	ETF	175.46	175.55	175.27	175.55	10028.0
2023-04-25 07:00:00	IWM	ETF	175.62	175.75	175.35	175.71	48276.0
2023-04-25 08:00:00	IWM	ETF	175.67	176.93	174.8396	175.78	112053.0
2023-04-25 09:00:00	IWM	ETF	175.79	175.94	174.84	175.3302	3297385.0
2023-04-25 10:00:00	IWM	ETF	175.33	175.78	174.405	175.06	3275272.0
2023-04-25 11:00:00	IWM	ETF	175.055	175.42	174.535	174.55	1645625.0
2023-04-25 12:00:00	IWM	ETF	174.55	174.805	174.15	174.18	1998115.0
2023-04-25 13:00:00	IWM	ETF	174.1799	174.36	173.16	173.39	3168466.0
2023-04-25 14:00:00	IWM	ETF	173.39	173.79	173.21	173.32	2402047.0
2023-04-25 15:00:00	IWM	ETF	173.32	173.7	173.01	173.07	4195414.0
2023-04-25 16:00:00	IWM	ETF	173.06	173.13	172.37	172.99	1620745.0
2023-04-25 17:00:00	IWM	ETF	172.97	173.37	172.97	173.35	25319.0
2023-04-25 18:00:00	IWM	ETF	173.2	173.28	172.4	172.41	104731.0
2023-04-25 19:00:00	IWM	ETF	172.39	172.64	172.29	172.58	129491.0
2023-04-25 04:00:00	DIA	ETF	337.37	337.64	337.01	337.64	800.0
2023-04-25 05:00:00	DIA	ETF	337.26	337.26	337.2	337.2	200.0

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

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