PREVIEW / etf_30min / 2023-01-12

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-01-12.parquet
  size:    704 KB
  rows:    28,498

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-01-12 04:00:00	SPY	ETF	395.36	395.79	395.36	395.62	23695.0
2023-01-12 04:30:00	SPY	ETF	395.63	395.87	395.63	395.8	23530.0
2023-01-12 05:00:00	SPY	ETF	395.78	395.78	395.25	395.46	11564.0
2023-01-12 05:30:00	SPY	ETF	395.38	395.65	395.33	395.62	6308.0
2023-01-12 06:00:00	SPY	ETF	395.62	395.8	395.53	395.7	4140.0
2023-01-12 06:30:00	SPY	ETF	395.72	395.9	395.72	395.75	29513.0
2023-01-12 07:00:00	SPY	ETF	395.74	396.27	395.71	396.09	62226.0
2023-01-12 07:30:00	SPY	ETF	396.08	396.68	396.05	396.67	198188.0
2023-01-12 08:00:00	SPY	ETF	396.66	398.45	393.99	393.99	798951.0
2023-01-12 08:30:00	SPY	ETF	393.99	398.45	392.0	398.0	3955260.0
2023-01-12 09:00:00	SPY	ETF	398.05	398.78	395.43	396.67	1304199.0
2023-01-12 09:30:00	SPY	ETF	396.67	396.965	392.42	393.71	9021307.0
2023-01-12 10:00:00	SPY	ETF	393.73	396.895	393.64	395.92	7245387.0
2023-01-12 10:30:00	SPY	ETF	395.92	396.99	394.63	395.49	5251267.0
2023-01-12 11:00:00	SPY	ETF	395.51	396.18	394.36	395.7199	3287132.0
2023-01-12 11:30:00	SPY	ETF	395.72	396.54	394.74	396.36	2422692.0
2023-01-12 12:00:00	SPY	ETF	396.37	397.93	396.14	397.84	3084456.0
2023-01-12 12:30:00	SPY	ETF	397.85	398.126	397.45	397.755	3396756.0
2023-01-12 13:00:00	SPY	ETF	397.75	398.3899	395.9	396.18	4104424.0
2023-01-12 13:30:00	SPY	ETF	396.22	398.43	395.53	398.26	4329617.0
2023-01-12 14:00:00	SPY	ETF	398.27	398.485	397.3	397.46	3388403.0
2023-01-12 14:30:00	SPY	ETF	397.454	397.98	396.72	397.39	3156597.0
2023-01-12 15:00:00	SPY	ETF	397.3913	397.54	396.25	396.68	3875772.0
2023-01-12 15:30:00	SPY	ETF	396.685	397.16	395.86	396.94	8310350.0
2023-01-12 16:00:00	SPY	ETF	396.93	397.16	396.79	397.03	5030672.0
2023-01-12 16:30:00	SPY	ETF	396.99	397.05	396.9	396.92	142198.0
2023-01-12 17:00:00	SPY	ETF	397.07	397.07	396.94	397.04	78065.0
2023-01-12 17:30:00	SPY	ETF	397.06	397.12	397.0	397.03	42667.0
2023-01-12 18:00:00	SPY	ETF	397.02	397.07	396.78	397.04	71779.0
2023-01-12 18:30:00	SPY	ETF	397.07	397.16	396.96	397.11	18532.0
2023-01-12 19:00:00	SPY	ETF	397.13	397.45	397.13	397.3	23839.0
2023-01-12 19:30:00	SPY	ETF	397.3	397.43	397.05	397.05	16280.0
2023-01-12 04:00:00	QQQ	ETF	277.6	277.78	277.48	277.72	23795.0
2023-01-12 04:30:00	QQQ	ETF	277.74	278.0	277.72	277.89	18753.0
2023-01-12 05:00:00	QQQ	ETF	277.8	277.8	277.05	277.4	28660.0
2023-01-12 05:30:00	QQQ	ETF	277.32	277.55	277.25	277.44	12386.0
2023-01-12 06:00:00	QQQ	ETF	277.44	277.55	277.4	277.49	6278.0
2023-01-12 06:30:00	QQQ	ETF	277.46	277.55	277.4	277.42	6785.0
2023-01-12 07:00:00	QQQ	ETF	277.4	277.78	277.4	277.72	63645.0
2023-01-12 07:30:00	QQQ	ETF	277.73	278.21	277.7	278.21	191585.0
2023-01-12 08:00:00	QQQ	ETF	277.5	279.3	275.61	275.89	1070010.0
2023-01-12 08:30:00	QQQ	ETF	276.44	279.75	273.3	279.37	4076162.0
2023-01-12 09:00:00	QQQ	ETF	279.41	280.15	276.65	278.07	1752843.0
2023-01-12 09:30:00	QQQ	ETF	278.12	278.76	273.74	274.86	7416688.0
2023-01-12 10:00:00	QQQ	ETF	274.89	278.57	274.83	277.47	5332245.0
2023-01-12 10:30:00	QQQ	ETF	277.47	278.37	276.02	276.6	3307654.0
2023-01-12 11:00:00	QQQ	ETF	276.62	277.4	275.62	277.1	2090104.0
2023-01-12 11:30:00	QQQ	ETF	277.11	278.22	276.3099	278.06	1873209.0
2023-01-12 12:00:00	QQQ	ETF	278.06	279.34	277.68	279.265	2250140.0
2023-01-12 12:30:00	QQQ	ETF	279.26	279.55	278.95	279.18	2043662.0

> showing 50 of 28,498 rows — these rows as CSV

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