PREVIEW / etf_30min / 2022-05-02

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-05-02.parquet
  size:    696 KB
  rows:    28,142

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-02 04:00:00	SPY	ETF	413.0	414.54	412.72	413.71	25042.0
2022-05-02 04:30:00	SPY	ETF	413.5	413.5	412.55	413.0	13050.0
2022-05-02 05:00:00	SPY	ETF	413.0	413.94	413.0	413.9	16815.0
2022-05-02 05:30:00	SPY	ETF	414.05	414.33	413.7	413.7	9436.0
2022-05-02 06:00:00	SPY	ETF	413.72	414.1	413.33	413.93	53340.0
2022-05-02 06:30:00	SPY	ETF	413.81	414.2	413.4	413.4	31876.0
2022-05-02 07:00:00	SPY	ETF	413.62	413.66	412.51	412.69	257618.0
2022-05-02 07:30:00	SPY	ETF	412.55	412.55	410.49	410.7	218901.0
2022-05-02 08:00:00	SPY	ETF	413.13	415.0	410.52	411.42	393064.0
2022-05-02 08:30:00	SPY	ETF	411.48	411.78	410.45	411.04	275989.0
2022-05-02 09:00:00	SPY	ETF	411.01	412.8	411.01	412.04	503366.0
2022-05-02 09:30:00	SPY	ETF	412.07	413.37	409.25	412.27	11751028.0
2022-05-02 10:00:00	SPY	ETF	412.27	414.9513	410.35	414.46	8282520.0
2022-05-02 10:30:00	SPY	ETF	414.44	415.92	412.28	412.41	7848576.0
2022-05-02 11:00:00	SPY	ETF	412.42	412.62	410.0	410.58	6761906.0
2022-05-02 11:30:00	SPY	ETF	410.66	411.86	409.8	411.76	5896527.0
2022-05-02 12:00:00	SPY	ETF	411.71	412.56	409.77	411.51	4542772.0
2022-05-02 12:30:00	SPY	ETF	411.5	412.27	408.68	408.99	4211543.0
2022-05-02 13:00:00	SPY	ETF	408.98	410.08	408.03	408.67	4625639.0
2022-05-02 13:30:00	SPY	ETF	408.66	409.34	406.92	407.65	6099005.0
2022-05-02 14:00:00	SPY	ETF	407.58	408.82	405.75	406.285	7623154.0
2022-05-02 14:30:00	SPY	ETF	406.27	407.72	405.02	406.46	8524128.0
2022-05-02 15:00:00	SPY	ETF	406.4	412.54	406.32	411.91	11105343.0
2022-05-02 15:30:00	SPY	ETF	411.91	414.66	411.55	414.5	19596003.0
2022-05-02 16:00:00	SPY	ETF	414.54	415.01	413.71	413.97	4169897.0
2022-05-02 16:30:00	SPY	ETF	413.96	414.5	413.86	414.07	298955.0
2022-05-02 17:00:00	SPY	ETF	414.14	414.16	414.01	414.09	29793.0
2022-05-02 17:30:00	SPY	ETF	414.06	414.33	414.0	414.09	86764.0
2022-05-02 18:00:00	SPY	ETF	414.06	414.1	413.85	414.0	81220.0
2022-05-02 18:30:00	SPY	ETF	413.85	413.9	413.59	413.76	39058.0
2022-05-02 19:00:00	SPY	ETF	413.75	414.3	413.75	414.2	22670.0
2022-05-02 19:30:00	SPY	ETF	414.12	414.19	413.9	414.11	53137.0
2022-05-02 04:00:00	QQQ	ETF	314.06	315.69	313.25	314.96	122214.0
2022-05-02 04:30:00	QQQ	ETF	314.88	315.05	313.64	313.96	25234.0
2022-05-02 05:00:00	QQQ	ETF	314.05	314.8	314.05	314.8	16662.0
2022-05-02 05:30:00	QQQ	ETF	314.8	315.01	314.5	314.55	87035.0
2022-05-02 06:00:00	QQQ	ETF	314.52	315.03	314.25	314.84	84233.0
2022-05-02 06:30:00	QQQ	ETF	314.84	315.23	314.25	314.46	48071.0
2022-05-02 07:00:00	QQQ	ETF	314.5	314.75	313.46	313.63	140660.0
2022-05-02 07:30:00	QQQ	ETF	313.51	313.51	311.0	311.43	459169.0
2022-05-02 08:00:00	QQQ	ETF	314.6799	316.05	311.11	312.14	433789.0
2022-05-02 08:30:00	QQQ	ETF	312.14	312.49	311.25	311.79	408833.0
2022-05-02 09:00:00	QQQ	ETF	311.75	313.75	311.75	312.8396	613394.0
2022-05-02 09:30:00	QQQ	ETF	312.82	316.1135	310.4414	314.92	10253989.0
2022-05-02 10:00:00	QQQ	ETF	314.91	316.57	312.1	316.31	6814223.0
2022-05-02 10:30:00	QQQ	ETF	316.32	317.76	314.13	314.455	6846157.0
2022-05-02 11:00:00	QQQ	ETF	314.44	315.17	312.57	313.48	5163779.0
2022-05-02 11:30:00	QQQ	ETF	313.55	314.61	312.39	314.42	4392085.0
2022-05-02 12:00:00	QQQ	ETF	314.4099	315.62	312.63	314.66	4561508.0
2022-05-02 12:30:00	QQQ	ETF	314.68	315.37	311.83	312.11	4070680.0

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

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