PREVIEW / etf_1hour / 2023-04-13

all etf 1-hour files

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

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-13 04:00:00	SPY	ETF	409.0	409.31	408.54	408.54	43566.0
2023-04-13 05:00:00	SPY	ETF	408.6	409.36	408.54	409.02	31151.0
2023-04-13 06:00:00	SPY	ETF	408.95	408.95	408.33	408.52	31337.0
2023-04-13 07:00:00	SPY	ETF	408.5	408.79	408.08	408.22	118515.0
2023-04-13 08:00:00	SPY	ETF	408.512	409.94	408.02	409.55	619539.0
2023-04-13 09:00:00	SPY	ETF	409.55	409.75	408.7007	409.1398	6187506.0
2023-04-13 10:00:00	SPY	ETF	409.13	410.88	408.95	410.26	9984986.0
2023-04-13 11:00:00	SPY	ETF	410.255	411.08	410.255	410.95	5545491.0
2023-04-13 12:00:00	SPY	ETF	410.95	411.56	410.95	411.49	4885002.0
2023-04-13 13:00:00	SPY	ETF	411.49	412.78	411.095	412.67	6494463.0
2023-04-13 14:00:00	SPY	ETF	412.68	413.6599	412.55	413.555	8344265.0
2023-04-13 15:00:00	SPY	ETF	413.56	413.84	413.13	413.445	16425810.0
2023-04-13 16:00:00	SPY	ETF	413.45	413.47	412.96	413.0	3578265.0
2023-04-13 17:00:00	SPY	ETF	413.08	413.24	412.94	412.95	105852.0
2023-04-13 18:00:00	SPY	ETF	412.93	413.35	412.88	413.24	103028.0
2023-04-13 19:00:00	SPY	ETF	413.26	413.34	413.01	413.15	61813.0
2023-04-13 04:00:00	QQQ	ETF	313.86	314.16	313.39	313.44	81594.0
2023-04-13 05:00:00	QQQ	ETF	313.6	314.6	313.52	314.11	42250.0
2023-04-13 06:00:00	QQQ	ETF	314.07	314.07	313.57	313.7	26525.0
2023-04-13 07:00:00	QQQ	ETF	313.74	314.15	313.28	313.38	130040.0
2023-04-13 08:00:00	QQQ	ETF	313.67	315.1	313.15	314.78	1238462.0
2023-04-13 09:00:00	QQQ	ETF	314.75	316.13	314.26	315.79	6637568.0
2023-04-13 10:00:00	QQQ	ETF	315.78	317.48	315.5	316.7893	7422877.0
2023-04-13 11:00:00	QQQ	ETF	316.79	317.618	316.79	317.52	3567031.0
2023-04-13 12:00:00	QQQ	ETF	317.52	317.96	317.41	317.71	2959927.0
2023-04-13 13:00:00	QQQ	ETF	317.705	318.86	317.3	318.78	3489861.0
2023-04-13 14:00:00	QQQ	ETF	318.79	319.4	318.635	319.14	4609532.0
2023-04-13 15:00:00	QQQ	ETF	319.145	319.65	318.94	319.27	8452874.0
2023-04-13 16:00:00	QQQ	ETF	319.26	319.2784	318.53	318.55	1832101.0
2023-04-13 17:00:00	QQQ	ETF	318.58	319.17	318.54	318.6	711991.0
2023-04-13 18:00:00	QQQ	ETF	318.61	318.96	318.45	318.86	150369.0
2023-04-13 19:00:00	QQQ	ETF	318.9	318.91	318.62	318.75	46277.0
2023-04-13 04:00:00	IWM	ETF	176.2	176.77	176.2	176.29	11575.0
2023-04-13 05:00:00	IWM	ETF	176.3	176.71	176.29	176.51	4870.0
2023-04-13 06:00:00	IWM	ETF	176.52	176.53	175.97	176.2	9463.0
2023-04-13 07:00:00	IWM	ETF	176.24	176.4	176.09	176.12	14927.0
2023-04-13 08:00:00	IWM	ETF	176.25	177.0	176.07	176.68	109549.0
2023-04-13 09:00:00	IWM	ETF	176.75	177.02	175.93	176.56	2353876.0
2023-04-13 10:00:00	IWM	ETF	176.57	177.5	176.35	176.95	2800012.0
2023-04-13 11:00:00	IWM	ETF	176.99	177.48	176.98	177.46	1544436.0
2023-04-13 12:00:00	IWM	ETF	177.46	178.07	177.455	177.9999	2221206.0
2023-04-13 13:00:00	IWM	ETF	177.995	178.5	177.79	178.4	1678344.0
2023-04-13 14:00:00	IWM	ETF	178.4	178.685	178.27	178.4201	1702900.0
2023-04-13 15:00:00	IWM	ETF	178.425	178.53	178.01	178.17	3485907.0
2023-04-13 16:00:00	IWM	ETF	178.17	178.17	177.89	177.96	880636.0
2023-04-13 17:00:00	IWM	ETF	177.7	178.15	177.7	178.0	9765.0
2023-04-13 18:00:00	IWM	ETF	177.96	178.1	177.9	178.1	6336.0
2023-04-13 19:00:00	IWM	ETF	178.06	178.14	177.97	178.05	15237.0
2023-04-13 04:00:00	DIA	ETF	336.95	336.95	336.88	336.89	1500.0
2023-04-13 06:00:00	DIA	ETF	336.89	336.91	336.51	336.51	3502.0

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

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