PREVIEW / etf_5min / 2022-08-29

all etf 5-min files

  file:    by_date/etf_5min/2022/2022-08-29.parquet
  size:    1.9 MB
  rows:    91,521

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-29 04:00:00	SPY	ETF	403.39	403.39	402.49	402.49	5386.0
2022-08-29 04:05:00	SPY	ETF	402.45	402.55	402.3	402.37	4877.0
2022-08-29 04:10:00	SPY	ETF	402.22	402.22	402.19	402.19	900.0
2022-08-29 04:15:00	SPY	ETF	402.2	402.59	402.11	402.59	9445.0
2022-08-29 04:20:00	SPY	ETF	402.57	402.75	402.32	402.32	5060.0
2022-08-29 04:25:00	SPY	ETF	402.11	402.22	402.11	402.11	6753.0
2022-08-29 04:30:00	SPY	ETF	402.25	402.27	402.02	402.1	3048.0
2022-08-29 04:35:00	SPY	ETF	401.9	402.08	401.9	402.05	1960.0
2022-08-29 04:40:00	SPY	ETF	401.68	401.98	401.68	401.98	1180.0
2022-08-29 04:45:00	SPY	ETF	402.05	402.27	402.05	402.21	2157.0
2022-08-29 04:50:00	SPY	ETF	402.1	402.1	401.76	401.77	4000.0
2022-08-29 04:55:00	SPY	ETF	401.69	401.85	401.31	401.32	5198.0
2022-08-29 05:00:00	SPY	ETF	401.31	401.42	401.21	401.23	4442.0
2022-08-29 05:05:00	SPY	ETF	401.21	401.62	401.2	401.62	9859.0
2022-08-29 05:10:00	SPY	ETF	401.57	401.9	401.57	401.9	9260.0
2022-08-29 05:15:00	SPY	ETF	401.88	401.89	401.73	401.79	730.0
2022-08-29 05:20:00	SPY	ETF	401.64	401.79	401.54	401.54	2060.0
2022-08-29 05:25:00	SPY	ETF	401.64	401.94	401.64	401.86	2200.0
2022-08-29 05:30:00	SPY	ETF	401.78	401.78	401.45	401.45	1225.0
2022-08-29 05:35:00	SPY	ETF	401.56	401.56	401.3	401.3	3950.0
2022-08-29 05:40:00	SPY	ETF	401.28	401.29	401.25	401.29	2300.0
2022-08-29 05:45:00	SPY	ETF	401.34	401.34	401.1	401.1	1559.0
2022-08-29 05:50:00	SPY	ETF	401.07	401.34	401.07	401.29	1009.0
2022-08-29 05:55:00	SPY	ETF	401.49	401.9	401.49	401.77	9059.0
2022-08-29 06:00:00	SPY	ETF	401.78	401.84	401.72	401.72	900.0
2022-08-29 06:05:00	SPY	ETF	401.73	401.73	401.63	401.71	10140.0
2022-08-29 06:10:00	SPY	ETF	401.64	401.76	401.32	401.32	11445.0
2022-08-29 06:15:00	SPY	ETF	401.39	401.65	401.38	401.63	3264.0
2022-08-29 06:20:00	SPY	ETF	401.6	401.82	401.6	401.8	2010.0
2022-08-29 06:25:00	SPY	ETF	401.82	401.82	401.45	401.45	15900.0
2022-08-29 06:30:00	SPY	ETF	401.65	402.05	401.65	402.05	11277.0
2022-08-29 06:35:00	SPY	ETF	401.95	402.06	401.8	401.87	5250.0
2022-08-29 06:40:00	SPY	ETF	401.94	401.99	401.9	401.9	1280.0
2022-08-29 06:45:00	SPY	ETF	402.04	402.05	401.96	401.99	2600.0
2022-08-29 06:50:00	SPY	ETF	402.04	402.08	401.85	401.99	2500.0
2022-08-29 06:55:00	SPY	ETF	402.06	402.06	401.47	401.54	4733.0
2022-08-29 07:00:00	SPY	ETF	401.49	401.66	401.36	401.4	23388.0
2022-08-29 07:05:00	SPY	ETF	401.36	401.37	401.05	401.1	22439.0
2022-08-29 07:10:00	SPY	ETF	401.12	401.37	401.02	401.37	31346.0
2022-08-29 07:15:00	SPY	ETF	401.35	401.44	401.16	401.16	71400.0
2022-08-29 07:20:00	SPY	ETF	401.26	401.5	401.15	401.5	24195.0
2022-08-29 07:25:00	SPY	ETF	401.48	401.49	401.19	401.28	20503.0
2022-08-29 07:30:00	SPY	ETF	401.24	401.5	401.15	401.24	33174.0
2022-08-29 07:35:00	SPY	ETF	401.21	401.52	401.19	401.46	26818.0
2022-08-29 07:40:00	SPY	ETF	401.5	401.59	401.34	401.39	7555.0
2022-08-29 07:45:00	SPY	ETF	401.4	401.71	401.4	401.7	29183.0
2022-08-29 07:50:00	SPY	ETF	401.77	401.79	401.48	401.48	44537.0
2022-08-29 07:55:00	SPY	ETF	401.58	401.82	401.58	401.82	68660.0
2022-08-29 08:00:00	SPY	ETF	401.21	403.13	401.02	401.7	114243.0
2022-08-29 08:05:00	SPY	ETF	401.72	401.85	401.6	401.6	55666.0

> showing 50 of 91,521 rows — these rows as CSV

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