PREVIEW / etf_5min / 2020-06-18

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-06-18.parquet
  size:    1.5 MB
  rows:    70,887

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-18 04:00:00	SPY	ETF	311.56	311.6	311.15	311.5	10188.0
2020-06-18 04:05:00	SPY	ETF	311.67	312.2	311.56	312.02	8252.0
2020-06-18 04:10:00	SPY	ETF	311.98	312.0	311.31	311.36	14935.0
2020-06-18 04:15:00	SPY	ETF	311.32	311.4	311.24	311.35	2470.0
2020-06-18 04:20:00	SPY	ETF	311.37	311.81	311.16	311.75	7902.0
2020-06-18 04:25:00	SPY	ETF	311.62	311.97	311.56	311.57	1765.0
2020-06-18 04:30:00	SPY	ETF	311.51	312.8	311.41	312.61	15889.0
2020-06-18 04:35:00	SPY	ETF	312.65	313.21	312.63	312.68	27150.0
2020-06-18 04:40:00	SPY	ETF	312.62	312.87	312.61	312.83	1677.0
2020-06-18 04:45:00	SPY	ETF	312.75	312.86	312.63	312.69	6468.0
2020-06-18 04:50:00	SPY	ETF	312.58	312.77	312.44	312.6	1585.0
2020-06-18 04:55:00	SPY	ETF	312.54	312.98	312.54	312.9	3647.0
2020-06-18 05:00:00	SPY	ETF	312.72	312.91	312.26	312.26	15461.0
2020-06-18 05:05:00	SPY	ETF	312.33	312.34	312.18	312.18	8551.0
2020-06-18 05:10:00	SPY	ETF	312.33	312.34	312.16	312.31	7055.0
2020-06-18 05:15:00	SPY	ETF	312.31	312.76	312.31	312.76	11881.0
2020-06-18 05:20:00	SPY	ETF	312.69	312.74	312.69	312.7	433.0
2020-06-18 05:25:00	SPY	ETF	312.64	312.64	312.52	312.56	4931.0
2020-06-18 05:30:00	SPY	ETF	312.56	313.29	312.52	312.54	15924.0
2020-06-18 05:35:00	SPY	ETF	312.31	312.41	311.96	311.96	6089.0
2020-06-18 05:40:00	SPY	ETF	312.05	312.05	311.99	312.02	2064.0
2020-06-18 05:45:00	SPY	ETF	312.14	312.51	312.14	312.34	9161.0
2020-06-18 05:50:00	SPY	ETF	312.25	312.25	312.09	312.09	421.0
2020-06-18 05:55:00	SPY	ETF	312.14	312.28	311.99	312.26	3365.0
2020-06-18 06:00:00	SPY	ETF	312.17	312.17	311.56	311.68	7637.0
2020-06-18 06:05:00	SPY	ETF	311.66	311.66	311.36	311.43	3599.0
2020-06-18 06:10:00	SPY	ETF	311.44	311.46	311.29	311.35	2447.0
2020-06-18 06:15:00	SPY	ETF	311.51	311.81	311.49	311.71	11563.0
2020-06-18 06:20:00	SPY	ETF	311.79	311.79	311.59	311.62	1538.0
2020-06-18 06:25:00	SPY	ETF	311.59	312.07	311.59	312.07	5045.0
2020-06-18 06:30:00	SPY	ETF	311.88	311.93	311.7	311.7	2680.0
2020-06-18 06:35:00	SPY	ETF	311.71	311.71	311.64	311.64	200.0
2020-06-18 06:40:00	SPY	ETF	311.66	311.67	311.64	311.66	3828.0
2020-06-18 06:45:00	SPY	ETF	311.9	311.96	311.8	311.96	3290.0
2020-06-18 06:50:00	SPY	ETF	311.99	311.99	311.51	311.54	7824.0
2020-06-18 06:55:00	SPY	ETF	311.66	311.74	311.66	311.73	4154.0
2020-06-18 07:00:00	SPY	ETF	311.68	311.94	311.58	311.65	15636.0
2020-06-18 07:05:00	SPY	ETF	311.65	311.65	310.86	311.11	69007.0
2020-06-18 07:10:00	SPY	ETF	311.09	311.09	310.66	310.98	40352.0
2020-06-18 07:15:00	SPY	ETF	310.98	311.08	310.65	310.87	40414.0
2020-06-18 07:20:00	SPY	ETF	310.82	310.82	310.38	310.5	39163.0
2020-06-18 07:25:00	SPY	ETF	310.52	310.8	310.52	310.78	58908.0
2020-06-18 07:30:00	SPY	ETF	310.78	310.9	310.65	310.65	37334.0
2020-06-18 07:35:00	SPY	ETF	310.57	310.62	310.26	310.57	55528.0
2020-06-18 07:40:00	SPY	ETF	310.66	310.68	310.47	310.53	12304.0
2020-06-18 07:45:00	SPY	ETF	310.53	310.53	310.01	310.19	49569.0
2020-06-18 07:50:00	SPY	ETF	310.22	310.24	309.88	309.88	92993.0
2020-06-18 07:55:00	SPY	ETF	309.87	309.91	309.47	309.56	85926.0
2020-06-18 08:00:00	SPY	ETF	310.7801	311.94	308.95	309.15	419911.0
2020-06-18 08:05:00	SPY	ETF	309.14	309.2	308.85	309.135	96485.0

> showing 50 of 70,887 rows — these rows as CSV

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