PREVIEW / etf_5min / 2022-08-09

all etf 5-min files

  file:    by_date/etf_5min/2022/2022-08-09.parquet
  size:    1.8 MB
  rows:    86,803

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-09 04:00:00	SPY	ETF	413.51	413.56	413.51	413.52	679.0
2022-08-09 04:05:00	SPY	ETF	413.54	413.54	413.14	413.19	1296.0
2022-08-09 04:10:00	SPY	ETF	413.2	413.22	413.2	413.22	1244.0
2022-08-09 04:15:00	SPY	ETF	413.26	413.26	413.26	413.26	100.0
2022-08-09 04:20:00	SPY	ETF	413.5	413.7	413.5	413.7	380.0
2022-08-09 04:25:00	SPY	ETF	413.66	413.66	413.58	413.58	200.0
2022-08-09 04:30:00	SPY	ETF	413.67	413.71	413.62	413.71	699.0
2022-08-09 04:35:00	SPY	ETF	413.8	413.8	413.8	413.8	300.0
2022-08-09 04:45:00	SPY	ETF	413.69	413.69	413.69	413.69	200.0
2022-08-09 04:50:00	SPY	ETF	413.5	413.5	413.5	413.5	1000.0
2022-08-09 04:55:00	SPY	ETF	413.62	413.65	413.62	413.65	254.0
2022-08-09 05:00:00	SPY	ETF	413.65	413.83	413.65	413.83	1446.0
2022-08-09 05:05:00	SPY	ETF	413.91	413.91	413.91	413.91	101.0
2022-08-09 05:10:00	SPY	ETF	413.8	413.85	413.8	413.85	2100.0
2022-08-09 05:20:00	SPY	ETF	413.71	413.71	413.69	413.71	2200.0
2022-08-09 05:25:00	SPY	ETF	413.64	413.64	413.59	413.59	700.0
2022-08-09 05:30:00	SPY	ETF	413.47	413.51	413.44	413.51	1250.0
2022-08-09 05:35:00	SPY	ETF	413.5	413.5	413.5	413.5	200.0
2022-08-09 05:40:00	SPY	ETF	413.5	413.51	413.5	413.51	600.0
2022-08-09 05:45:00	SPY	ETF	413.42	413.63	413.42	413.63	2700.0
2022-08-09 05:50:00	SPY	ETF	413.65	413.65	413.52	413.52	300.0
2022-08-09 06:05:00	SPY	ETF	413.28	413.28	413.25	413.25	200.0
2022-08-09 06:10:00	SPY	ETF	413.01	413.01	412.58	412.58	11206.0
2022-08-09 06:15:00	SPY	ETF	412.54	412.59	412.4	412.59	21093.0
2022-08-09 06:20:00	SPY	ETF	412.55	412.55	412.37	412.39	3100.0
2022-08-09 06:25:00	SPY	ETF	412.32	412.46	412.24	412.31	2800.0
2022-08-09 06:30:00	SPY	ETF	412.31	412.31	412.21	412.22	1115.0
2022-08-09 06:35:00	SPY	ETF	412.25	412.26	412.07	412.25	3220.0
2022-08-09 06:40:00	SPY	ETF	412.38	412.42	412.33	412.33	891.0
2022-08-09 06:45:00	SPY	ETF	412.23	412.23	412.0	412.07	2280.0
2022-08-09 06:50:00	SPY	ETF	412.02	412.16	412.0	412.13	11993.0
2022-08-09 06:55:00	SPY	ETF	412.11	412.23	412.11	412.23	850.0
2022-08-09 07:00:00	SPY	ETF	412.36	412.66	412.32	412.6	12327.0
2022-08-09 07:05:00	SPY	ETF	412.57	412.57	412.45	412.45	7541.0
2022-08-09 07:10:00	SPY	ETF	412.5	412.64	412.48	412.56	3911.0
2022-08-09 07:15:00	SPY	ETF	412.55	412.6	412.47	412.48	3848.0
2022-08-09 07:20:00	SPY	ETF	412.54	412.55	412.34	412.4	11165.0
2022-08-09 07:25:00	SPY	ETF	412.33	412.34	412.02	412.15	18070.0
2022-08-09 07:30:00	SPY	ETF	412.1	412.27	411.98	412.26	6111.0
2022-08-09 07:35:00	SPY	ETF	412.39	412.39	412.1	412.17	8545.0
2022-08-09 07:40:00	SPY	ETF	412.14	412.14	411.41	411.44	28785.0
2022-08-09 07:45:00	SPY	ETF	411.43	411.61	411.43	411.61	21139.0
2022-08-09 07:50:00	SPY	ETF	411.56	411.72	411.52	411.72	23138.0
2022-08-09 07:55:00	SPY	ETF	411.64	411.74	411.59	411.59	2518.0
2022-08-09 08:00:00	SPY	ETF	412.0499	413.85	411.45	411.74	40980.0
2022-08-09 08:05:00	SPY	ETF	411.74	411.74	411.45	411.47	33349.0
2022-08-09 08:10:00	SPY	ETF	411.49	411.54	411.28	411.49	8261.0
2022-08-09 08:15:00	SPY	ETF	411.5	411.76	411.5	411.7	12347.0
2022-08-09 08:20:00	SPY	ETF	411.75	412.14	411.75	412.04	25059.0
2022-08-09 08:25:00	SPY	ETF	412.04	412.11	412.0	412.01	66175.0

> showing 50 of 86,803 rows — these rows as CSV

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