PREVIEW / etf_1hour / 2023-04-19

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-04-19.parquet
  size:    463 KB
  rows:    16,924

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-19 04:00:00	SPY	ETF	413.09	413.09	412.32	412.64	34132.0
2023-04-19 05:00:00	SPY	ETF	412.48	412.48	411.69	411.74	52013.0
2023-04-19 06:00:00	SPY	ETF	411.84	412.29	411.77	412.29	52268.0
2023-04-19 07:00:00	SPY	ETF	412.3	412.55	412.0	412.14	175843.0
2023-04-19 08:00:00	SPY	ETF	412.33	413.85	411.46	411.72	534459.0
2023-04-19 09:00:00	SPY	ETF	411.72	412.74	411.72	412.3	5762310.0
2023-04-19 10:00:00	SPY	ETF	412.31	413.585	412.26	413.32	7675422.0
2023-04-19 11:00:00	SPY	ETF	413.34	413.79	412.97	413.72	5184651.0
2023-04-19 12:00:00	SPY	ETF	413.73	414.21	413.53	414.0309	4012595.0
2023-04-19 13:00:00	SPY	ETF	414.04	414.58	413.84	414.5394	4952045.0
2023-04-19 14:00:00	SPY	ETF	414.54	415.08	414.18	414.53	4969464.0
2023-04-19 15:00:00	SPY	ETF	414.53	414.775	413.63	414.21	9758056.0
2023-04-19 16:00:00	SPY	ETF	414.2	414.22	413.6	413.7	2685441.0
2023-04-19 17:00:00	SPY	ETF	413.6	413.9	413.56	413.63	45434.0
2023-04-19 18:00:00	SPY	ETF	413.63	413.65	413.13	413.25	465836.0
2023-04-19 19:00:00	SPY	ETF	413.24	413.27	412.85	412.94	61099.0
2023-04-19 04:00:00	QQQ	ETF	317.43	317.9	316.78	317.01	44145.0
2023-04-19 05:00:00	QQQ	ETF	317.1	317.1	315.92	316.07	103402.0
2023-04-19 06:00:00	QQQ	ETF	316.17	316.66	316.12	316.59	62602.0
2023-04-19 07:00:00	QQQ	ETF	316.63	316.88	316.35	316.56	250902.0
2023-04-19 08:00:00	QQQ	ETF	316.6284	319.099	316.02	316.28	356954.0
2023-04-19 09:00:00	QQQ	ETF	316.31	317.545	316.18	316.63	4668065.0
2023-04-19 10:00:00	QQQ	ETF	316.63	317.93	316.54	317.68	5438163.0
2023-04-19 11:00:00	QQQ	ETF	317.7	318.625	317.66	318.52	4247400.0
2023-04-19 12:00:00	QQQ	ETF	318.52	319.31	318.29	318.93	3782572.0
2023-04-19 13:00:00	QQQ	ETF	318.94	319.42	318.8	319.33	2774881.0
2023-04-19 14:00:00	QQQ	ETF	319.33	319.79	318.82	319.31	2666414.0
2023-04-19 15:00:00	QQQ	ETF	319.31	319.55	318.4099	318.74	4724351.0
2023-04-19 16:00:00	QQQ	ETF	318.73	318.94	318.1	318.36	1200100.0
2023-04-19 17:00:00	QQQ	ETF	318.4	318.44	318.2	318.2	31027.0
2023-04-19 18:00:00	QQQ	ETF	318.21	318.3	317.76	317.87	66001.0
2023-04-19 19:00:00	QQQ	ETF	317.84	317.9	317.28	317.42	91776.0
2023-04-19 04:00:00	IWM	ETF	177.74	177.74	177.21	177.44	16665.0
2023-04-19 05:00:00	IWM	ETF	177.32	177.32	176.88	176.91	11901.0
2023-04-19 06:00:00	IWM	ETF	176.96	177.15	176.91	177.15	8015.0
2023-04-19 07:00:00	IWM	ETF	177.12	177.17	176.75	176.87	40784.0
2023-04-19 08:00:00	IWM	ETF	177.11	177.12	176.54	176.54	192503.0
2023-04-19 09:00:00	IWM	ETF	176.65	177.29	176.58	176.69	3072289.0
2023-04-19 10:00:00	IWM	ETF	176.695	177.73	176.675	177.54	2020622.0
2023-04-19 11:00:00	IWM	ETF	177.565	177.63	176.93	177.19	1585451.0
2023-04-19 12:00:00	IWM	ETF	177.2	177.85	176.97	177.8	1376602.0
2023-04-19 13:00:00	IWM	ETF	177.79	178.42	177.7875	178.4099	1648641.0
2023-04-19 14:00:00	IWM	ETF	178.41	178.77	178.34	178.62	1679068.0
2023-04-19 15:00:00	IWM	ETF	178.63	178.79	178.075	178.33	2919840.0
2023-04-19 16:00:00	IWM	ETF	178.25	178.35	178.07	178.11	913057.0
2023-04-19 17:00:00	IWM	ETF	178.23	178.25	178.03	178.16	8450.0
2023-04-19 18:00:00	IWM	ETF	178.09	178.09	177.67	177.75	258480.0
2023-04-19 19:00:00	IWM	ETF	177.73	177.78	177.62	177.69	17159.0
2023-04-19 05:00:00	DIA	ETF	338.36	338.36	338.25	338.27	700.0
2023-04-19 06:00:00	DIA	ETF	338.16	338.49	338.16	338.4	1070.0

> showing 50 of 16,924 rows — these rows as CSV

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