PREVIEW / etf_5min / 2020-03-18

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-03-18.parquet
  size:    2.1 MB
  rows:    91,388

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-18 04:00:00	SPY	ETF	240.5	240.61	239.4	239.5	48367.0
2020-03-18 04:05:00	SPY	ETF	239.96	239.98	238.5	238.7	29243.0
2020-03-18 04:10:00	SPY	ETF	238.71	239.62	238.62	238.99	14874.0
2020-03-18 04:15:00	SPY	ETF	238.8	239.23	238.61	239.23	12497.0
2020-03-18 04:20:00	SPY	ETF	238.8	239.89	238.78	239.83	9829.0
2020-03-18 04:25:00	SPY	ETF	239.89	239.89	238.79	239.3	14434.0
2020-03-18 04:30:00	SPY	ETF	238.55	239.2	238.53	238.75	11207.0
2020-03-18 04:35:00	SPY	ETF	238.66	239.2	238.5	239.18	16675.0
2020-03-18 04:40:00	SPY	ETF	239.18	239.95	239.0	239.95	18372.0
2020-03-18 04:45:00	SPY	ETF	239.98	240.0	239.78	239.78	4087.0
2020-03-18 04:50:00	SPY	ETF	239.77	239.98	239.28	239.3	5890.0
2020-03-18 04:55:00	SPY	ETF	239.44	239.57	239.4	239.44	5370.0
2020-03-18 05:00:00	SPY	ETF	239.54	239.54	239.28	239.28	1801.0
2020-03-18 05:05:00	SPY	ETF	239.28	239.77	239.28	239.58	7913.0
2020-03-18 05:15:00	SPY	ETF	239.6	239.7	239.2	239.7	7369.0
2020-03-18 05:20:00	SPY	ETF	239.6	239.6	239.03	239.3	5680.0
2020-03-18 05:25:00	SPY	ETF	239.15	239.65	239.09	239.3	6675.0
2020-03-18 05:30:00	SPY	ETF	239.3	239.39	238.92	238.93	10686.0
2020-03-18 05:35:00	SPY	ETF	239.0	239.67	238.88	238.88	10974.0
2020-03-18 05:40:00	SPY	ETF	238.98	238.99	238.7	238.96	8873.0
2020-03-18 05:45:00	SPY	ETF	238.93	238.95	238.03	238.51	24422.0
2020-03-18 05:50:00	SPY	ETF	238.51	238.94	238.05	238.55	41767.0
2020-03-18 05:55:00	SPY	ETF	238.67	238.97	238.5	238.75	19534.0
2020-03-18 06:00:00	SPY	ETF	238.75	239.14	238.68	239.11	30026.0
2020-03-18 06:05:00	SPY	ETF	239.12	239.12	238.38	238.4	20588.0
2020-03-18 06:10:00	SPY	ETF	238.77	238.77	238.2	238.3	11113.0
2020-03-18 06:15:00	SPY	ETF	238.14	238.3	237.0	237.51	16546.0
2020-03-18 06:20:00	SPY	ETF	237.94	237.94	237.35	237.35	11900.0
2020-03-18 06:25:00	SPY	ETF	237.39	237.45	236.5	236.61	26217.0
2020-03-18 06:30:00	SPY	ETF	236.61	237.2	236.61	237.03	14297.0
2020-03-18 06:35:00	SPY	ETF	237.05	237.06	235.95	236.01	20921.0
2020-03-18 06:40:00	SPY	ETF	236.04	236.3	235.57	235.95	20625.0
2020-03-18 06:45:00	SPY	ETF	235.95	235.95	235.5	235.5	44929.0
2020-03-18 06:50:00	SPY	ETF	235.41	235.6	235.2	235.6	48077.0
2020-03-18 06:55:00	SPY	ETF	235.6	236.06	235.0	236.01	86119.0
2020-03-18 07:00:00	SPY	ETF	236.2	237.0	235.99	236.74	160451.0
2020-03-18 07:05:00	SPY	ETF	236.7	236.79	236.15	236.46	73857.0
2020-03-18 07:10:00	SPY	ETF	236.36	237.15	235.9	236.5	137452.0
2020-03-18 07:15:00	SPY	ETF	236.4	236.5	235.8	236.5	104991.0
2020-03-18 07:20:00	SPY	ETF	236.35	236.99	236.31	236.48	84584.0
2020-03-18 07:25:00	SPY	ETF	236.33	237.24	236.32	237.0	108171.0
2020-03-18 07:30:00	SPY	ETF	236.95	238.34	236.9	238.05	103426.0
2020-03-18 07:35:00	SPY	ETF	238.14	238.14	237.54	237.62	43894.0
2020-03-18 07:40:00	SPY	ETF	237.6	237.99	237.2	237.35	65862.0
2020-03-18 07:45:00	SPY	ETF	237.3	238.15	237.27	238.15	91081.0
2020-03-18 07:50:00	SPY	ETF	238.12	239.5	238.1	238.41	137656.0
2020-03-18 07:55:00	SPY	ETF	238.42	239.3	238.36	239.17	154068.0
2020-03-18 08:00:00	SPY	ETF	239.16	243.5	235.5	235.6	249166.0
2020-03-18 08:05:00	SPY	ETF	239.01	239.11	237.5	237.68	179192.0
2020-03-18 08:10:00	SPY	ETF	237.7	238.43	237.11	237.56	142712.0

> showing 50 of 91,388 rows — these rows as CSV

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