PREVIEW / etf_5min / 2021-07-02

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-07-02.parquet
  size:    1.7 MB
  rows:    77,543

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-02 04:00:00	SPY	ETF	430.54	431.0	430.54	431.0	500.0
2021-07-02 04:05:00	SPY	ETF	430.99	430.99	430.94	430.94	200.0
2021-07-02 04:10:00	SPY	ETF	430.87	430.87	430.76	430.76	700.0
2021-07-02 04:25:00	SPY	ETF	430.58	430.58	430.58	430.58	100.0
2021-07-02 04:30:00	SPY	ETF	430.57	430.58	430.57	430.57	367.0
2021-07-02 04:40:00	SPY	ETF	430.51	430.51	430.51	430.51	200.0
2021-07-02 04:45:00	SPY	ETF	430.38	430.45	430.38	430.45	800.0
2021-07-02 04:50:00	SPY	ETF	430.47	430.47	430.47	430.47	100.0
2021-07-02 05:00:00	SPY	ETF	430.53	430.53	430.53	430.53	200.0
2021-07-02 05:15:00	SPY	ETF	430.6	430.7	430.6	430.69	3000.0
2021-07-02 05:20:00	SPY	ETF	430.7	430.7	430.6	430.6	1200.0
2021-07-02 05:25:00	SPY	ETF	430.53	430.56	430.53	430.56	400.0
2021-07-02 05:30:00	SPY	ETF	430.59	430.59	430.49	430.49	700.0
2021-07-02 05:40:00	SPY	ETF	430.65	430.66	430.65	430.66	600.0
2021-07-02 05:45:00	SPY	ETF	430.71	430.71	430.71	430.71	500.0
2021-07-02 05:50:00	SPY	ETF	430.76	430.78	430.63	430.63	1200.0
2021-07-02 05:55:00	SPY	ETF	430.67	430.67	430.67	430.67	100.0
2021-07-02 06:05:00	SPY	ETF	430.78	430.86	430.77	430.86	1000.0
2021-07-02 06:10:00	SPY	ETF	430.87	430.87	430.73	430.78	2153.0
2021-07-02 06:15:00	SPY	ETF	430.8	430.81	430.76	430.81	3256.0
2021-07-02 06:20:00	SPY	ETF	430.76	430.76	430.72	430.72	500.0
2021-07-02 06:25:00	SPY	ETF	430.66	430.66	430.66	430.66	100.0
2021-07-02 06:30:00	SPY	ETF	430.66	430.66	430.55	430.55	1000.0
2021-07-02 06:35:00	SPY	ETF	430.59	430.61	430.58	430.58	2800.0
2021-07-02 06:40:00	SPY	ETF	430.6	430.6	430.6	430.6	100.0
2021-07-02 06:45:00	SPY	ETF	430.61	430.61	430.57	430.57	600.0
2021-07-02 06:50:00	SPY	ETF	430.61	430.71	430.61	430.71	200.0
2021-07-02 06:55:00	SPY	ETF	430.72	430.74	430.72	430.72	6294.0
2021-07-02 07:00:00	SPY	ETF	430.8	430.85	430.79	430.85	1350.0
2021-07-02 07:05:00	SPY	ETF	430.85	430.88	430.85	430.87	10935.0
2021-07-02 07:10:00	SPY	ETF	430.87	430.87	430.8	430.8	4008.0
2021-07-02 07:15:00	SPY	ETF	430.85	430.93	430.84	430.84	2463.0
2021-07-02 07:20:00	SPY	ETF	430.841	430.93	430.84	430.93	1205.0
2021-07-02 07:25:00	SPY	ETF	430.93	430.98	430.93	430.95	3339.0
2021-07-02 07:30:00	SPY	ETF	430.96	431.02	430.96	431.0	4165.0
2021-07-02 07:35:00	SPY	ETF	430.97	431.0	430.94	430.97	2847.0
2021-07-02 07:40:00	SPY	ETF	430.93	430.98	430.91	430.95	20056.0
2021-07-02 07:45:00	SPY	ETF	430.97	431.0	430.92	431.0	8134.0
2021-07-02 07:50:00	SPY	ETF	431.0	431.02	430.93	430.93	12691.0
2021-07-02 07:55:00	SPY	ETF	430.99	430.99	430.94	430.94	8574.0
2021-07-02 08:00:00	SPY	ETF	430.8801	431.1	430.61	431.02	20183.0
2021-07-02 08:05:00	SPY	ETF	430.98	430.98	430.5	430.94	80863.0
2021-07-02 08:10:00	SPY	ETF	430.94	430.94	430.77	430.77	85402.0
2021-07-02 08:15:00	SPY	ETF	430.8	430.94	430.8	430.93	55242.0
2021-07-02 08:20:00	SPY	ETF	430.9	430.9	430.78	430.84	20377.0
2021-07-02 08:25:00	SPY	ETF	430.84	431.01	430.84	430.92	21086.0
2021-07-02 08:30:00	SPY	ETF	430.87	431.76	430.8	431.68	255679.0
2021-07-02 08:35:00	SPY	ETF	431.65	431.75	431.4	431.52	124987.0
2021-07-02 08:40:00	SPY	ETF	431.51	431.88	430.75	431.8	50054.0
2021-07-02 08:45:00	SPY	ETF	431.75	431.86	431.68	431.7	30112.0

> showing 50 of 77,543 rows — these rows as CSV

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