PREVIEW / etf_5min / 2020-03-24

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-03-24.parquet
  size:    2.0 MB
  rows:    88,368

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-03-24 04:00:00	SPY	ETF	232.03	233.26	231.5	233.26	84612.0
2020-03-24 04:05:00	SPY	ETF	233.0	233.43	232.9	233.26	25640.0
2020-03-24 04:10:00	SPY	ETF	233.08	233.33	232.9	233.11	7409.0
2020-03-24 04:15:00	SPY	ETF	233.33	233.5	232.94	232.96	9174.0
2020-03-24 04:20:00	SPY	ETF	232.87	233.0	231.68	232.09	9806.0
2020-03-24 04:25:00	SPY	ETF	231.8	232.1	231.6	231.6	6789.0
2020-03-24 04:30:00	SPY	ETF	231.5	231.68	231.05	231.27	10144.0
2020-03-24 04:35:00	SPY	ETF	231.22	232.16	231.22	232.1	10931.0
2020-03-24 04:40:00	SPY	ETF	232.3	232.37	231.74	232.23	5839.0
2020-03-24 04:45:00	SPY	ETF	232.22	232.59	232.0	232.0	11391.0
2020-03-24 04:50:00	SPY	ETF	232.21	232.62	232.11	232.51	4880.0
2020-03-24 04:55:00	SPY	ETF	232.54	232.75	232.54	232.74	2530.0
2020-03-24 05:00:00	SPY	ETF	232.68	232.87	232.39	232.45	5629.0
2020-03-24 05:05:00	SPY	ETF	232.29	233.0	232.29	232.89	14074.0
2020-03-24 05:10:00	SPY	ETF	233.0	233.14	232.86	233.14	13923.0
2020-03-24 05:15:00	SPY	ETF	233.06	233.17	232.64	232.64	11323.0
2020-03-24 05:20:00	SPY	ETF	232.9	233.23	232.7	232.7	8323.0
2020-03-24 05:25:00	SPY	ETF	232.68	233.2	232.68	233.05	4597.0
2020-03-24 05:30:00	SPY	ETF	233.13	233.13	232.86	233.09	3171.0
2020-03-24 05:35:00	SPY	ETF	232.85	233.87	232.76	233.65	12294.0
2020-03-24 05:40:00	SPY	ETF	233.63	234.0	233.63	233.9	14908.0
2020-03-24 05:45:00	SPY	ETF	233.98	234.0	233.53	233.99	10981.0
2020-03-24 05:50:00	SPY	ETF	233.99	234.47	233.5	233.9	58766.0
2020-03-24 05:55:00	SPY	ETF	233.8	234.14	233.8	234.12	23217.0
2020-03-24 06:00:00	SPY	ETF	234.11	234.56	234.01	234.01	23456.0
2020-03-24 06:05:00	SPY	ETF	234.51	234.56	234.05	234.49	8524.0
2020-03-24 06:10:00	SPY	ETF	234.6	234.75	234.5	234.5	19119.0
2020-03-24 06:15:00	SPY	ETF	234.6	234.75	234.4	234.7	10957.0
2020-03-24 06:20:00	SPY	ETF	234.53	234.75	234.405	234.405	7681.0
2020-03-24 06:25:00	SPY	ETF	234.45	234.71	234.4	234.71	20772.0
2020-03-24 06:30:00	SPY	ETF	234.72	235.2	234.72	235.16	48545.0
2020-03-24 06:35:00	SPY	ETF	235.15	235.2	234.95	234.95	26288.0
2020-03-24 06:40:00	SPY	ETF	235.03	235.19	234.77	234.86	33261.0
2020-03-24 06:45:00	SPY	ETF	234.97	235.03	234.25	234.25	19719.0
2020-03-24 06:50:00	SPY	ETF	234.23	235.16	234.2	235.16	26464.0
2020-03-24 06:55:00	SPY	ETF	235.08	235.18	234.41	234.89	28993.0
2020-03-24 07:00:00	SPY	ETF	234.89	234.98	233.61	233.75	205398.0
2020-03-24 07:05:00	SPY	ETF	233.65	233.71	233.3	233.62	113413.0
2020-03-24 07:10:00	SPY	ETF	233.65	233.74	233.16	233.18	218583.0
2020-03-24 07:15:00	SPY	ETF	233.45	233.6	232.41	232.57	119171.0
2020-03-24 07:20:00	SPY	ETF	232.6	232.75	232.04	232.1	222867.0
2020-03-24 07:25:00	SPY	ETF	232.1	233.2	232.05	233.15	148416.0
2020-03-24 07:30:00	SPY	ETF	233.16	233.46	232.3	233.45	129968.0
2020-03-24 07:35:00	SPY	ETF	233.41	233.65	232.62	233.5	75874.0
2020-03-24 07:40:00	SPY	ETF	233.51	233.67	231.77	232.81	76739.0
2020-03-24 07:45:00	SPY	ETF	232.77	233.25	232.01	233.1	173467.0
2020-03-24 07:50:00	SPY	ETF	233.15	233.47	233.1	233.35	39609.0
2020-03-24 07:55:00	SPY	ETF	233.23	233.4	232.51	232.79	61965.0
2020-03-24 08:00:00	SPY	ETF	232.79	235.09	228.03	232.27	227212.0
2020-03-24 08:05:00	SPY	ETF	232.0	232.54	231.69	231.79	115105.0

> showing 50 of 88,368 rows — these rows as CSV

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