PREVIEW / etf_5min / 2018-05-03

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-05-03.parquet
  size:    1.3 MB
  rows:    57,617

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-05-03 04:00:00	SPY	ETF	263.06	263.39	263.06	263.32	20698.0
2018-05-03 04:05:00	SPY	ETF	263.24	263.27	263.23	263.27	3710.0
2018-05-03 04:10:00	SPY	ETF	263.24	263.28	263.23	263.27	6400.0
2018-05-03 04:15:00	SPY	ETF	263.27	263.29	263.22	263.25	1500.0
2018-05-03 04:25:00	SPY	ETF	263.3	263.3	263.23	263.23	2550.0
2018-05-03 04:30:00	SPY	ETF	263.22	263.33	263.21	263.33	2000.0
2018-05-03 04:35:00	SPY	ETF	263.32	263.32	263.32	263.32	600.0
2018-05-03 04:40:00	SPY	ETF	263.3	263.3	263.3	263.3	610.0
2018-05-03 04:45:00	SPY	ETF	263.33	263.33	263.3	263.3	910.0
2018-05-03 04:50:00	SPY	ETF	263.32	263.32	263.32	263.32	425.0
2018-05-03 04:55:00	SPY	ETF	263.3	263.3	263.3	263.3	100.0
2018-05-03 05:00:00	SPY	ETF	263.33	263.33	263.33	263.33	136.0
2018-05-03 05:05:00	SPY	ETF	263.37	263.4	263.37	263.4	827.0
2018-05-03 05:10:00	SPY	ETF	263.45	263.53	263.45	263.53	2860.0
2018-05-03 05:15:00	SPY	ETF	263.44	263.45	263.42	263.45	900.0
2018-05-03 05:20:00	SPY	ETF	263.45	263.45	263.44	263.44	200.0
2018-05-03 05:25:00	SPY	ETF	263.43	263.45	263.23	263.23	1110.0
2018-05-03 05:30:00	SPY	ETF	263.27	263.32	263.27	263.28	350.0
2018-05-03 05:35:00	SPY	ETF	263.04	263.04	263.04	263.04	120.0
2018-05-03 05:40:00	SPY	ETF	263.09	263.09	263.03	263.05	2400.0
2018-05-03 05:45:00	SPY	ETF	263.1	263.12	263.08	263.08	1100.0
2018-05-03 05:50:00	SPY	ETF	263.11	263.11	263.11	263.11	200.0
2018-05-03 05:55:00	SPY	ETF	263.06	263.06	263.06	263.06	800.0
2018-05-03 06:00:00	SPY	ETF	263.12	263.12	263.06	263.06	700.0
2018-05-03 06:05:00	SPY	ETF	263.13	263.16	263.13	263.16	200.0
2018-05-03 06:10:00	SPY	ETF	263.2	263.24	263.2	263.24	295.0
2018-05-03 06:15:00	SPY	ETF	263.2	263.2	263.2	263.2	800.0
2018-05-03 06:20:00	SPY	ETF	263.2	263.27	263.2	263.23	5300.0
2018-05-03 06:25:00	SPY	ETF	263.28	263.3	263.28	263.28	3750.0
2018-05-03 06:30:00	SPY	ETF	263.28	263.32	263.26	263.29	3100.0
2018-05-03 06:35:00	SPY	ETF	263.25	263.3	263.25	263.3	200.0
2018-05-03 06:40:00	SPY	ETF	263.32	263.32	263.28	263.28	805.0
2018-05-03 06:45:00	SPY	ETF	263.28	263.28	263.19	263.2	3324.0
2018-05-03 06:50:00	SPY	ETF	263.24	263.24	263.2	263.2	1000.0
2018-05-03 06:55:00	SPY	ETF	263.15	263.15	263.15	263.15	8900.0
2018-05-03 07:00:00	SPY	ETF	263.16	263.2	263.04	263.04	34013.0
2018-05-03 07:05:00	SPY	ETF	263.02	263.02	262.72	262.72	58480.0
2018-05-03 07:10:00	SPY	ETF	262.72	262.75	262.71	262.72	4885.0
2018-05-03 07:15:00	SPY	ETF	262.72	262.76	262.68	262.75	16200.0
2018-05-03 07:20:00	SPY	ETF	262.71	262.74	262.71	262.72	2001.0
2018-05-03 07:25:00	SPY	ETF	262.71	262.74	262.69	262.72	4445.0
2018-05-03 07:30:00	SPY	ETF	262.72	262.88	262.72	262.88	3866.0
2018-05-03 07:35:00	SPY	ETF	262.86	262.86	262.77	262.77	12141.0
2018-05-03 07:40:00	SPY	ETF	262.78	262.78	262.51	262.51	22096.0
2018-05-03 07:45:00	SPY	ETF	262.59	262.59	262.42	262.42	35528.0
2018-05-03 07:50:00	SPY	ETF	262.4	262.42	262.0	262.0	86953.0
2018-05-03 07:55:00	SPY	ETF	261.97	262.01	261.73	261.88	72486.0
2018-05-03 08:00:00	SPY	ETF	262.5301	263.17	261.64	261.78	182263.0
2018-05-03 08:05:00	SPY	ETF	261.78	261.83	261.67	261.81	107480.0
2018-05-03 08:10:00	SPY	ETF	261.8	261.85	261.64	261.8	45620.0

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

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