PREVIEW / etf_30min / 2022-08-05

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-08-05.parquet
  size:    644 KB
  rows:    25,556

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-05 04:00:00	SPY	ETF	414.54	414.69	414.37	414.37	6365.0
2022-08-05 04:30:00	SPY	ETF	414.19	414.19	414.0	414.04	1021.0
2022-08-05 05:00:00	SPY	ETF	413.99	414.31	413.92	414.31	5232.0
2022-08-05 05:30:00	SPY	ETF	414.23	414.28	413.95	414.28	6515.0
2022-08-05 06:00:00	SPY	ETF	414.12	414.13	413.86	414.06	14579.0
2022-08-05 06:30:00	SPY	ETF	414.01	414.09	413.65	413.72	9067.0
2022-08-05 07:00:00	SPY	ETF	413.94	414.0	413.51	413.99	43104.0
2022-08-05 07:30:00	SPY	ETF	413.96	414.63	413.9	414.6	161414.0
2022-08-05 08:00:00	SPY	ETF	414.6	415.08	413.63	414.8	193311.0
2022-08-05 08:30:00	SPY	ETF	414.51	414.7	409.24	409.78	2040721.0
2022-08-05 09:00:00	SPY	ETF	409.74	410.15	409.42	409.68	662670.0
2022-08-05 09:30:00	SPY	ETF	409.7	412.23	409.6	412.05	5806406.0
2022-08-05 10:00:00	SPY	ETF	412.05	414.15	411.81	413.43	4585135.0
2022-08-05 10:30:00	SPY	ETF	413.43	413.55	412.5	413.0305	1973413.0
2022-08-05 11:00:00	SPY	ETF	413.05	413.08	410.21	410.22	3406958.0
2022-08-05 11:30:00	SPY	ETF	410.215	411.22	410.08	410.655	3046914.0
2022-08-05 12:00:00	SPY	ETF	410.66	411.9	410.64	411.67	2648584.0
2022-08-05 12:30:00	SPY	ETF	411.66	412.58	411.0	412.49	2021931.0
2022-08-05 13:00:00	SPY	ETF	412.47	413.36	412.23	412.71	2081404.0
2022-08-05 13:30:00	SPY	ETF	412.7	413.47	412.29	412.53	1633275.0
2022-08-05 14:00:00	SPY	ETF	412.529	412.67	411.62	411.6332	2115771.0
2022-08-05 14:30:00	SPY	ETF	411.6235	412.26	411.43	412.015	2445374.0
2022-08-05 15:00:00	SPY	ETF	412.0	412.61	411.81	412.4986	2565757.0
2022-08-05 15:30:00	SPY	ETF	412.48	413.71	412.4036	413.43	5545141.0
2022-08-05 16:00:00	SPY	ETF	413.45	413.47	412.85	413.16	2130984.0
2022-08-05 16:30:00	SPY	ETF	413.17	413.47	412.88	413.02	191060.0
2022-08-05 17:00:00	SPY	ETF	412.99	413.16	412.99	413.06	75345.0
2022-08-05 17:30:00	SPY	ETF	413.03	413.09	412.99	412.99	7440.0
2022-08-05 18:00:00	SPY	ETF	412.96	412.99	412.95	412.95	7760.0
2022-08-05 18:30:00	SPY	ETF	413.03	413.1	412.95	413.07	10678.0
2022-08-05 19:00:00	SPY	ETF	413.04	413.05	412.95	412.99	7499.0
2022-08-05 19:30:00	SPY	ETF	413.05	413.1	412.11	412.95	24290.0
2022-08-05 04:00:00	QQQ	ETF	324.91	325.03	324.48	324.53	30597.0
2022-08-05 04:30:00	QQQ	ETF	324.4	324.54	323.96	324.18	10792.0
2022-08-05 05:00:00	QQQ	ETF	324.19	324.45	324.18	324.41	1745.0
2022-08-05 05:30:00	QQQ	ETF	324.25	324.25	323.88	324.14	7189.0
2022-08-05 06:00:00	QQQ	ETF	323.98	323.98	323.62	323.84	18708.0
2022-08-05 06:30:00	QQQ	ETF	323.73	323.9	323.5	323.59	9969.0
2022-08-05 07:00:00	QQQ	ETF	323.85	323.97	323.4	323.96	72304.0
2022-08-05 07:30:00	QQQ	ETF	323.93	324.49	323.9	324.47	92832.0
2022-08-05 08:00:00	QQQ	ETF	323.88	325.47	323.5	324.7	288952.0
2022-08-05 08:30:00	QQQ	ETF	324.36	324.36	319.22	319.67	2540316.0
2022-08-05 09:00:00	QQQ	ETF	319.6	320.1	318.95	319.17	496538.0
2022-08-05 09:30:00	QQQ	ETF	319.19	321.43	319.09	320.76	6110538.0
2022-08-05 10:00:00	QQQ	ETF	320.75	323.83	320.37	322.96	4517049.0
2022-08-05 10:30:00	QQQ	ETF	322.96	323.0299	321.52	321.86	2345636.0
2022-08-05 11:00:00	QQQ	ETF	321.85	321.87	318.51	318.5115	3765332.0
2022-08-05 11:30:00	QQQ	ETF	318.52	319.82	318.39	319.3	3645867.0
2022-08-05 12:00:00	QQQ	ETF	319.31	320.49	319.26	320.38	2469632.0
2022-08-05 12:30:00	QQQ	ETF	320.38	321.2218	319.5	321.1401	1938165.0

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

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