PREVIEW / etf_30min / 2022-06-03

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-06-03.parquet
  size:    654 KB
  rows:    25,413

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-03 04:00:00	SPY	ETF	416.78	416.98	415.91	416.21	28302.0
2022-06-03 04:30:00	SPY	ETF	416.36	416.44	415.87	416.0	10696.0
2022-06-03 05:00:00	SPY	ETF	416.2	416.28	415.74	415.81	8048.0
2022-06-03 05:30:00	SPY	ETF	415.88	416.0	415.54	416.0	12215.0
2022-06-03 06:00:00	SPY	ETF	415.98	416.03	415.59	415.96	24118.0
2022-06-03 06:30:00	SPY	ETF	416.0	416.09	414.94	415.1	80331.0
2022-06-03 07:00:00	SPY	ETF	415.11	415.28	414.22	414.8	183312.0
2022-06-03 07:30:00	SPY	ETF	414.77	415.04	413.82	414.0	179600.0
2022-06-03 08:00:00	SPY	ETF	415.1799	418.2	413.81	414.4	328344.0
2022-06-03 08:30:00	SPY	ETF	414.67	415.97	412.95	413.46	1288880.0
2022-06-03 09:00:00	SPY	ETF	413.48	413.75	412.35	412.36	551914.0
2022-06-03 09:30:00	SPY	ETF	412.36	413.98	411.36	413.114	6392931.0
2022-06-03 10:00:00	SPY	ETF	413.17	414.04	412.053	412.5	4223318.0
2022-06-03 10:30:00	SPY	ETF	412.49	412.74	410.72	411.3	3464377.0
2022-06-03 11:00:00	SPY	ETF	411.26	411.3599	409.51	410.0498	3327308.0
2022-06-03 11:30:00	SPY	ETF	410.05	411.18	409.782	410.46	3211515.0
2022-06-03 12:00:00	SPY	ETF	410.46	411.32	409.73	411.125	2719836.0
2022-06-03 12:30:00	SPY	ETF	411.13	412.26	410.75	412.16	2310471.0
2022-06-03 13:00:00	SPY	ETF	412.17	413.26	410.9	411.52	3409890.0
2022-06-03 13:30:00	SPY	ETF	411.5	411.7	410.39	410.7699	2354155.0
2022-06-03 14:00:00	SPY	ETF	410.77	412.12	410.3	412.07	2919404.0
2022-06-03 14:30:00	SPY	ETF	412.0535	412.09	410.645	411.57	2446516.0
2022-06-03 15:00:00	SPY	ETF	411.58	411.79	409.88	410.9461	3620699.0
2022-06-03 15:30:00	SPY	ETF	410.96	411.23	409.81	410.59	10255716.0
2022-06-03 16:00:00	SPY	ETF	410.59	411.14	410.16	410.71	3271104.0
2022-06-03 16:30:00	SPY	ETF	410.68	411.0	410.54	410.68	96118.0
2022-06-03 17:00:00	SPY	ETF	410.77	410.79	410.56	410.6	69261.0
2022-06-03 17:30:00	SPY	ETF	410.6	410.6	410.4	410.41	37787.0
2022-06-03 18:00:00	SPY	ETF	410.48	410.55	410.32	410.45	21607.0
2022-06-03 18:30:00	SPY	ETF	410.4	410.4	410.3	410.33	13738.0
2022-06-03 19:00:00	SPY	ETF	410.31	410.5	410.28	410.33	3157.0
2022-06-03 19:30:00	SPY	ETF	410.34	410.37	410.26	410.3	10634.0
2022-06-03 04:00:00	QQQ	ETF	313.41	313.41	312.37	312.95	87860.0
2022-06-03 04:30:00	QQQ	ETF	313.01	313.16	312.67	313.1	67136.0
2022-06-03 05:00:00	QQQ	ETF	313.05	313.13	312.39	312.46	74656.0
2022-06-03 05:30:00	QQQ	ETF	312.48	312.72	312.23	312.68	33544.0
2022-06-03 06:00:00	QQQ	ETF	312.81	312.81	312.2	312.4	76765.0
2022-06-03 06:30:00	QQQ	ETF	312.55	312.68	311.28	311.45	148252.0
2022-06-03 07:00:00	QQQ	ETF	311.49	311.69	310.66	311.3	310853.0
2022-06-03 07:30:00	QQQ	ETF	311.23	311.55	310.43	310.5	198864.0
2022-06-03 08:00:00	QQQ	ETF	310.49	315.07	310.46	310.95	377561.0
2022-06-03 08:30:00	QQQ	ETF	311.24	312.29	309.38	310.03	1629205.0
2022-06-03 09:00:00	QQQ	ETF	310.07	310.66	309.02	309.05	596161.0
2022-06-03 09:30:00	QQQ	ETF	309.03	310.14	307.5	309.58	7169806.0
2022-06-03 10:00:00	QQQ	ETF	309.57	310.47	307.85	308.21	4320769.0
2022-06-03 10:30:00	QQQ	ETF	308.23	308.31	306.4203	306.49	3748786.0
2022-06-03 11:00:00	QQQ	ETF	306.485	306.62	304.92	305.38	3749025.0
2022-06-03 11:30:00	QQQ	ETF	305.42	306.65	305.26	306.01	3173040.0
2022-06-03 12:00:00	QQQ	ETF	305.92	306.94	305.47	306.63	1906571.0
2022-06-03 12:30:00	QQQ	ETF	306.65	307.59	306.25	307.42	1603103.0

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

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