PREVIEW / etf_30min / 2022-08-24

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-08-24.parquet
  size:    638 KB
  rows:    25,285

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-08-24 04:00:00	SPY	ETF	411.15	412.19	411.13	412.14	17426.0
2022-08-24 04:30:00	SPY	ETF	412.32	412.79	412.19	412.48	49489.0
2022-08-24 05:00:00	SPY	ETF	412.67	412.79	412.29	412.29	24894.0
2022-08-24 05:30:00	SPY	ETF	412.13	412.27	411.98	412.05	56671.0
2022-08-24 06:00:00	SPY	ETF	412.02	412.38	411.95	412.06	6673.0
2022-08-24 06:30:00	SPY	ETF	412.11	412.35	411.79	411.85	86768.0
2022-08-24 07:00:00	SPY	ETF	411.85	412.56	411.85	412.56	48635.0
2022-08-24 07:30:00	SPY	ETF	412.55	413.23	412.42	413.0	144386.0
2022-08-24 08:00:00	SPY	ETF	412.01	413.45	410.86	413.0	234014.0
2022-08-24 08:30:00	SPY	ETF	413.02	413.13	412.19	412.62	255879.0
2022-08-24 09:00:00	SPY	ETF	412.63	412.63	412.0	412.11	178732.0
2022-08-24 09:30:00	SPY	ETF	412.14	412.68	411.39	412.2777	3623349.0
2022-08-24 10:00:00	SPY	ETF	412.28	413.63	411.8786	413.25	3128330.0
2022-08-24 10:30:00	SPY	ETF	413.26	413.53	412.43	413.08	2462004.0
2022-08-24 11:00:00	SPY	ETF	413.1	414.63	412.98	414.44	2953956.0
2022-08-24 11:30:00	SPY	ETF	414.44	415.1101	414.23	414.7	2110427.0
2022-08-24 12:00:00	SPY	ETF	414.7093	415.0	414.345	414.385	1459159.0
2022-08-24 12:30:00	SPY	ETF	414.3748	414.38	412.78	413.08	2549429.0
2022-08-24 13:00:00	SPY	ETF	413.08	413.53	412.51	412.6	1690865.0
2022-08-24 13:30:00	SPY	ETF	412.57	413.12	412.47	413.08	1472435.0
2022-08-24 14:00:00	SPY	ETF	413.08	413.42	412.93	413.2799	1615402.0
2022-08-24 14:30:00	SPY	ETF	413.28	413.45	412.7	413.35	1542853.0
2022-08-24 15:00:00	SPY	ETF	413.345	414.21	413.2299	413.805	2222929.0
2022-08-24 15:30:00	SPY	ETF	413.805	414.46	413.36	413.63	6599894.0
2022-08-24 16:00:00	SPY	ETF	413.63	414.11	413.46	414.03	2502506.0
2022-08-24 16:30:00	SPY	ETF	414.0	414.25	413.89	414.23	141134.0
2022-08-24 17:00:00	SPY	ETF	414.23	414.25	414.01	414.07	35485.0
2022-08-24 17:30:00	SPY	ETF	414.07	414.15	414.05	414.15	23161.0
2022-08-24 18:00:00	SPY	ETF	414.06	414.3	414.06	414.17	24920.0
2022-08-24 18:30:00	SPY	ETF	414.17	414.19	414.01	414.01	17577.0
2022-08-24 19:00:00	SPY	ETF	414.09	414.24	414.01	414.11	12675.0
2022-08-24 19:30:00	SPY	ETF	414.04	414.04	413.67	413.82	26843.0
2022-08-24 04:00:00	QQQ	ETF	313.09	314.0	313.09	313.99	30088.0
2022-08-24 04:30:00	QQQ	ETF	313.85	314.54	313.85	314.27	18140.0
2022-08-24 05:00:00	QQQ	ETF	314.38	314.52	314.2	314.23	17287.0
2022-08-24 05:30:00	QQQ	ETF	314.08	314.08	313.84	313.86	24632.0
2022-08-24 06:00:00	QQQ	ETF	313.84	314.09	313.75	313.85	5555.0
2022-08-24 06:30:00	QQQ	ETF	313.93	314.02	313.5	313.63	34441.0
2022-08-24 07:00:00	QQQ	ETF	313.64	314.17	313.52	314.17	93252.0
2022-08-24 07:30:00	QQQ	ETF	314.22	314.88	314.14	314.71	72919.0
2022-08-24 08:00:00	QQQ	ETF	313.54	315.05	312.5	314.71	225354.0
2022-08-24 08:30:00	QQQ	ETF	314.62	314.97	313.97	314.28	286459.0
2022-08-24 09:00:00	QQQ	ETF	314.27	314.27	313.41	313.54	258968.0
2022-08-24 09:30:00	QQQ	ETF	313.55	314.52	312.99	314.26	4522269.0
2022-08-24 10:00:00	QQQ	ETF	314.28	315.3699	313.61	315.005	3379833.0
2022-08-24 10:30:00	QQQ	ETF	315.01	315.51	314.37	314.96	2198735.0
2022-08-24 11:00:00	QQQ	ETF	314.96	316.43	314.785	316.3	2123841.0
2022-08-24 11:30:00	QQQ	ETF	316.33	316.705	315.835	316.37	1515498.0
2022-08-24 12:00:00	QQQ	ETF	316.395	316.87	316.13	316.17	1255312.0
2022-08-24 12:30:00	QQQ	ETF	316.17	316.26	314.96	315.2536	2077065.0

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

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