PREVIEW / etf_5min / 2020-05-21

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-05-21.parquet
  size:    1.5 MB
  rows:    72,886

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-05-21 04:00:00	SPY	ETF	295.66	295.72	295.34	295.62	18523.0
2020-05-21 04:05:00	SPY	ETF	295.52	295.52	294.91	294.91	22837.0
2020-05-21 04:10:00	SPY	ETF	294.91	295.01	294.85	294.9	6786.0
2020-05-21 04:15:00	SPY	ETF	294.94	294.94	294.77	294.89	9143.0
2020-05-21 04:20:00	SPY	ETF	294.87	294.99	294.87	294.99	5533.0
2020-05-21 04:25:00	SPY	ETF	294.86	294.87	294.64	294.83	9101.0
2020-05-21 04:30:00	SPY	ETF	294.83	295.0	294.83	294.9	5996.0
2020-05-21 04:35:00	SPY	ETF	294.98	295.13	294.98	295.11	610.0
2020-05-21 04:40:00	SPY	ETF	295.08	295.4	295.08	295.39	4920.0
2020-05-21 04:45:00	SPY	ETF	295.38	295.42	295.31	295.31	2510.0
2020-05-21 04:50:00	SPY	ETF	295.5	295.5	295.5	295.5	520.0
2020-05-21 04:55:00	SPY	ETF	295.65	295.65	295.5	295.53	2881.0
2020-05-21 05:00:00	SPY	ETF	295.68	295.79	295.59	295.66	6626.0
2020-05-21 05:05:00	SPY	ETF	295.51	295.51	295.3	295.36	24825.0
2020-05-21 05:10:00	SPY	ETF	295.32	295.34	295.25	295.25	3158.0
2020-05-21 05:15:00	SPY	ETF	295.3	295.3	295.23	295.24	2503.0
2020-05-21 05:20:00	SPY	ETF	295.1	295.23	295.07	295.11	2117.0
2020-05-21 05:25:00	SPY	ETF	295.5	295.63	295.5	295.55	1675.0
2020-05-21 05:30:00	SPY	ETF	295.48	295.51	295.28	295.3	1601.0
2020-05-21 05:35:00	SPY	ETF	295.23	295.44	295.23	295.31	1226.0
2020-05-21 05:40:00	SPY	ETF	295.35	295.35	295.35	295.35	100.0
2020-05-21 05:45:00	SPY	ETF	295.22	295.41	295.22	295.24	2320.0
2020-05-21 05:50:00	SPY	ETF	295.19	295.2	295.15	295.2	1400.0
2020-05-21 05:55:00	SPY	ETF	295.33	295.33	295.0	295.0	1831.0
2020-05-21 06:00:00	SPY	ETF	294.98	294.99	294.77	294.91	6532.0
2020-05-21 06:05:00	SPY	ETF	295.06	295.06	294.94	294.98	2351.0
2020-05-21 06:10:00	SPY	ETF	294.91	295.5	294.8	295.5	21187.0
2020-05-21 06:15:00	SPY	ETF	295.33	295.42	295.25	295.42	6365.0
2020-05-21 06:20:00	SPY	ETF	295.39	295.42	295.36	295.42	2356.0
2020-05-21 06:25:00	SPY	ETF	295.27	295.66	295.26	295.61	15982.0
2020-05-21 06:30:00	SPY	ETF	295.52	295.56	295.5	295.55	1356.0
2020-05-21 06:35:00	SPY	ETF	295.39	295.57	295.39	295.55	5569.0
2020-05-21 06:40:00	SPY	ETF	295.54	295.57	295.36	295.42	8547.0
2020-05-21 06:45:00	SPY	ETF	295.35	295.49	295.31	295.35	10684.0
2020-05-21 06:50:00	SPY	ETF	295.48	295.58	295.46	295.47	6195.0
2020-05-21 06:55:00	SPY	ETF	295.41	295.45	295.36	295.44	8830.0
2020-05-21 07:00:00	SPY	ETF	295.47	295.6	295.47	295.6	29449.0
2020-05-21 07:05:00	SPY	ETF	295.57	295.73	295.55	295.7	86195.0
2020-05-21 07:10:00	SPY	ETF	295.67	295.8	295.61	295.7	48181.0
2020-05-21 07:15:00	SPY	ETF	295.64	295.83	295.6	295.75	60884.0
2020-05-21 07:20:00	SPY	ETF	295.77	296.0	295.73	295.89	55792.0
2020-05-21 07:25:00	SPY	ETF	295.91	296.27	295.91	296.12	56171.0
2020-05-21 07:30:00	SPY	ETF	296.13	296.16	295.94	296.11	41902.0
2020-05-21 07:35:00	SPY	ETF	296.08	296.13	295.95	296.13	23987.0
2020-05-21 07:40:00	SPY	ETF	296.15	296.21	296.05	296.09	75918.0
2020-05-21 07:45:00	SPY	ETF	296.08	296.16	295.89	295.9	49067.0
2020-05-21 07:50:00	SPY	ETF	295.89	295.89	295.72	295.75	40851.0
2020-05-21 07:55:00	SPY	ETF	295.8	295.84	295.64	295.69	23696.0
2020-05-21 08:00:00	SPY	ETF	295.69	296.21	295.01	295.49	181462.0
2020-05-21 08:05:00	SPY	ETF	295.51	295.7	295.5	295.68	107192.0

> showing 50 of 72,886 rows — these rows as CSV

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