PREVIEW / etf_5min / 2019-07-18

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-07-18.parquet
  size:    1.4 MB
  rows:    61,113

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-07-18 04:00:00	SPY	ETF	297.28	297.28	296.9	296.9	6241.0
2019-07-18 04:05:00	SPY	ETF	296.93	296.93	296.9	296.92	5121.0
2019-07-18 04:10:00	SPY	ETF	296.95	297.0	296.94	296.94	11000.0
2019-07-18 04:15:00	SPY	ETF	296.8	296.82	296.79	296.82	10400.0
2019-07-18 04:25:00	SPY	ETF	296.87	296.89	296.87	296.89	1876.0
2019-07-18 04:30:00	SPY	ETF	296.88	296.88	296.84	296.84	400.0
2019-07-18 04:45:00	SPY	ETF	296.88	296.88	296.88	296.88	100.0
2019-07-18 05:05:00	SPY	ETF	297.07	297.14	297.07	297.14	1110.0
2019-07-18 05:15:00	SPY	ETF	297.3	297.3	297.3	297.3	200.0
2019-07-18 05:25:00	SPY	ETF	297.24	297.27	297.24	297.27	1410.0
2019-07-18 05:30:00	SPY	ETF	297.29	297.32	297.29	297.32	7000.0
2019-07-18 05:35:00	SPY	ETF	297.32	297.32	297.32	297.32	1700.0
2019-07-18 05:40:00	SPY	ETF	297.32	297.32	297.27	297.27	650.0
2019-07-18 05:45:00	SPY	ETF	297.24	297.24	297.2	297.2	510.0
2019-07-18 05:50:00	SPY	ETF	297.16	297.22	297.16	297.22	400.0
2019-07-18 05:55:00	SPY	ETF	297.2	297.2	297.17	297.17	3304.0
2019-07-18 06:05:00	SPY	ETF	297.17	297.17	297.12	297.12	700.0
2019-07-18 06:10:00	SPY	ETF	297.12	297.2	297.12	297.2	546.0
2019-07-18 06:15:00	SPY	ETF	297.22	297.22	297.21	297.21	655.0
2019-07-18 06:20:00	SPY	ETF	297.29	297.32	297.29	297.32	410.0
2019-07-18 06:30:00	SPY	ETF	297.25	297.5	297.19	297.45	29988.0
2019-07-18 06:35:00	SPY	ETF	297.35	297.35	297.35	297.35	300.0
2019-07-18 06:40:00	SPY	ETF	297.37	297.45	297.37	297.43	11950.0
2019-07-18 06:45:00	SPY	ETF	297.38	297.38	297.33	297.33	504.0
2019-07-18 06:50:00	SPY	ETF	297.41	297.5	297.41	297.5	720.0
2019-07-18 06:55:00	SPY	ETF	297.48	297.51	297.48	297.5	1510.0
2019-07-18 07:00:00	SPY	ETF	297.48	297.52	297.48	297.52	18428.0
2019-07-18 07:05:00	SPY	ETF	297.49	297.49	297.46	297.49	1350.0
2019-07-18 07:10:00	SPY	ETF	297.46	297.68	297.45	297.68	30615.0
2019-07-18 07:15:00	SPY	ETF	297.6	297.6	297.39	297.45	9669.0
2019-07-18 07:20:00	SPY	ETF	297.45	297.47	297.42	297.45	7500.0
2019-07-18 07:25:00	SPY	ETF	297.45	297.51	297.42	297.51	7410.0
2019-07-18 07:30:00	SPY	ETF	297.53	297.53	297.38	297.38	18900.0
2019-07-18 07:35:00	SPY	ETF	297.36	297.38	297.36	297.36	12750.0
2019-07-18 07:40:00	SPY	ETF	297.4	297.4	297.34	297.34	26370.0
2019-07-18 07:45:00	SPY	ETF	297.4	297.55	297.4	297.52	10415.0
2019-07-18 07:50:00	SPY	ETF	297.4	297.41	297.4	297.41	27420.0
2019-07-18 07:55:00	SPY	ETF	297.41	297.41	297.38	297.38	9180.0
2019-07-18 08:00:00	SPY	ETF	297.5001	297.5299	296.72	297.38	14279.0
2019-07-18 08:05:00	SPY	ETF	297.3999	297.5	297.3999	297.5	7460.0
2019-07-18 08:10:00	SPY	ETF	297.5	297.56	297.47	297.47	16929.0
2019-07-18 08:15:00	SPY	ETF	297.47	297.5	297.46	297.46	8977.0
2019-07-18 08:20:00	SPY	ETF	297.46	297.47	297.45	297.47	6143.0
2019-07-18 08:25:00	SPY	ETF	297.49	297.55	297.49	297.55	6071.0
2019-07-18 08:30:00	SPY	ETF	297.54	297.79	297.54	297.74	130898.0
2019-07-18 08:35:00	SPY	ETF	297.73	297.73	297.56	297.68	13834.0
2019-07-18 08:40:00	SPY	ETF	297.67	297.68	297.61	297.63	19633.0
2019-07-18 08:45:00	SPY	ETF	297.67	297.67	297.59	297.63	6283.0
2019-07-18 08:50:00	SPY	ETF	297.59	297.59	297.51	297.54	7498.0
2019-07-18 08:55:00	SPY	ETF	297.56	297.56	297.48	297.48	3502.0

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

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