PREVIEW / etf_1hour / 2022-05-26

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-05-26.parquet
  size:    457 KB
  rows:    16,282

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
2022-05-26 04:00:00	SPY	ETF	398.7	398.76	396.64	397.0	61836.0
2022-05-26 05:00:00	SPY	ETF	396.89	398.54	396.89	398.33	21678.0
2022-05-26 06:00:00	SPY	ETF	398.3	398.95	397.76	398.88	64289.0
2022-05-26 07:00:00	SPY	ETF	398.66	400.7	398.56	399.92	309054.0
2022-05-26 08:00:00	SPY	ETF	399.16	400.65	396.0	399.8	614610.0
2022-05-26 09:00:00	SPY	ETF	399.8	402.81	398.45	402.57	6909130.0
2022-05-26 10:00:00	SPY	ETF	402.56	404.04	402.34	404.0	8111717.0
2022-05-26 11:00:00	SPY	ETF	404.0	404.92	403.68	404.44	5709174.0
2022-05-26 12:00:00	SPY	ETF	404.395	406.37	404.21	406.3273	5731837.0
2022-05-26 13:00:00	SPY	ETF	406.33	407.005	405.445	406.25	6142516.0
2022-05-26 14:00:00	SPY	ETF	406.225	406.62	405.38	406.015	6096589.0
2022-05-26 15:00:00	SPY	ETF	406.0	407.04	404.53	405.29	17156341.0
2022-05-26 16:00:00	SPY	ETF	405.29	405.39	404.43	404.9	4186721.0
2022-05-26 17:00:00	SPY	ETF	404.93	405.04	404.4	404.4	106217.0
2022-05-26 18:00:00	SPY	ETF	404.54	405.46	404.53	405.06	131950.0
2022-05-26 19:00:00	SPY	ETF	405.03	405.6	405.0	405.42	87827.0
2022-05-26 04:00:00	QQQ	ETF	291.25	291.95	289.52	290.02	106019.0
2022-05-26 05:00:00	QQQ	ETF	289.96	291.11	289.67	290.95	69787.0
2022-05-26 06:00:00	QQQ	ETF	291.0	291.65	290.59	291.34	93567.0
2022-05-26 07:00:00	QQQ	ETF	291.29	293.05	291.22	292.0	538304.0
2022-05-26 08:00:00	QQQ	ETF	291.374	292.99	289.4	292.05	531822.0
2022-05-26 09:00:00	QQQ	ETF	291.99	295.66	290.15	295.385	7218988.0
2022-05-26 10:00:00	QQQ	ETF	295.4	297.37	294.95	297.34	8354080.0
2022-05-26 11:00:00	QQQ	ETF	297.34	298.4	297.01	298.15	4645271.0
2022-05-26 12:00:00	QQQ	ETF	298.1799	300.35	297.79	300.317	5104287.0
2022-05-26 13:00:00	QQQ	ETF	300.31	300.92	299.48	300.34	4424072.0
2022-05-26 14:00:00	QQQ	ETF	300.34	300.66	299.595	300.04	4237627.0
2022-05-26 15:00:00	QQQ	ETF	300.03	300.73	298.27	299.31	10918114.0
2022-05-26 16:00:00	QQQ	ETF	299.31	299.38	298.61	298.85	1851969.0
2022-05-26 17:00:00	QQQ	ETF	298.8	299.01	298.8	298.8	57240.0
2022-05-26 18:00:00	QQQ	ETF	298.78	299.81	298.7	299.36	148109.0
2022-05-26 19:00:00	QQQ	ETF	299.36	299.81	299.32	299.6	53361.0
2022-05-26 04:00:00	IWM	ETF	179.66	179.7	178.75	178.94	10773.0
2022-05-26 05:00:00	IWM	ETF	178.86	179.7	178.73	179.58	9693.0
2022-05-26 06:00:00	IWM	ETF	179.69	179.79	179.27	179.77	14609.0
2022-05-26 07:00:00	IWM	ETF	179.69	180.89	179.66	180.49	93786.0
2022-05-26 08:00:00	IWM	ETF	180.57	180.78	178.97	180.21	132393.0
2022-05-26 09:00:00	IWM	ETF	180.16	182.015	179.7	181.9	3028781.0
2022-05-26 10:00:00	IWM	ETF	181.9	182.73	181.59	182.52	3531497.0
2022-05-26 11:00:00	IWM	ETF	182.53	182.85	182.27	182.77	1713350.0
2022-05-26 12:00:00	IWM	ETF	182.75	183.48	182.64	183.42	2233290.0
2022-05-26 13:00:00	IWM	ETF	183.43	183.795	182.97	183.45	1722457.0
2022-05-26 14:00:00	IWM	ETF	183.43	183.57	182.88	183.12	1389012.0
2022-05-26 15:00:00	IWM	ETF	183.1242	183.54	182.58	182.65	4514483.0
2022-05-26 16:00:00	IWM	ETF	182.72	182.72	182.41	182.58	1971053.0
2022-05-26 17:00:00	IWM	ETF	182.67	182.7	182.52	182.6	9025.0
2022-05-26 18:00:00	IWM	ETF	182.51	182.87	182.4	182.61	46173.0
2022-05-26 19:00:00	IWM	ETF	182.62	182.95	182.6	182.94	19753.0
2022-05-26 06:00:00	DIA	ETF	322.27	322.27	321.8	322.24	600.0
2022-05-26 07:00:00	DIA	ETF	322.61	323.64	322.61	323.1	8832.0

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

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