PREVIEW / etf_5min / 2021-07-16

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-07-16.parquet
  size:    1.7 MB
  rows:    79,113

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
2021-07-16 04:00:00	SPY	ETF	434.8	434.9	434.72	434.72	1299.0
2021-07-16 04:05:00	SPY	ETF	434.58	434.6	434.5	434.53	1809.0
2021-07-16 04:10:00	SPY	ETF	434.61	434.61	434.55	434.55	6500.0
2021-07-16 04:20:00	SPY	ETF	434.47	434.47	434.47	434.47	100.0
2021-07-16 04:30:00	SPY	ETF	434.73	434.73	434.73	434.73	100.0
2021-07-16 04:40:00	SPY	ETF	434.79	434.79	434.79	434.79	100.0
2021-07-16 04:45:00	SPY	ETF	434.8	434.86	434.8	434.86	300.0
2021-07-16 04:50:00	SPY	ETF	434.94	434.94	434.94	434.94	350.0
2021-07-16 04:55:00	SPY	ETF	435.06	435.06	435.05	435.05	200.0
2021-07-16 05:05:00	SPY	ETF	435.13	435.3	435.13	435.28	900.0
2021-07-16 05:10:00	SPY	ETF	435.32	435.37	435.25	435.25	2800.0
2021-07-16 05:15:00	SPY	ETF	435.3	435.3	435.3	435.3	1500.0
2021-07-16 05:20:00	SPY	ETF	435.37	435.37	435.29	435.29	1100.0
2021-07-16 05:25:00	SPY	ETF	435.29	435.29	435.19	435.19	2700.0
2021-07-16 05:30:00	SPY	ETF	435.13	435.15	435.13	435.15	1500.0
2021-07-16 05:35:00	SPY	ETF	435.15	435.15	435.15	435.15	300.0
2021-07-16 05:40:00	SPY	ETF	435.21	435.21	435.21	435.21	100.0
2021-07-16 05:45:00	SPY	ETF	435.19	435.21	435.19	435.2	800.0
2021-07-16 05:50:00	SPY	ETF	435.29	435.29	435.24	435.24	300.0
2021-07-16 05:55:00	SPY	ETF	435.0	435.25	435.0	435.25	948.0
2021-07-16 06:00:00	SPY	ETF	435.33	435.33	435.3	435.3	3387.0
2021-07-16 06:05:00	SPY	ETF	435.28	435.35	435.28	435.35	300.0
2021-07-16 06:10:00	SPY	ETF	434.92	434.92	434.83	434.83	500.0
2021-07-16 06:15:00	SPY	ETF	434.77	434.8	434.75	434.8	700.0
2021-07-16 06:20:00	SPY	ETF	434.78	434.9	434.72	434.9	900.0
2021-07-16 06:30:00	SPY	ETF	434.88	434.88	434.88	434.88	100.0
2021-07-16 06:35:00	SPY	ETF	434.89	434.97	434.89	434.95	53599.0
2021-07-16 06:40:00	SPY	ETF	435.2	435.2	435.2	435.2	500.0
2021-07-16 06:45:00	SPY	ETF	435.21	435.25	435.2	435.2	970.0
2021-07-16 06:50:00	SPY	ETF	435.2	435.2	435.18	435.19	4100.0
2021-07-16 06:55:00	SPY	ETF	435.23	435.23	435.23	435.23	381.0
2021-07-16 07:00:00	SPY	ETF	435.31	435.4	435.3	435.4	8120.0
2021-07-16 07:05:00	SPY	ETF	435.4	435.54	435.4	435.44	23526.0
2021-07-16 07:10:00	SPY	ETF	435.36	435.36	435.21	435.29	18242.0
2021-07-16 07:15:00	SPY	ETF	435.4	435.41	435.3	435.36	6370.0
2021-07-16 07:20:00	SPY	ETF	435.37	435.4	435.28	435.35	3035.0
2021-07-16 07:25:00	SPY	ETF	435.35	435.36	435.3	435.3	2522.0
2021-07-16 07:30:00	SPY	ETF	435.27	435.33	435.25	435.32	5919.0
2021-07-16 07:35:00	SPY	ETF	435.35	435.37	435.16	435.16	4437.0
2021-07-16 07:40:00	SPY	ETF	435.15	435.29	435.15	435.27	3803.0
2021-07-16 07:45:00	SPY	ETF	435.26	435.29	435.21	435.26	10047.0
2021-07-16 07:50:00	SPY	ETF	435.28	435.36	435.26	435.33	11539.0
2021-07-16 07:55:00	SPY	ETF	435.35	435.35	435.34	435.35	5983.0
2021-07-16 08:00:00	SPY	ETF	435.36	435.45	434.2	435.45	21948.0
2021-07-16 08:05:00	SPY	ETF	435.45	435.47	435.34	435.34	5430.0
2021-07-16 08:10:00	SPY	ETF	435.4	435.56	435.4	435.55	9145.0
2021-07-16 08:15:00	SPY	ETF	435.54	435.73	435.54	435.57	12829.0
2021-07-16 08:20:00	SPY	ETF	435.64	435.69	435.62	435.66	10575.0
2021-07-16 08:25:00	SPY	ETF	435.63	435.76	435.63	435.69	74018.0
2021-07-16 08:30:00	SPY	ETF	435.69	435.7	435.6	435.66	12869.0

> showing 50 of 79,113 rows — these rows as CSV

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