PREVIEW / etf_30min / 2022-05-31

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-05-31.parquet
  size:    675 KB
  rows:    27,210

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-31 04:00:00	SPY	ETF	413.9	417.05	413.71	415.78	99449.0
2022-05-31 04:30:00	SPY	ETF	415.7	416.21	415.25	415.42	47621.0
2022-05-31 05:00:00	SPY	ETF	415.26	415.26	413.3	413.57	59059.0
2022-05-31 05:30:00	SPY	ETF	413.73	413.91	411.98	412.72	62260.0
2022-05-31 06:00:00	SPY	ETF	412.62	412.86	412.01	412.58	100129.0
2022-05-31 06:30:00	SPY	ETF	412.7	414.12	412.5	413.43	82539.0
2022-05-31 07:00:00	SPY	ETF	413.38	414.59	413.32	413.41	232463.0
2022-05-31 07:30:00	SPY	ETF	413.36	413.99	413.0	413.49	245790.0
2022-05-31 08:00:00	SPY	ETF	413.7	416.69	412.1796	412.68	572686.0
2022-05-31 08:30:00	SPY	ETF	412.67	412.69	411.99	412.11	312229.0
2022-05-31 09:00:00	SPY	ETF	412.15	414.09	412.11	413.53	436574.0
2022-05-31 09:30:00	SPY	ETF	413.55	413.93	410.22	411.2	8141824.0
2022-05-31 10:00:00	SPY	ETF	411.16	413.07	410.03	411.74	5042671.0
2022-05-31 10:30:00	SPY	ETF	411.72	413.51	411.61	412.9359	3829851.0
2022-05-31 11:00:00	SPY	ETF	412.92	413.58	411.39	411.645	3004707.0
2022-05-31 11:30:00	SPY	ETF	411.65	414.88	411.2505	414.59	3581647.0
2022-05-31 12:00:00	SPY	ETF	414.61	415.5599	413.48	414.3686	3995304.0
2022-05-31 12:30:00	SPY	ETF	414.3734	415.77	414.07	415.15	2546594.0
2022-05-31 13:00:00	SPY	ETF	415.15	415.6201	413.61	413.97	2659068.0
2022-05-31 13:30:00	SPY	ETF	413.95	416.325	413.85	416.22	3050328.0
2022-05-31 14:00:00	SPY	ETF	416.22	416.46	414.97	415.44	3490806.0
2022-05-31 14:30:00	SPY	ETF	415.44	415.67	412.24	413.04	4525082.0
2022-05-31 15:00:00	SPY	ETF	413.05	414.55	412.07	414.32	4341572.0
2022-05-31 15:30:00	SPY	ETF	414.315	415.26	412.38	412.94	14685698.0
2022-05-31 16:00:00	SPY	ETF	412.94	413.24	412.05	412.87	7504560.0
2022-05-31 16:30:00	SPY	ETF	412.75	413.12	412.65	412.97	547058.0
2022-05-31 17:00:00	SPY	ETF	412.93	413.14	412.85	413.1	137111.0
2022-05-31 17:30:00	SPY	ETF	413.1	413.26	413.1	413.24	70331.0
2022-05-31 18:00:00	SPY	ETF	413.25	413.53	413.06	413.33	82370.0
2022-05-31 18:30:00	SPY	ETF	413.38	414.0	413.38	413.98	74213.0
2022-05-31 19:00:00	SPY	ETF	414.06	414.08	413.72	413.96	16696.0
2022-05-31 19:30:00	SPY	ETF	414.06	414.6	413.77	414.57	28613.0
2022-05-31 04:00:00	QQQ	ETF	309.36	310.62	308.51	310.47	87878.0
2022-05-31 04:30:00	QQQ	ETF	310.5	310.88	310.1	310.16	58082.0
2022-05-31 05:00:00	QQQ	ETF	310.05	310.05	308.29	308.85	153717.0
2022-05-31 05:30:00	QQQ	ETF	308.83	309.01	307.72	308.23	76638.0
2022-05-31 06:00:00	QQQ	ETF	308.2	308.32	307.68	308.0	48137.0
2022-05-31 06:30:00	QQQ	ETF	308.05	309.3	307.88	308.75	115463.0
2022-05-31 07:00:00	QQQ	ETF	308.71	309.78	308.71	308.94	150590.0
2022-05-31 07:30:00	QQQ	ETF	308.93	309.5	308.74	309.1	172164.0
2022-05-31 08:00:00	QQQ	ETF	309.04	311.22	307.65	307.92	498988.0
2022-05-31 08:30:00	QQQ	ETF	307.9	307.93	307.13	307.42	525961.0
2022-05-31 09:00:00	QQQ	ETF	307.41	309.2	307.41	309.1	395124.0
2022-05-31 09:30:00	QQQ	ETF	309.08	309.35	305.28	306.08	7236896.0
2022-05-31 10:00:00	QQQ	ETF	306.05	307.09	304.33	306.43	4794660.0
2022-05-31 10:30:00	QQQ	ETF	306.43	308.39	306.28	307.77	3304239.0
2022-05-31 11:00:00	QQQ	ETF	307.77	308.61	306.59	306.92	2342644.0
2022-05-31 11:30:00	QQQ	ETF	306.88	310.22	306.42	309.89	2407763.0
2022-05-31 12:00:00	QQQ	ETF	309.91	310.91	308.73	309.78	2643959.0
2022-05-31 12:30:00	QQQ	ETF	309.78	311.01	309.49	310.47	1846037.0

> showing 50 of 27,210 rows — these rows as CSV

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