PREVIEW / etf_5min / 2018-06-18

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-06-18.parquet
  size:    1.3 MB
  rows:    57,324

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-06-18 04:00:00	SPY	ETF	276.8	276.8	275.88	275.96	11121.0
2018-06-18 04:05:00	SPY	ETF	275.92	275.92	275.87	275.89	4552.0
2018-06-18 04:10:00	SPY	ETF	275.97	276.0	275.93	276.0	4000.0
2018-06-18 04:25:00	SPY	ETF	275.93	275.93	275.93	275.93	500.0
2018-06-18 04:30:00	SPY	ETF	275.9	276.04	275.9	275.98	3200.0
2018-06-18 04:35:00	SPY	ETF	275.99	276.05	275.99	276.05	2700.0
2018-06-18 04:40:00	SPY	ETF	276.05	276.18	276.04	276.18	1622.0
2018-06-18 04:45:00	SPY	ETF	276.21	276.21	276.2	276.2	1575.0
2018-06-18 04:50:00	SPY	ETF	276.18	276.18	276.1	276.1	4750.0
2018-06-18 04:55:00	SPY	ETF	276.1	276.13	276.04	276.04	900.0
2018-06-18 05:00:00	SPY	ETF	276.09	276.09	276.02	276.03	2900.0
2018-06-18 05:05:00	SPY	ETF	276.13	276.13	276.13	276.13	100.0
2018-06-18 05:10:00	SPY	ETF	276.11	276.11	276.11	276.11	100.0
2018-06-18 05:15:00	SPY	ETF	276.09	276.09	276.05	276.08	800.0
2018-06-18 05:25:00	SPY	ETF	276.08	276.08	276.04	276.04	3400.0
2018-06-18 05:30:00	SPY	ETF	276.03	276.03	275.88	275.88	652.0
2018-06-18 05:35:00	SPY	ETF	275.87	275.89	275.87	275.89	435.0
2018-06-18 05:40:00	SPY	ETF	275.86	275.9	275.86	275.86	13900.0
2018-06-18 05:45:00	SPY	ETF	275.89	275.93	275.87	275.89	3625.0
2018-06-18 05:50:00	SPY	ETF	276.03	276.09	276.03	276.09	300.0
2018-06-18 05:55:00	SPY	ETF	276.08	276.08	276.06	276.06	9800.0
2018-06-18 06:00:00	SPY	ETF	276.06	276.06	275.94	275.97	8900.0
2018-06-18 06:05:00	SPY	ETF	276.04	276.09	276.04	276.09	707.0
2018-06-18 06:10:00	SPY	ETF	275.99	275.99	275.86	275.87	17415.0
2018-06-18 06:15:00	SPY	ETF	275.82	275.82	275.72	275.72	2660.0
2018-06-18 06:20:00	SPY	ETF	275.78	275.78	275.73	275.73	2200.0
2018-06-18 06:25:00	SPY	ETF	275.73	275.82	275.73	275.8	1446.0
2018-06-18 06:30:00	SPY	ETF	275.68	275.68	275.55	275.64	3070.0
2018-06-18 06:35:00	SPY	ETF	275.58	275.65	275.55	275.65	1970.0
2018-06-18 06:40:00	SPY	ETF	275.58	275.75	275.58	275.69	37250.0
2018-06-18 06:45:00	SPY	ETF	275.68	275.69	275.55	275.65	41950.0
2018-06-18 06:50:00	SPY	ETF	275.62	275.7	275.5	275.7	45617.0
2018-06-18 06:55:00	SPY	ETF	275.66	275.66	275.59	275.59	10900.0
2018-06-18 07:00:00	SPY	ETF	275.6	275.63	275.57	275.62	32115.0
2018-06-18 07:05:00	SPY	ETF	275.59	275.6	275.5	275.5	14454.0
2018-06-18 07:10:00	SPY	ETF	275.5	275.57	275.5	275.5	14080.0
2018-06-18 07:15:00	SPY	ETF	275.52	275.59	275.48	275.59	11144.0
2018-06-18 07:20:00	SPY	ETF	275.53	275.58	275.53	275.58	11070.0
2018-06-18 07:25:00	SPY	ETF	275.6	275.63	275.59	275.63	7590.0
2018-06-18 07:30:00	SPY	ETF	275.65	275.68	275.6	275.63	76325.0
2018-06-18 07:35:00	SPY	ETF	275.65	275.65	275.56	275.56	22402.0
2018-06-18 07:40:00	SPY	ETF	275.56	275.65	275.46	275.55	121342.0
2018-06-18 07:45:00	SPY	ETF	275.55	275.56	275.49	275.51	13239.0
2018-06-18 07:50:00	SPY	ETF	275.5	275.53	275.3	275.33	50552.0
2018-06-18 07:55:00	SPY	ETF	275.38	275.39	275.31	275.34	35206.0
2018-06-18 08:00:00	SPY	ETF	275.34	276.1	275.3	275.35	46938.0
2018-06-18 08:05:00	SPY	ETF	275.4	275.45	275.36	275.42	12943.0
2018-06-18 08:10:00	SPY	ETF	275.42	275.45	275.38	275.39	26516.0
2018-06-18 08:15:00	SPY	ETF	275.4	275.41	275.33	275.35	70512.0
2018-06-18 08:20:00	SPY	ETF	275.35	275.36	275.25	275.33	70202.0

> showing 50 of 57,324 rows — these rows as CSV

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