PREVIEW / etf_5min / 2020-06-04

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-06-04.parquet
  size:    1.7 MB
  rows:    76,651

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
2020-06-04 04:00:00	SPY	ETF	311.5	311.5	311.1	311.1	14592.0
2020-06-04 04:05:00	SPY	ETF	311.12	311.45	311.05	311.34	10671.0
2020-06-04 04:10:00	SPY	ETF	311.37	311.57	311.23	311.23	4411.0
2020-06-04 04:15:00	SPY	ETF	311.22	311.24	311.22	311.22	2597.0
2020-06-04 04:20:00	SPY	ETF	311.3	311.39	311.28	311.28	1581.0
2020-06-04 04:25:00	SPY	ETF	311.32	311.32	311.12	311.17	2420.0
2020-06-04 04:30:00	SPY	ETF	311.22	311.22	311.2	311.2	371.0
2020-06-04 04:35:00	SPY	ETF	311.15	311.15	311.0	311.0	2867.0
2020-06-04 04:40:00	SPY	ETF	311.0	311.1	310.98	311.1	1968.0
2020-06-04 04:45:00	SPY	ETF	311.03	311.03	310.97	310.97	723.0
2020-06-04 04:50:00	SPY	ETF	311.0	311.0	311.0	311.0	330.0
2020-06-04 04:55:00	SPY	ETF	311.02	311.05	310.95	310.95	1796.0
2020-06-04 05:00:00	SPY	ETF	310.95	310.95	310.86	310.9	3049.0
2020-06-04 05:05:00	SPY	ETF	310.86	310.98	310.86	310.98	3108.0
2020-06-04 05:10:00	SPY	ETF	310.93	311.05	310.93	310.95	4666.0
2020-06-04 05:15:00	SPY	ETF	310.86	310.91	310.85	310.91	1594.0
2020-06-04 05:20:00	SPY	ETF	310.9	310.9	310.55	310.55	6723.0
2020-06-04 05:25:00	SPY	ETF	310.68	310.68	310.46	310.48	8642.0
2020-06-04 05:30:00	SPY	ETF	310.48	310.5	310.46	310.5	5351.0
2020-06-04 05:35:00	SPY	ETF	310.56	310.56	310.45	310.56	8263.0
2020-06-04 05:40:00	SPY	ETF	310.6	310.6	310.43	310.48	6075.0
2020-06-04 05:45:00	SPY	ETF	310.46	310.46	310.37	310.38	4285.0
2020-06-04 05:50:00	SPY	ETF	310.37	310.46	310.33	310.33	6823.0
2020-06-04 05:55:00	SPY	ETF	310.39	310.41	310.31	310.36	4488.0
2020-06-04 06:00:00	SPY	ETF	310.31	310.42	310.3	310.42	10351.0
2020-06-04 06:05:00	SPY	ETF	310.46	310.46	310.32	310.32	7012.0
2020-06-04 06:10:00	SPY	ETF	310.34	310.46	310.31	310.38	12962.0
2020-06-04 06:15:00	SPY	ETF	310.4	310.58	310.4	310.56	6387.0
2020-06-04 06:20:00	SPY	ETF	310.56	310.59	310.54	310.59	8781.0
2020-06-04 06:25:00	SPY	ETF	310.6	310.62	310.55	310.62	875.0
2020-06-04 06:30:00	SPY	ETF	310.63	310.68	310.6	310.6	9346.0
2020-06-04 06:35:00	SPY	ETF	310.55	310.61	310.54	310.54	2063.0
2020-06-04 06:40:00	SPY	ETF	310.59	310.59	310.46	310.52	11391.0
2020-06-04 06:45:00	SPY	ETF	310.4	310.4	310.26	310.3	17335.0
2020-06-04 06:50:00	SPY	ETF	310.33	310.39	310.31	310.35	10502.0
2020-06-04 06:55:00	SPY	ETF	310.37	310.7	310.37	310.7	44036.0
2020-06-04 07:00:00	SPY	ETF	310.66	310.83	310.55	310.62	75324.0
2020-06-04 07:05:00	SPY	ETF	310.66	310.81	310.66	310.71	42430.0
2020-06-04 07:10:00	SPY	ETF	310.69	310.79	310.65	310.78	50882.0
2020-06-04 07:15:00	SPY	ETF	310.84	310.84	310.7	310.76	45870.0
2020-06-04 07:20:00	SPY	ETF	310.77	310.8	310.65	310.73	25695.0
2020-06-04 07:25:00	SPY	ETF	310.75	310.83	310.72	310.81	27787.0
2020-06-04 07:30:00	SPY	ETF	310.8	310.88	310.73	310.73	39589.0
2020-06-04 07:35:00	SPY	ETF	310.76	310.83	310.58	310.58	40558.0
2020-06-04 07:40:00	SPY	ETF	310.61	310.61	310.42	310.48	71380.0
2020-06-04 07:45:00	SPY	ETF	310.5	311.31	310.5	311.1	459402.0
2020-06-04 07:50:00	SPY	ETF	311.11	311.5	310.99	311.48	163501.0
2020-06-04 07:55:00	SPY	ETF	311.47	311.63	311.28	311.33	138487.0
2020-06-04 08:00:00	SPY	ETF	310.66	311.75	310.3396	311.23	148198.0
2020-06-04 08:05:00	SPY	ETF	311.21	311.47	311.2	311.32	76890.0

> showing 50 of 76,651 rows — these rows as CSV

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