PREVIEW / etf_5min / 2018-10-01

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-10-01.parquet
  size:    1.4 MB
  rows:    60,125

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-10-01 04:00:00	SPY	ETF	292.21	292.39	292.21	292.38	4881.0
2018-10-01 04:10:00	SPY	ETF	292.43	292.43	292.34	292.34	670.0
2018-10-01 04:15:00	SPY	ETF	292.4	292.4	292.4	292.4	256.0
2018-10-01 04:25:00	SPY	ETF	292.45	292.47	292.34	292.47	3869.0
2018-10-01 04:35:00	SPY	ETF	292.33	292.39	292.33	292.33	602.0
2018-10-01 04:50:00	SPY	ETF	292.47	292.47	292.47	292.47	706.0
2018-10-01 04:55:00	SPY	ETF	292.47	292.47	292.47	292.47	100.0
2018-10-01 05:05:00	SPY	ETF	292.41	292.43	292.41	292.43	600.0
2018-10-01 05:10:00	SPY	ETF	292.41	292.41	292.41	292.41	100.0
2018-10-01 05:15:00	SPY	ETF	292.4	292.45	292.36	292.45	700.0
2018-10-01 05:20:00	SPY	ETF	292.36	292.36	292.36	292.36	788.0
2018-10-01 05:25:00	SPY	ETF	292.33	292.37	292.33	292.37	10500.0
2018-10-01 05:30:00	SPY	ETF	292.37	292.38	292.37	292.38	22520.0
2018-10-01 05:35:00	SPY	ETF	292.38	292.38	292.35	292.35	5302.0
2018-10-01 05:40:00	SPY	ETF	292.35	292.4	292.35	292.4	12380.0
2018-10-01 05:45:00	SPY	ETF	292.39	292.46	292.39	292.39	10000.0
2018-10-01 05:55:00	SPY	ETF	292.41	292.41	292.41	292.41	2400.0
2018-10-01 06:00:00	SPY	ETF	292.46	292.46	292.36	292.42	1902.0
2018-10-01 06:05:00	SPY	ETF	292.44	292.44	292.37	292.37	1180.0
2018-10-01 06:10:00	SPY	ETF	292.39	292.42	292.39	292.4	3310.0
2018-10-01 06:20:00	SPY	ETF	292.32	292.32	292.32	292.32	240.0
2018-10-01 06:25:00	SPY	ETF	292.22	292.27	292.22	292.27	1100.0
2018-10-01 06:30:00	SPY	ETF	292.4	292.4	292.35	292.35	1800.0
2018-10-01 06:35:00	SPY	ETF	292.24	292.37	292.2	292.37	10400.0
2018-10-01 06:40:00	SPY	ETF	292.39	292.41	292.39	292.41	900.0
2018-10-01 06:45:00	SPY	ETF	292.41	292.42	292.41	292.42	600.0
2018-10-01 06:50:00	SPY	ETF	292.4	292.42	292.34	292.37	18700.0
2018-10-01 06:55:00	SPY	ETF	292.42	292.42	292.34	292.37	7150.0
2018-10-01 07:00:00	SPY	ETF	292.33	292.36	292.3	292.3	15917.0
2018-10-01 07:05:00	SPY	ETF	292.3	292.41	292.3	292.38	34433.0
2018-10-01 07:10:00	SPY	ETF	292.38	292.42	292.38	292.42	5000.0
2018-10-01 07:15:00	SPY	ETF	292.42	292.48	292.41	292.41	63526.0
2018-10-01 07:20:00	SPY	ETF	292.42	292.43	292.42	292.43	1800.0
2018-10-01 07:25:00	SPY	ETF	292.43	292.48	292.4	292.4	5600.0
2018-10-01 07:30:00	SPY	ETF	292.41	292.41	292.25	292.3	16914.0
2018-10-01 07:35:00	SPY	ETF	292.3	292.39	292.26	292.26	13397.0
2018-10-01 07:40:00	SPY	ETF	292.25	292.26	292.21	292.24	11250.0
2018-10-01 07:45:00	SPY	ETF	292.23	292.26	292.11	292.16	22420.0
2018-10-01 07:50:00	SPY	ETF	292.17	292.24	292.17	292.24	6486.0
2018-10-01 07:55:00	SPY	ETF	292.21	292.29	292.2	292.29	2374.0
2018-10-01 08:00:00	SPY	ETF	292.33	292.4101	292.0	292.31	18817.0
2018-10-01 08:05:00	SPY	ETF	292.3	292.31	292.2701	292.29	6168.0
2018-10-01 08:10:00	SPY	ETF	292.25	292.26	292.23	292.26	9514.0
2018-10-01 08:15:00	SPY	ETF	292.27	292.27	292.13	292.13	6625.0
2018-10-01 08:20:00	SPY	ETF	292.12	292.12	292.05	292.1	15553.0
2018-10-01 08:25:00	SPY	ETF	292.09	292.11	292.05	292.0801	36657.0
2018-10-01 08:30:00	SPY	ETF	292.08	292.35	291.98	291.99	34412.0
2018-10-01 08:35:00	SPY	ETF	291.98	291.99	291.89	291.99	27950.0
2018-10-01 08:40:00	SPY	ETF	292.0	292.05	291.96	292.0	68277.0
2018-10-01 08:45:00	SPY	ETF	292.0	292.08	290.72	292.08	63805.0

> showing 50 of 60,125 rows — these rows as CSV

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