PREVIEW / etf_30min / 2022-06-01

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-06-01.parquet
  size:    671 KB
  rows:    26,674

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-01 04:00:00	SPY	ETF	413.87	413.87	412.38	412.8	11297.0
2022-06-01 04:30:00	SPY	ETF	412.94	413.39	412.83	413.18	11050.0
2022-06-01 05:00:00	SPY	ETF	413.29	413.77	413.18	413.77	12404.0
2022-06-01 05:30:00	SPY	ETF	413.8	413.92	413.3	413.3	2450.0
2022-06-01 06:00:00	SPY	ETF	413.28	413.35	412.75	412.79	7746.0
2022-06-01 06:30:00	SPY	ETF	412.97	413.12	412.5	412.8	9245.0
2022-06-01 07:00:00	SPY	ETF	412.81	413.72	412.78	413.41	40920.0
2022-06-01 07:30:00	SPY	ETF	413.2	414.09	413.2	414.07	429269.0
2022-06-01 08:00:00	SPY	ETF	412.81	414.94	412.49	414.73	212518.0
2022-06-01 08:30:00	SPY	ETF	414.73	415.02	414.48	414.49	237701.0
2022-06-01 09:00:00	SPY	ETF	414.49	415.24	414.23	415.17	251565.0
2022-06-01 09:30:00	SPY	ETF	415.15	416.24	413.94	414.8999	5962505.0
2022-06-01 10:00:00	SPY	ETF	414.83	415.19	410.24	410.27	6188344.0
2022-06-01 10:30:00	SPY	ETF	410.265	411.05	409.09	410.74	5057224.0
2022-06-01 11:00:00	SPY	ETF	410.7424	410.75	407.97	408.7788	4708873.0
2022-06-01 11:30:00	SPY	ETF	408.79	409.07	407.36	407.6459	3456815.0
2022-06-01 12:00:00	SPY	ETF	407.64	408.45	407.06	407.54	3332948.0
2022-06-01 12:30:00	SPY	ETF	407.55	408.58	406.93	408.0	2920288.0
2022-06-01 13:00:00	SPY	ETF	407.99	409.59	407.79	409.2	3344263.0
2022-06-01 13:30:00	SPY	ETF	409.25	410.44	408.81	409.82	3814566.0
2022-06-01 14:00:00	SPY	ETF	409.82	412.1	409.681	411.68	5074628.0
2022-06-01 14:30:00	SPY	ETF	411.68	412.33	410.82	411.12	4044185.0
2022-06-01 15:00:00	SPY	ETF	411.12	412.54	410.52	411.71	3962795.0
2022-06-01 15:30:00	SPY	ETF	411.735	412.41	409.53	409.62	9559811.0
2022-06-01 16:00:00	SPY	ETF	409.63	409.98	409.21	409.52	3781866.0
2022-06-01 16:30:00	SPY	ETF	409.55	409.63	409.15	409.38	292146.0
2022-06-01 17:00:00	SPY	ETF	409.45	409.56	409.34	409.5	50698.0
2022-06-01 17:30:00	SPY	ETF	409.45	409.5	409.27	409.39	40192.0
2022-06-01 18:00:00	SPY	ETF	409.45	409.65	409.18	409.23	112140.0
2022-06-01 18:30:00	SPY	ETF	409.23	409.23	408.75	408.79	61319.0
2022-06-01 19:00:00	SPY	ETF	408.8	409.08	408.7	409.08	23880.0
2022-06-01 19:30:00	SPY	ETF	409.01	409.05	408.35	408.46	94416.0
2022-06-01 04:00:00	QQQ	ETF	308.35	308.38	306.88	307.53	30318.0
2022-06-01 04:30:00	QQQ	ETF	307.62	307.94	307.32	307.8	17750.0
2022-06-01 05:00:00	QQQ	ETF	307.9	308.4	307.79	308.4	9267.0
2022-06-01 05:30:00	QQQ	ETF	308.38	308.51	308.0	308.07	15586.0
2022-06-01 06:00:00	QQQ	ETF	308.02	308.02	307.53	307.71	17800.0
2022-06-01 06:30:00	QQQ	ETF	307.76	308.12	307.4	307.8	25229.0
2022-06-01 07:00:00	QQQ	ETF	307.7	308.5	307.7	308.35	155528.0
2022-06-01 07:30:00	QQQ	ETF	308.36	309.25	308.17	309.22	236593.0
2022-06-01 08:00:00	QQQ	ETF	309.26	310.04	307.6296	309.78	406640.0
2022-06-01 08:30:00	QQQ	ETF	309.8	309.89	309.41	309.41	265988.0
2022-06-01 09:00:00	QQQ	ETF	309.41	310.67	309.28	310.48	483963.0
2022-06-01 09:30:00	QQQ	ETF	310.47	312.65	310.43	312.2101	6594048.0
2022-06-01 10:00:00	QQQ	ETF	312.24	312.572	307.4	307.55	6154122.0
2022-06-01 10:30:00	QQQ	ETF	307.5501	308.83	306.2	308.3	4265227.0
2022-06-01 11:00:00	QQQ	ETF	308.25	308.27	305.4	306.21	3402599.0
2022-06-01 11:30:00	QQQ	ETF	306.24	306.44	304.8	305.02	2683695.0
2022-06-01 12:00:00	QQQ	ETF	305.02	305.225	303.7804	304.3115	2862211.0
2022-06-01 12:30:00	QQQ	ETF	304.31	305.4446	303.73	304.725	2160369.0

> showing 50 of 26,674 rows — these rows as CSV

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