PREVIEW / etf_5min / 2019-08-21

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-08-21.parquet
  size:    1.4 MB
  rows:    61,152

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
2019-08-21 04:00:00	SPY	ETF	291.3	291.5	291.3	291.5	5690.0
2019-08-21 04:05:00	SPY	ETF	291.41	291.41	291.4	291.4	200.0
2019-08-21 04:10:00	SPY	ETF	291.4	291.4	291.4	291.4	428.0
2019-08-21 04:15:00	SPY	ETF	291.4	291.4	291.3	291.32	3691.0
2019-08-21 04:20:00	SPY	ETF	291.5	291.5	291.46	291.46	1700.0
2019-08-21 04:25:00	SPY	ETF	291.45	291.5	291.45	291.5	1107.0
2019-08-21 04:30:00	SPY	ETF	291.48	291.48	291.48	291.48	135.0
2019-08-21 04:35:00	SPY	ETF	291.52	291.62	291.52	291.62	400.0
2019-08-21 04:40:00	SPY	ETF	291.77	291.8	291.75	291.75	1529.0
2019-08-21 04:45:00	SPY	ETF	291.87	291.94	291.85	291.94	2150.0
2019-08-21 04:50:00	SPY	ETF	291.9	291.9	291.8	291.87	4563.0
2019-08-21 05:00:00	SPY	ETF	291.84	291.84	291.84	291.84	100.0
2019-08-21 05:05:00	SPY	ETF	291.8	291.82	291.77	291.77	8200.0
2019-08-21 05:10:00	SPY	ETF	291.79	291.82	291.74	291.79	2810.0
2019-08-21 05:15:00	SPY	ETF	291.84	291.84	291.84	291.84	2000.0
2019-08-21 05:20:00	SPY	ETF	291.71	291.72	291.71	291.72	5100.0
2019-08-21 05:25:00	SPY	ETF	291.71	291.85	291.71	291.85	700.0
2019-08-21 05:35:00	SPY	ETF	291.91	291.91	291.91	291.91	1000.0
2019-08-21 05:45:00	SPY	ETF	291.97	291.97	291.8	291.82	1604.0
2019-08-21 05:50:00	SPY	ETF	291.74	291.84	291.74	291.84	575.0
2019-08-21 05:55:00	SPY	ETF	291.76	291.76	291.76	291.76	181.0
2019-08-21 06:00:00	SPY	ETF	291.64	291.64	291.64	291.64	100.0
2019-08-21 06:05:00	SPY	ETF	291.64	291.7	291.64	291.7	2000.0
2019-08-21 06:10:00	SPY	ETF	291.69	291.75	291.69	291.74	1512.0
2019-08-21 06:15:00	SPY	ETF	291.64	291.7	291.64	291.7	400.0
2019-08-21 06:20:00	SPY	ETF	291.71	291.81	291.71	291.81	585.0
2019-08-21 06:25:00	SPY	ETF	291.76	291.8	291.76	291.8	550.0
2019-08-21 06:30:00	SPY	ETF	291.74	291.74	291.74	291.74	300.0
2019-08-21 06:35:00	SPY	ETF	291.79	291.84	291.74	291.74	1460.0
2019-08-21 06:40:00	SPY	ETF	291.81	291.89	291.81	291.88	3840.0
2019-08-21 06:45:00	SPY	ETF	291.89	291.92	291.84	291.84	4105.0
2019-08-21 06:50:00	SPY	ETF	291.92	291.92	291.84	291.84	5350.0
2019-08-21 06:55:00	SPY	ETF	291.84	291.9	291.7	291.7	37900.0
2019-08-21 07:00:00	SPY	ETF	291.72	291.77	291.6	291.6	27206.0
2019-08-21 07:05:00	SPY	ETF	291.6	291.7	291.6	291.69	6714.0
2019-08-21 07:10:00	SPY	ETF	291.65	291.79	291.65	291.67	4107.0
2019-08-21 07:15:00	SPY	ETF	291.65	291.81	291.65	291.81	2605.0
2019-08-21 07:20:00	SPY	ETF	291.79	291.84	291.74	291.84	4895.0
2019-08-21 07:25:00	SPY	ETF	291.8	291.82	291.76	291.8	32221.0
2019-08-21 07:30:00	SPY	ETF	291.7	291.75	291.7	291.75	300.0
2019-08-21 07:35:00	SPY	ETF	291.73	291.73	291.65	291.65	26506.0
2019-08-21 07:40:00	SPY	ETF	291.65	291.7	291.61	291.63	22685.0
2019-08-21 07:45:00	SPY	ETF	291.62	291.7	291.6	291.7	34598.0
2019-08-21 07:50:00	SPY	ETF	291.7	291.7	291.65	291.65	6811.0
2019-08-21 07:55:00	SPY	ETF	291.65	291.74	291.62	291.7	19002.0
2019-08-21 08:00:00	SPY	ETF	291.73	291.85	290.79	291.65	24523.0
2019-08-21 08:05:00	SPY	ETF	291.68	291.71	291.62	291.7	11725.0
2019-08-21 08:10:00	SPY	ETF	291.73	291.77	291.67	291.77	39218.0
2019-08-21 08:15:00	SPY	ETF	291.77	292.12	291.56	291.94	184230.0
2019-08-21 08:20:00	SPY	ETF	291.97	292.1	291.88	291.88	100341.0

> showing 50 of 61,152 rows — these rows as CSV

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