PREVIEW / etf_1hour / 2023-04-12

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-04-12.parquet
  size:    472 KB
  rows:    17,322

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-12 04:00:00	SPY	ETF	409.91	410.48	409.9	410.07	19060.0
2023-04-12 05:00:00	SPY	ETF	409.97	410.5	409.92	410.43	12620.0
2023-04-12 06:00:00	SPY	ETF	410.48	410.67	410.26	410.26	20428.0
2023-04-12 07:00:00	SPY	ETF	410.29	410.63	410.12	410.61	155041.0
2023-04-12 08:00:00	SPY	ETF	410.61	413.75	409.52	412.11	2595026.0
2023-04-12 09:00:00	SPY	ETF	412.12	412.43	410.14	410.75	8082057.0
2023-04-12 10:00:00	SPY	ETF	410.74	411.85	409.09	409.174	10730906.0
2023-04-12 11:00:00	SPY	ETF	409.18	410.47	408.23	410.34	8076066.0
2023-04-12 12:00:00	SPY	ETF	410.34	410.97	410.24	410.86	4783528.0
2023-04-12 13:00:00	SPY	ETF	410.87	411.48	410.46	410.8799	4899081.0
2023-04-12 14:00:00	SPY	ETF	410.879	411.48	408.52	409.0211	9593785.0
2023-04-12 15:00:00	SPY	ETF	409.03	409.42	407.44	408.07	16870837.0
2023-04-12 16:00:00	SPY	ETF	408.075	408.21	407.7	407.77	4247881.0
2023-04-12 17:00:00	SPY	ETF	407.86	408.05	407.6	407.79	280936.0
2023-04-12 18:00:00	SPY	ETF	407.79	407.82	407.22	407.32	95943.0
2023-04-12 19:00:00	SPY	ETF	407.34	407.56	407.15	407.2	55036.0
2023-04-12 04:00:00	QQQ	ETF	315.58	316.19	315.58	315.81	20083.0
2023-04-12 05:00:00	QQQ	ETF	315.85	316.25	315.64	316.19	26893.0
2023-04-12 06:00:00	QQQ	ETF	316.28	316.44	315.71	315.71	20293.0
2023-04-12 07:00:00	QQQ	ETF	315.75	316.3	315.58	316.24	96073.0
2023-04-12 08:00:00	QQQ	ETF	316.24	319.85	315.32	318.22	3003559.0
2023-04-12 09:00:00	QQQ	ETF	318.27	318.62	314.86	315.63	8119721.0
2023-04-12 10:00:00	QQQ	ETF	315.63	317.17	314.23	314.3	8201078.0
2023-04-12 11:00:00	QQQ	ETF	314.295	315.94	313.5	315.78	5081627.0
2023-04-12 12:00:00	QQQ	ETF	315.79	316.25	315.58	316.1	3200288.0
2023-04-12 13:00:00	QQQ	ETF	316.11	316.67	315.42	315.7	3414534.0
2023-04-12 14:00:00	QQQ	ETF	315.7	316.23	313.65	314.1	6376147.0
2023-04-12 15:00:00	QQQ	ETF	314.1	314.475	312.565	313.04	7602095.0
2023-04-12 16:00:00	QQQ	ETF	313.04	313.15	312.89	313.04	2667212.0
2023-04-12 17:00:00	QQQ	ETF	313.0	313.04	312.75	312.9	44577.0
2023-04-12 18:00:00	QQQ	ETF	312.97	313.0	312.39	312.54	59458.0
2023-04-12 19:00:00	QQQ	ETF	312.53	312.8	312.3	312.4	39022.0
2023-04-12 04:00:00	IWM	ETF	177.26	177.66	177.26	177.33	4849.0
2023-04-12 05:00:00	IWM	ETF	177.39	177.5	177.31	177.5	1511.0
2023-04-12 06:00:00	IWM	ETF	177.51	177.76	177.51	177.6	57318.0
2023-04-12 07:00:00	IWM	ETF	177.6	177.71	177.48	177.69	156617.0
2023-04-12 08:00:00	IWM	ETF	177.6	179.42	177.14	179.07	818494.0
2023-04-12 09:00:00	IWM	ETF	179.04	179.22	177.5003	177.55	3575978.0
2023-04-12 10:00:00	IWM	ETF	177.54	178.14	176.59	176.68	3158911.0
2023-04-12 11:00:00	IWM	ETF	176.69	177.25	176.09	177.21	2312905.0
2023-04-12 12:00:00	IWM	ETF	177.25	177.46	176.95	177.15	1124744.0
2023-04-12 13:00:00	IWM	ETF	177.15	177.71	176.99	177.23	1402098.0
2023-04-12 14:00:00	IWM	ETF	177.222	177.59	176.17	176.415	2888445.0
2023-04-12 15:00:00	IWM	ETF	176.415	176.58	175.58	175.85	4665690.0
2023-04-12 16:00:00	IWM	ETF	175.84	175.89	175.59	175.61	1520554.0
2023-04-12 17:00:00	IWM	ETF	175.6	175.69	175.5	175.67	5274.0
2023-04-12 18:00:00	IWM	ETF	175.67	175.73	175.4	175.47	15934.0
2023-04-12 19:00:00	IWM	ETF	175.48	175.57	175.4	175.4	12914.0
2023-04-12 04:00:00	DIA	ETF	337.34	337.5	337.34	337.44	2443.0
2023-04-12 07:00:00	DIA	ETF	337.689	337.75	337.689	337.75	10300.0

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

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