PREVIEW / etf_5min / 2022-07-15

all etf 5-min files

  file:    by_date/etf_5min/2022/2022-07-15.parquet
  size:    1.8 MB
  rows:    89,741

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-07-15 04:00:00	SPY	ETF	378.14	378.14	377.6	377.6	6020.0
2022-07-15 04:05:00	SPY	ETF	377.65	377.81	377.59	377.81	1078.0
2022-07-15 04:10:00	SPY	ETF	377.65	377.67	377.65	377.67	1177.0
2022-07-15 04:20:00	SPY	ETF	377.69	377.69	377.61	377.64	332.0
2022-07-15 04:25:00	SPY	ETF	378.06	378.16	377.94	378.16	1700.0
2022-07-15 04:30:00	SPY	ETF	378.21	378.24	378.17	378.17	1738.0
2022-07-15 04:35:00	SPY	ETF	378.14	378.28	378.14	378.21	1601.0
2022-07-15 04:40:00	SPY	ETF	378.35	378.79	378.35	378.79	2360.0
2022-07-15 04:45:00	SPY	ETF	378.82	379.14	378.82	379.14	6963.0
2022-07-15 04:50:00	SPY	ETF	379.11	379.38	379.11	379.3	6038.0
2022-07-15 04:55:00	SPY	ETF	379.23	379.23	378.89	378.89	1750.0
2022-07-15 05:00:00	SPY	ETF	378.87	378.89	378.87	378.89	300.0
2022-07-15 05:05:00	SPY	ETF	379.25	379.27	379.24	379.24	300.0
2022-07-15 05:10:00	SPY	ETF	379.36	379.41	379.2	379.21	2191.0
2022-07-15 05:15:00	SPY	ETF	379.29	379.29	379.03	379.03	1050.0
2022-07-15 05:20:00	SPY	ETF	379.0	379.02	378.67	378.67	2920.0
2022-07-15 05:25:00	SPY	ETF	378.68	378.86	378.68	378.86	1200.0
2022-07-15 05:30:00	SPY	ETF	378.98	378.98	378.91	378.96	3850.0
2022-07-15 05:35:00	SPY	ETF	378.94	378.94	378.94	378.94	400.0
2022-07-15 05:40:00	SPY	ETF	378.93	378.93	378.93	378.93	200.0
2022-07-15 05:45:00	SPY	ETF	378.82	378.82	378.6	378.6	1481.0
2022-07-15 05:50:00	SPY	ETF	378.51	378.51	378.5	378.5	750.0
2022-07-15 05:55:00	SPY	ETF	378.64	378.81	378.57	378.66	2831.0
2022-07-15 06:00:00	SPY	ETF	378.38	378.43	378.38	378.43	240.0
2022-07-15 06:05:00	SPY	ETF	378.59	378.6	378.35	378.54	3449.0
2022-07-15 06:10:00	SPY	ETF	378.48	378.59	378.43	378.55	1700.0
2022-07-15 06:15:00	SPY	ETF	378.5	378.52	378.4	378.44	3030.0
2022-07-15 06:20:00	SPY	ETF	378.7	378.97	378.7	378.84	1958.0
2022-07-15 06:25:00	SPY	ETF	378.73	378.9	378.72	378.9	3695.0
2022-07-15 06:30:00	SPY	ETF	378.89	378.99	378.72	378.72	4230.0
2022-07-15 06:35:00	SPY	ETF	378.7	378.75	378.62	378.75	2500.0
2022-07-15 06:40:00	SPY	ETF	378.7	378.72	378.67	378.72	650.0
2022-07-15 06:45:00	SPY	ETF	378.72	379.0	378.72	379.0	1700.0
2022-07-15 06:50:00	SPY	ETF	378.97	379.06	378.91	378.94	13615.0
2022-07-15 06:55:00	SPY	ETF	378.9	378.97	378.85	378.85	1600.0
2022-07-15 07:00:00	SPY	ETF	378.87	379.15	378.85	379.15	7185.0
2022-07-15 07:05:00	SPY	ETF	379.07	379.2	379.0	379.09	15980.0
2022-07-15 07:10:00	SPY	ETF	379.11	379.32	379.0	379.32	11373.0
2022-07-15 07:15:00	SPY	ETF	379.27	379.27	379.12	379.12	7102.0
2022-07-15 07:20:00	SPY	ETF	379.13	379.49	379.1	379.36	7076.0
2022-07-15 07:25:00	SPY	ETF	379.33	379.5	379.31	379.32	18732.0
2022-07-15 07:30:00	SPY	ETF	379.37	379.48	379.32	379.46	5900.0
2022-07-15 07:35:00	SPY	ETF	379.44	379.49	379.21	379.21	8756.0
2022-07-15 07:40:00	SPY	ETF	379.21	379.21	378.98	379.0	23434.0
2022-07-15 07:45:00	SPY	ETF	378.98	379.14	378.91	379.14	5900.0
2022-07-15 07:50:00	SPY	ETF	379.14	379.14	378.99	379.01	1851.0
2022-07-15 07:55:00	SPY	ETF	379.0	379.0	378.7	378.7	6691.0
2022-07-15 08:00:00	SPY	ETF	378.89	379.5	377.0	379.0	69686.0
2022-07-15 08:05:00	SPY	ETF	378.63	378.8	378.56	378.69	9983.0
2022-07-15 08:10:00	SPY	ETF	378.7	378.7	378.49	378.65	13379.0

> showing 50 of 89,741 rows — these rows as CSV

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