PREVIEW / etf_5min / 2020-10-23

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-10-23.parquet
  size:    1.5 MB
  rows:    68,295

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-10-23 04:00:00	SPY	ETF	345.42	345.65	345.42	345.65	1405.0
2020-10-23 04:05:00	SPY	ETF	345.8	345.83	345.6	345.6	3837.0
2020-10-23 04:10:00	SPY	ETF	345.88	345.88	345.85	345.85	696.0
2020-10-23 04:20:00	SPY	ETF	345.86	345.86	345.68	345.68	2870.0
2020-10-23 04:25:00	SPY	ETF	345.75	345.75	345.57	345.57	1107.0
2020-10-23 04:35:00	SPY	ETF	345.52	345.52	345.5	345.5	316.0
2020-10-23 04:45:00	SPY	ETF	345.53	345.53	345.48	345.48	200.0
2020-10-23 04:50:00	SPY	ETF	345.32	345.4	345.31	345.4	1100.0
2020-10-23 04:55:00	SPY	ETF	345.25	345.25	345.22	345.22	760.0
2020-10-23 05:00:00	SPY	ETF	345.26	345.26	345.15	345.15	2766.0
2020-10-23 05:05:00	SPY	ETF	345.18	345.18	345.18	345.18	500.0
2020-10-23 05:10:00	SPY	ETF	345.3	345.3	345.3	345.3	200.0
2020-10-23 05:15:00	SPY	ETF	345.49	345.62	345.48	345.62	2251.0
2020-10-23 05:20:00	SPY	ETF	345.83	345.83	345.83	345.83	400.0
2020-10-23 05:25:00	SPY	ETF	345.81	345.81	345.79	345.79	3056.0
2020-10-23 05:30:00	SPY	ETF	345.9	345.92	345.85	345.92	5890.0
2020-10-23 05:35:00	SPY	ETF	345.81	345.81	345.81	345.81	500.0
2020-10-23 05:40:00	SPY	ETF	345.81	345.81	345.55	345.55	1470.0
2020-10-23 05:45:00	SPY	ETF	345.52	345.52	345.52	345.52	100.0
2020-10-23 05:50:00	SPY	ETF	345.56	345.63	345.56	345.63	1810.0
2020-10-23 05:55:00	SPY	ETF	345.6	345.6	345.43	345.43	1545.0
2020-10-23 06:00:00	SPY	ETF	345.48	345.48	345.43	345.43	618.0
2020-10-23 06:05:00	SPY	ETF	345.41	345.46	345.24	345.46	4235.0
2020-10-23 06:10:00	SPY	ETF	345.56	345.58	345.56	345.58	1601.0
2020-10-23 06:20:00	SPY	ETF	345.56	345.6	345.41	345.41	4650.0
2020-10-23 06:25:00	SPY	ETF	345.4	345.4	345.34	345.34	10800.0
2020-10-23 06:30:00	SPY	ETF	345.44	345.58	345.44	345.58	450.0
2020-10-23 06:35:00	SPY	ETF	345.73	345.8	345.73	345.77	7295.0
2020-10-23 06:40:00	SPY	ETF	345.82	345.99	345.82	345.99	3246.0
2020-10-23 06:45:00	SPY	ETF	346.0	346.0	345.89	345.89	833.0
2020-10-23 06:50:00	SPY	ETF	345.9	345.9	345.79	345.83	1660.0
2020-10-23 06:55:00	SPY	ETF	345.87	345.87	345.74	345.74	851.0
2020-10-23 07:00:00	SPY	ETF	345.72	345.72	345.48	345.49	7138.0
2020-10-23 07:05:00	SPY	ETF	345.58	345.8	345.58	345.79	7657.0
2020-10-23 07:10:00	SPY	ETF	345.67	345.78	345.67	345.78	703.0
2020-10-23 07:15:00	SPY	ETF	345.78	345.8	345.6	345.64	32377.0
2020-10-23 07:20:00	SPY	ETF	345.63	345.63	345.5	345.56	5904.0
2020-10-23 07:25:00	SPY	ETF	345.64	345.71	345.56	345.56	8246.0
2020-10-23 07:30:00	SPY	ETF	345.64	345.81	345.63	345.81	2859.0
2020-10-23 07:35:00	SPY	ETF	345.7	345.95	345.7	345.8	9335.0
2020-10-23 07:40:00	SPY	ETF	345.95	346.12	345.95	346.08	19885.0
2020-10-23 07:45:00	SPY	ETF	346.08	346.1	345.79	345.88	7849.0
2020-10-23 07:50:00	SPY	ETF	345.81	345.89	345.77	345.87	6492.0
2020-10-23 07:55:00	SPY	ETF	345.93	345.93	345.88	345.88	3138.0
2020-10-23 08:00:00	SPY	ETF	345.54	346.09	344.1	345.087	22413.0
2020-10-23 08:05:00	SPY	ETF	345.8	345.81	345.74	345.81	12256.0
2020-10-23 08:10:00	SPY	ETF	345.87	345.94	345.77	345.94	9290.0
2020-10-23 08:15:00	SPY	ETF	345.99	346.12	345.96	346.12	14498.0
2020-10-23 08:20:00	SPY	ETF	346.094	346.094	345.88	345.88	13762.0
2020-10-23 08:25:00	SPY	ETF	345.91	346.04	345.9	345.99	11431.0

> showing 50 of 68,295 rows — these rows as CSV

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