PREVIEW / etf_5min / 2022-08-05

all etf 5-min files

  file:    by_date/etf_5min/2022/2022-08-05.parquet
  size:    1.8 MB
  rows:    88,936

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.54	414.69	1472.0
2022-08-05 04:10:00	SPY	ETF	414.68	414.68	414.68	414.68	100.0
2022-08-05 04:15:00	SPY	ETF	414.5	414.55	414.41	414.41	1293.0
2022-08-05 04:20:00	SPY	ETF	414.4	414.41	414.37	414.38	3400.0
2022-08-05 04:25:00	SPY	ETF	414.37	414.37	414.37	414.37	100.0
2022-08-05 04:35:00	SPY	ETF	414.19	414.19	414.19	414.19	138.0
2022-08-05 04:40:00	SPY	ETF	414.0	414.0	414.0	414.0	118.0
2022-08-05 04:45:00	SPY	ETF	414.02	414.02	414.02	414.02	190.0
2022-08-05 04:50:00	SPY	ETF	414.0	414.0	414.0	414.0	375.0
2022-08-05 04:55:00	SPY	ETF	414.06	414.06	414.04	414.04	200.0
2022-08-05 05:00:00	SPY	ETF	413.99	414.0	413.99	414.0	370.0
2022-08-05 05:05:00	SPY	ETF	414.09	414.09	414.0	414.0	410.0
2022-08-05 05:10:00	SPY	ETF	413.92	414.05	413.92	414.05	200.0
2022-08-05 05:15:00	SPY	ETF	414.07	414.25	414.07	414.23	3752.0
2022-08-05 05:20:00	SPY	ETF	414.26	414.31	414.26	414.31	500.0
2022-08-05 05:30:00	SPY	ETF	414.23	414.23	414.08	414.09	2310.0
2022-08-05 05:35:00	SPY	ETF	414.16	414.2	414.05	414.05	1207.0
2022-08-05 05:40:00	SPY	ETF	414.2	414.2	414.2	414.2	200.0
2022-08-05 05:45:00	SPY	ETF	414.03	414.03	413.95	414.02	1900.0
2022-08-05 05:50:00	SPY	ETF	414.17	414.21	414.14	414.21	598.0
2022-08-05 05:55:00	SPY	ETF	414.28	414.28	414.28	414.28	300.0
2022-08-05 06:00:00	SPY	ETF	414.12	414.12	413.99	413.99	3468.0
2022-08-05 06:05:00	SPY	ETF	413.97	414.13	413.88	414.13	6753.0
2022-08-05 06:10:00	SPY	ETF	414.11	414.11	414.11	414.11	100.0
2022-08-05 06:15:00	SPY	ETF	413.94	413.94	413.91	413.92	1100.0
2022-08-05 06:20:00	SPY	ETF	413.89	413.89	413.86	413.86	509.0
2022-08-05 06:25:00	SPY	ETF	413.99	414.06	413.99	414.06	2649.0
2022-08-05 06:30:00	SPY	ETF	414.01	414.01	413.79	413.85	4530.0
2022-08-05 06:35:00	SPY	ETF	413.96	413.96	413.96	413.96	400.0
2022-08-05 06:40:00	SPY	ETF	413.89	413.96	413.84	413.86	1613.0
2022-08-05 06:45:00	SPY	ETF	413.94	413.94	413.94	413.94	400.0
2022-08-05 06:50:00	SPY	ETF	414.09	414.09	414.02	414.02	600.0
2022-08-05 06:55:00	SPY	ETF	413.66	413.72	413.65	413.72	1524.0
2022-08-05 07:00:00	SPY	ETF	413.94	413.98	413.87	413.87	3637.0
2022-08-05 07:05:00	SPY	ETF	413.85	413.85	413.63	413.64	6579.0
2022-08-05 07:10:00	SPY	ETF	413.7	413.7	413.65	413.69	4599.0
2022-08-05 07:15:00	SPY	ETF	413.65	414.0	413.51	413.91	16948.0
2022-08-05 07:20:00	SPY	ETF	413.88	413.88	413.78	413.83	5810.0
2022-08-05 07:25:00	SPY	ETF	413.97	413.99	413.89	413.99	5531.0
2022-08-05 07:30:00	SPY	ETF	413.96	413.98	413.9	413.93	4557.0
2022-08-05 07:35:00	SPY	ETF	413.95	414.19	413.93	414.15	12319.0
2022-08-05 07:40:00	SPY	ETF	414.11	414.18	414.1	414.1	18307.0
2022-08-05 07:45:00	SPY	ETF	414.1	414.25	414.1	414.24	52269.0
2022-08-05 07:50:00	SPY	ETF	414.26	414.57	414.24	414.46	44295.0
2022-08-05 07:55:00	SPY	ETF	414.45	414.63	414.45	414.6	29667.0
2022-08-05 08:00:00	SPY	ETF	414.6	415.08	413.63	414.68	78042.0
2022-08-05 08:05:00	SPY	ETF	414.69	414.72	414.44	414.49	41874.0
2022-08-05 08:10:00	SPY	ETF	414.5	414.62	414.48	414.54	18254.0
2022-08-05 08:15:00	SPY	ETF	414.53	414.7	414.53	414.7	18455.0
2022-08-05 08:20:00	SPY	ETF	414.68	414.79	414.66	414.68	15600.0

> showing 50 of 88,936 rows — these rows as CSV

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