PREVIEW / etf_5min / 2018-12-26

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-12-26.parquet
  size:    1.8 MB
  rows:    75,557

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
2018-12-26 04:00:00	SPY	ETF	234.05	234.09	233.75	234.09	1986.0
2018-12-26 04:10:00	SPY	ETF	233.96	233.98	233.96	233.96	992.0
2018-12-26 04:15:00	SPY	ETF	233.88	233.94	233.71	233.71	1950.0
2018-12-26 04:25:00	SPY	ETF	233.96	234.15	233.94	234.15	5533.0
2018-12-26 04:30:00	SPY	ETF	234.1	234.14	233.83	233.83	1534.0
2018-12-26 04:40:00	SPY	ETF	233.97	233.97	233.93	233.96	1050.0
2018-12-26 04:45:00	SPY	ETF	234.0	234.19	233.99	234.19	1900.0
2018-12-26 04:50:00	SPY	ETF	234.19	234.5	234.19	234.5	5800.0
2018-12-26 04:55:00	SPY	ETF	234.5	235.1	234.5	234.95	8748.0
2018-12-26 05:00:00	SPY	ETF	234.9	235.2	234.77	235.2	6260.0
2018-12-26 05:05:00	SPY	ETF	234.9	234.9	234.67	234.76	7807.0
2018-12-26 05:10:00	SPY	ETF	234.7	234.92	234.6	234.6	39274.0
2018-12-26 05:15:00	SPY	ETF	234.48	234.48	234.13	234.39	20752.0
2018-12-26 05:20:00	SPY	ETF	234.3	234.54	234.3	234.46	1611.0
2018-12-26 05:25:00	SPY	ETF	234.67	234.69	234.44	234.44	629.0
2018-12-26 05:30:00	SPY	ETF	234.6	234.87	234.6	234.8	6750.0
2018-12-26 05:35:00	SPY	ETF	234.74	234.74	234.6	234.7	2456.0
2018-12-26 05:40:00	SPY	ETF	234.58	234.68	234.58	234.66	581.0
2018-12-26 05:45:00	SPY	ETF	234.5	234.5	234.29	234.38	6099.0
2018-12-26 05:50:00	SPY	ETF	234.35	234.35	234.3	234.32	2546.0
2018-12-26 05:55:00	SPY	ETF	234.24	234.46	234.11	234.42	10801.0
2018-12-26 06:00:00	SPY	ETF	234.45	234.6	234.45	234.6	2427.0
2018-12-26 06:05:00	SPY	ETF	234.68	234.8	234.67	234.74	2726.0
2018-12-26 06:10:00	SPY	ETF	234.76	235.0	234.71	234.99	20369.0
2018-12-26 06:15:00	SPY	ETF	235.0	235.05	234.7	234.7	69137.0
2018-12-26 06:20:00	SPY	ETF	234.82	234.97	234.77	234.92	8060.0
2018-12-26 06:25:00	SPY	ETF	234.85	234.85	234.72	234.72	719.0
2018-12-26 06:30:00	SPY	ETF	234.8	234.8	234.63	234.65	1536.0
2018-12-26 06:35:00	SPY	ETF	234.61	234.61	234.54	234.54	1898.0
2018-12-26 06:40:00	SPY	ETF	234.7	234.75	234.45	234.51	10074.0
2018-12-26 06:45:00	SPY	ETF	234.47	234.59	234.44	234.59	5300.0
2018-12-26 06:50:00	SPY	ETF	234.55	234.65	234.5	234.57	9223.0
2018-12-26 06:55:00	SPY	ETF	234.7	234.87	234.62	234.7	10972.0
2018-12-26 07:00:00	SPY	ETF	234.65	234.85	234.6	234.73	30882.0
2018-12-26 07:05:00	SPY	ETF	234.75	234.82	234.71	234.74	6483.0
2018-12-26 07:10:00	SPY	ETF	234.63	234.81	234.63	234.71	8263.0
2018-12-26 07:15:00	SPY	ETF	234.67	234.85	234.66	234.66	19429.0
2018-12-26 07:20:00	SPY	ETF	234.69	234.88	234.5	234.8	44829.0
2018-12-26 07:25:00	SPY	ETF	234.79	235.92	234.7	235.89	39724.0
2018-12-26 07:30:00	SPY	ETF	235.89	235.95	235.44	235.59	58340.0
2018-12-26 07:35:00	SPY	ETF	235.56	235.7	235.47	235.56	42629.0
2018-12-26 07:40:00	SPY	ETF	235.57	235.67	235.47	235.56	9120.0
2018-12-26 07:45:00	SPY	ETF	235.55	235.65	235.46	235.55	12082.0
2018-12-26 07:50:00	SPY	ETF	235.62	235.75	235.3	235.3	21979.0
2018-12-26 07:55:00	SPY	ETF	235.3	235.8	235.3	235.8	52145.0
2018-12-26 08:00:00	SPY	ETF	234.7	235.87	231.99	235.48	94720.0
2018-12-26 08:05:00	SPY	ETF	235.48	235.5	235.23	235.23	63333.0
2018-12-26 08:10:00	SPY	ETF	235.23	235.26	234.97	235.18	100876.0
2018-12-26 08:15:00	SPY	ETF	235.15	235.58	235.08	235.58	73365.0
2018-12-26 08:20:00	SPY	ETF	235.61	235.64	235.34	235.39	173930.0

> showing 50 of 75,557 rows — these rows as CSV

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