PREVIEW / etf_1hour / 2023-04-10

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-04-10.parquet
  size:    479 KB
  rows:    17,386

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-10 04:00:00	SPY	ETF	409.07	409.2	408.95	409.2	34185.0
2023-04-10 05:00:00	SPY	ETF	409.22	409.49	409.18	409.34	11137.0
2023-04-10 06:00:00	SPY	ETF	409.35	409.46	409.31	409.33	8358.0
2023-04-10 07:00:00	SPY	ETF	409.29	409.32	408.25	408.45	102072.0
2023-04-10 08:00:00	SPY	ETF	408.9598	409.31	406.75	406.81	305152.0
2023-04-10 09:00:00	SPY	ETF	406.78	406.99	405.97	406.2	6595656.0
2023-04-10 10:00:00	SPY	ETF	406.2	407.39	406.02	406.68	7502704.0
2023-04-10 11:00:00	SPY	ETF	406.71	407.785	406.71	407.01	4862811.0
2023-04-10 12:00:00	SPY	ETF	407.02	408.34	406.29	408.3	6152444.0
2023-04-10 13:00:00	SPY	ETF	408.31	408.9	408.19	408.64	6065693.0
2023-04-10 14:00:00	SPY	ETF	408.62	409.13	408.36	409.07	4342380.0
2023-04-10 15:00:00	SPY	ETF	409.08	409.69	408.64	409.66	9980003.0
2023-04-10 16:00:00	SPY	ETF	409.66	410.07	409.45	409.89	3302630.0
2023-04-10 17:00:00	SPY	ETF	409.85	410.0	409.61	409.8	94521.0
2023-04-10 18:00:00	SPY	ETF	409.77	410.04	409.72	409.941	63279.0
2023-04-10 19:00:00	SPY	ETF	409.93	410.1896	409.93	410.18	29354.0
2023-04-10 04:00:00	QQQ	ETF	317.25	317.46	317.13	317.4	58806.0
2023-04-10 05:00:00	QQQ	ETF	317.41	317.9	317.35	317.74	32106.0
2023-04-10 06:00:00	QQQ	ETF	317.75	317.99	317.65	317.65	40980.0
2023-04-10 07:00:00	QQQ	ETF	317.73	317.73	316.25	316.65	181050.0
2023-04-10 08:00:00	QQQ	ETF	317.49	317.65	315.29	315.47	384536.0
2023-04-10 09:00:00	QQQ	ETF	315.45	315.68	313.25	313.715	6164310.0
2023-04-10 10:00:00	QQQ	ETF	313.69	315.02	313.33	314.46	5774564.0
2023-04-10 11:00:00	QQQ	ETF	314.48	316.16	314.48	315.26	4148539.0
2023-04-10 12:00:00	QQQ	ETF	315.26	316.8492	314.35	316.705	4427719.0
2023-04-10 13:00:00	QQQ	ETF	316.72	317.29	316.6	316.95	3466881.0
2023-04-10 14:00:00	QQQ	ETF	316.98	317.78	316.79	317.7401	3025805.0
2023-04-10 15:00:00	QQQ	ETF	317.75	317.92	317.2	317.92	4760615.0
2023-04-10 16:00:00	QQQ	ETF	317.92	318.12	317.73	317.96	1119698.0
2023-04-10 17:00:00	QQQ	ETF	318.0	318.01	317.87	317.98	70843.0
2023-04-10 18:00:00	QQQ	ETF	317.9	318.05	317.79	317.95	52666.0
2023-04-10 19:00:00	QQQ	ETF	317.95	318.14	317.92	318.12	40340.0
2023-04-10 04:00:00	IWM	ETF	174.47	174.69	174.4	174.54	10175.0
2023-04-10 05:00:00	IWM	ETF	174.55	174.71	174.49	174.49	1424.0
2023-04-10 06:00:00	IWM	ETF	174.64	174.75	174.59	174.66	12302.0
2023-04-10 07:00:00	IWM	ETF	174.62	174.64	173.89	173.93	42619.0
2023-04-10 08:00:00	IWM	ETF	174.14	174.63	172.92	173.1	58151.0
2023-04-10 09:00:00	IWM	ETF	173.07	174.905	172.79	174.475	3273758.0
2023-04-10 10:00:00	IWM	ETF	174.47	175.58	174.37	174.77	3403222.0
2023-04-10 11:00:00	IWM	ETF	174.79	175.1	174.105	174.23	1666506.0
2023-04-10 12:00:00	IWM	ETF	174.22	174.9	173.97	174.81	2185641.0
2023-04-10 13:00:00	IWM	ETF	174.83	175.485	174.81	175.1199	1292456.0
2023-04-10 14:00:00	IWM	ETF	175.115	175.63	174.9841	175.59	1240666.0
2023-04-10 15:00:00	IWM	ETF	175.6	175.88	175.49	175.81	3383908.0
2023-04-10 16:00:00	IWM	ETF	175.75	176.1	175.75	176.05	1097979.0
2023-04-10 17:00:00	IWM	ETF	176.04	176.05	175.75	175.98	112832.0
2023-04-10 18:00:00	IWM	ETF	175.98	176.24	175.95	176.24	16064.0
2023-04-10 19:00:00	IWM	ETF	176.11	176.27	176.1	176.27	25978.0
2023-04-10 04:00:00	DIA	ETF	334.89	334.89	334.89	334.89	500.0
2023-04-10 05:00:00	DIA	ETF	334.99	335.18	334.98	335.18	2300.0

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

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