PREVIEW / etf_30min / 2022-06-08

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-06-08.parquet
  size:    649 KB
  rows:    25,554

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-06-08 04:00:00	SPY	ETF	414.0	414.49	413.61	414.2	28491.0
2022-06-08 04:30:00	SPY	ETF	414.27	414.51	414.18	414.21	13151.0
2022-06-08 05:00:00	SPY	ETF	414.22	414.33	413.65	414.01	13705.0
2022-06-08 05:30:00	SPY	ETF	414.21	414.42	414.0	414.33	5485.0
2022-06-08 06:00:00	SPY	ETF	414.2	414.2	413.58	413.7	13442.0
2022-06-08 06:30:00	SPY	ETF	413.64	414.49	413.56	414.43	22434.0
2022-06-08 07:00:00	SPY	ETF	414.43	414.729	414.12	414.7	115391.0
2022-06-08 07:30:00	SPY	ETF	414.73	415.14	414.41	414.44	140681.0
2022-06-08 08:00:00	SPY	ETF	414.44	415.0999	413.6796	413.97	152002.0
2022-06-08 08:30:00	SPY	ETF	413.94	414.11	413.29	413.74	284007.0
2022-06-08 09:00:00	SPY	ETF	413.71	414.0	413.25	413.91	225885.0
2022-06-08 09:30:00	SPY	ETF	413.93	415.82	412.66	415.28	5576271.0
2022-06-08 10:00:00	SPY	ETF	415.32	415.4424	413.26	414.38	3230645.0
2022-06-08 10:30:00	SPY	ETF	414.4	415.39	413.82	414.14	2552727.0
2022-06-08 11:00:00	SPY	ETF	414.155	415.59	413.655	415.24	2027706.0
2022-06-08 11:30:00	SPY	ETF	415.23	415.69	414.61	414.8053	1855080.0
2022-06-08 12:00:00	SPY	ETF	414.82	415.37	413.46	414.01	2024909.0
2022-06-08 12:30:00	SPY	ETF	414.01	414.03	411.56	412.73	3409625.0
2022-06-08 13:00:00	SPY	ETF	412.72	412.7299	411.781	411.7886	2149260.0
2022-06-08 13:30:00	SPY	ETF	411.79	411.98	410.64	411.52	3358364.0
2022-06-08 14:00:00	SPY	ETF	411.545	412.05	410.51	410.93	2625266.0
2022-06-08 14:30:00	SPY	ETF	410.9399	411.78	410.4	411.22	3393902.0
2022-06-08 15:00:00	SPY	ETF	411.23	412.29	410.38	412.02	3933343.0
2022-06-08 15:30:00	SPY	ETF	412.01	412.48	410.79	411.29	8353784.0
2022-06-08 16:00:00	SPY	ETF	411.28	411.57	410.5	411.49	2953267.0
2022-06-08 16:30:00	SPY	ETF	411.49	411.63	411.29	411.5	145275.0
2022-06-08 17:00:00	SPY	ETF	411.55	411.62	411.22	411.6	36951.0
2022-06-08 17:30:00	SPY	ETF	411.5789	411.59	411.22	411.52	17652.0
2022-06-08 18:00:00	SPY	ETF	411.53	411.53	411.22	411.49	30713.0
2022-06-08 18:30:00	SPY	ETF	411.45	411.7	411.45	411.7	16083.0
2022-06-08 19:00:00	SPY	ETF	411.7	411.79	411.68	411.7	7432.0
2022-06-08 19:30:00	SPY	ETF	411.62	411.76	411.49	411.6	26112.0
2022-06-08 04:00:00	QQQ	ETF	308.45	309.13	308.45	309.08	45690.0
2022-06-08 04:30:00	QQQ	ETF	309.11	309.45	309.05	309.13	4944.0
2022-06-08 05:00:00	QQQ	ETF	309.18	309.37	308.81	309.16	7479.0
2022-06-08 05:30:00	QQQ	ETF	309.13	309.56	309.13	309.31	10684.0
2022-06-08 06:00:00	QQQ	ETF	309.2	309.25	308.5	308.72	15449.0
2022-06-08 06:30:00	QQQ	ETF	308.73	309.63	308.57	309.48	15188.0
2022-06-08 07:00:00	QQQ	ETF	309.52	309.74	309.24	309.74	57941.0
2022-06-08 07:30:00	QQQ	ETF	309.77	310.17	309.25	309.38	117640.0
2022-06-08 08:00:00	QQQ	ETF	309.33	310.102	308.4796	308.76	247229.0
2022-06-08 08:30:00	QQQ	ETF	308.72	308.88	308.04	308.59	188949.0
2022-06-08 09:00:00	QQQ	ETF	308.59	309.09	308.18	309.08	218445.0
2022-06-08 09:30:00	QQQ	ETF	309.05	311.72	307.95	311.15	5629750.0
2022-06-08 10:00:00	QQQ	ETF	311.175	311.4893	309.37	310.32	2923769.0
2022-06-08 10:30:00	QQQ	ETF	310.35	311.32	309.73	310.0322	1757755.0
2022-06-08 11:00:00	QQQ	ETF	310.0699	311.48	309.41	311.17	1654908.0
2022-06-08 11:30:00	QQQ	ETF	311.17	311.46	310.25	310.32	1439979.0
2022-06-08 12:00:00	QQQ	ETF	310.32	310.86	308.85	309.44	1771937.0
2022-06-08 12:30:00	QQQ	ETF	309.42	309.4381	307.4	308.4	2392822.0

> showing 50 of 25,554 rows — these rows as CSV

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