PREVIEW / etf_5min / 2022-05-20

all etf 5-min files

  file:    by_date/etf_5min/2022/2022-05-20.parquet
  size:    2.1 MB
  rows:    100,416

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-05-20 04:00:00	SPY	ETF	389.5	393.5	389.5	393.21	13491.0
2022-05-20 04:05:00	SPY	ETF	393.33	393.4	393.12	393.3	3099.0
2022-05-20 04:10:00	SPY	ETF	393.32	393.36	392.75	392.93	4798.0
2022-05-20 04:15:00	SPY	ETF	393.1	393.1	392.91	393.09	1682.0
2022-05-20 04:20:00	SPY	ETF	393.36	393.39	393.28	393.38	1118.0
2022-05-20 04:25:00	SPY	ETF	393.35	393.66	393.3	393.66	4260.0
2022-05-20 04:30:00	SPY	ETF	393.8	394.1	393.8	394.1	3500.0
2022-05-20 04:35:00	SPY	ETF	394.04	394.07	393.83	393.9	11100.0
2022-05-20 04:40:00	SPY	ETF	394.07	394.32	394.07	394.25	11149.0
2022-05-20 04:45:00	SPY	ETF	394.3	394.32	393.97	393.97	1894.0
2022-05-20 04:50:00	SPY	ETF	393.84	393.96	393.84	393.95	500.0
2022-05-20 04:55:00	SPY	ETF	393.81	393.96	393.81	393.9	1491.0
2022-05-20 05:00:00	SPY	ETF	393.7	393.92	393.67	393.92	1516.0
2022-05-20 05:10:00	SPY	ETF	394.13	394.5	394.12	394.5	6600.0
2022-05-20 05:15:00	SPY	ETF	394.45	394.66	394.45	394.56	700.0
2022-05-20 05:20:00	SPY	ETF	394.55	394.55	394.2	394.21	3799.0
2022-05-20 05:25:00	SPY	ETF	394.17	394.33	394.17	394.31	2315.0
2022-05-20 05:30:00	SPY	ETF	394.23	394.28	394.1	394.15	1702.0
2022-05-20 05:35:00	SPY	ETF	394.02	394.02	393.97	393.97	8823.0
2022-05-20 05:40:00	SPY	ETF	393.73	393.73	393.63	393.63	352.0
2022-05-20 05:45:00	SPY	ETF	393.56	393.68	393.5	393.68	2375.0
2022-05-20 05:55:00	SPY	ETF	393.77	393.85	393.74	393.74	845.0
2022-05-20 06:00:00	SPY	ETF	393.6	393.75	393.6	393.75	1199.0
2022-05-20 06:05:00	SPY	ETF	393.81	393.89	393.81	393.89	1420.0
2022-05-20 06:10:00	SPY	ETF	393.98	394.08	393.93	393.97	2212.0
2022-05-20 06:15:00	SPY	ETF	393.56	393.82	393.56	393.82	2650.0
2022-05-20 06:20:00	SPY	ETF	393.77	394.1	393.77	394.1	2429.0
2022-05-20 06:25:00	SPY	ETF	394.08	394.1	394.05	394.05	1789.0
2022-05-20 06:30:00	SPY	ETF	393.92	394.0	393.9	393.93	16226.0
2022-05-20 06:35:00	SPY	ETF	393.9	393.9	393.7	393.7	36881.0
2022-05-20 06:40:00	SPY	ETF	393.92	393.92	393.8	393.83	1450.0
2022-05-20 06:45:00	SPY	ETF	393.96	394.0	393.9	393.9	3040.0
2022-05-20 06:50:00	SPY	ETF	393.85	393.85	393.52	393.52	3241.0
2022-05-20 06:55:00	SPY	ETF	393.68	393.77	393.57	393.57	1950.0
2022-05-20 07:00:00	SPY	ETF	393.66	393.67	393.36	393.57	24851.0
2022-05-20 07:05:00	SPY	ETF	393.57	393.57	392.63	393.22	136490.0
2022-05-20 07:10:00	SPY	ETF	393.2	393.41	393.15	393.38	26586.0
2022-05-20 07:15:00	SPY	ETF	393.41	393.66	393.41	393.52	9281.0
2022-05-20 07:20:00	SPY	ETF	393.54	393.69	393.38	393.43	2928.0
2022-05-20 07:25:00	SPY	ETF	393.43	393.46	393.28	393.37	8080.0
2022-05-20 07:30:00	SPY	ETF	393.39	393.81	393.39	393.75	32904.0
2022-05-20 07:35:00	SPY	ETF	393.75	393.77	393.65	393.65	19043.0
2022-05-20 07:40:00	SPY	ETF	393.65	393.78	393.46	393.66	20458.0
2022-05-20 07:45:00	SPY	ETF	393.74	393.87	393.65	393.87	13726.0
2022-05-20 07:50:00	SPY	ETF	393.88	394.47	393.88	394.47	15212.0
2022-05-20 07:55:00	SPY	ETF	394.45	394.57	393.98	393.98	34431.0
2022-05-20 08:00:00	SPY	ETF	394.58	394.58	391.6	393.92	210478.0
2022-05-20 08:05:00	SPY	ETF	394.0	394.15	393.89	393.9	53250.0
2022-05-20 08:10:00	SPY	ETF	393.92	393.93	393.6	393.6	15822.0
2022-05-20 08:15:00	SPY	ETF	393.63	393.76	393.56	393.63	32136.0

> showing 50 of 100,416 rows — these rows as CSV

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