PREVIEW / etf_5min / 2018-04-27

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-04-27.parquet
  size:    1.2 MB
  rows:    53,296

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-04-27 04:00:00	SPY	ETF	266.66	266.68	266.66	266.68	525.0
2018-04-27 04:15:00	SPY	ETF	266.64	266.64	266.64	266.64	100.0
2018-04-27 04:25:00	SPY	ETF	266.59	266.59	266.59	266.59	1800.0
2018-04-27 04:40:00	SPY	ETF	266.5	266.5	266.5	266.5	250.0
2018-04-27 04:45:00	SPY	ETF	266.44	266.45	266.44	266.45	2750.0
2018-04-27 04:55:00	SPY	ETF	266.4	266.47	266.4	266.47	5300.0
2018-04-27 05:00:00	SPY	ETF	266.46	266.46	266.46	266.46	100.0
2018-04-27 05:10:00	SPY	ETF	266.45	266.48	266.45	266.47	5600.0
2018-04-27 05:20:00	SPY	ETF	266.39	266.39	266.36	266.36	1375.0
2018-04-27 05:25:00	SPY	ETF	266.35	266.35	266.25	266.3	8010.0
2018-04-27 05:30:00	SPY	ETF	266.3	266.34	266.3	266.34	2000.0
2018-04-27 05:35:00	SPY	ETF	266.4	266.48	266.4	266.48	4543.0
2018-04-27 05:40:00	SPY	ETF	266.4	266.4	266.4	266.4	100.0
2018-04-27 05:50:00	SPY	ETF	266.54	266.54	266.5	266.5	2643.0
2018-04-27 05:55:00	SPY	ETF	266.55	266.65	266.55	266.65	1400.0
2018-04-27 06:00:00	SPY	ETF	266.65	266.65	266.65	266.65	100.0
2018-04-27 06:05:00	SPY	ETF	266.62	266.69	266.62	266.69	750.0
2018-04-27 06:10:00	SPY	ETF	266.69	266.75	266.69	266.75	700.0
2018-04-27 06:15:00	SPY	ETF	266.91	266.91	266.91	266.91	100.0
2018-04-27 06:25:00	SPY	ETF	266.81	266.81	266.81	266.81	100.0
2018-04-27 06:30:00	SPY	ETF	266.8	266.88	266.8	266.88	3000.0
2018-04-27 06:35:00	SPY	ETF	266.89	266.89	266.8	266.8	2543.0
2018-04-27 06:40:00	SPY	ETF	266.78	266.78	266.75	266.77	2300.0
2018-04-27 06:45:00	SPY	ETF	266.75	266.75	266.75	266.75	500.0
2018-04-27 06:50:00	SPY	ETF	266.75	266.75	266.71	266.71	4600.0
2018-04-27 06:55:00	SPY	ETF	266.7	266.7	266.64	266.64	6311.0
2018-04-27 07:00:00	SPY	ETF	266.69	266.71	266.66	266.67	3299.0
2018-04-27 07:05:00	SPY	ETF	266.66	266.74	266.6	266.74	16950.0
2018-04-27 07:10:00	SPY	ETF	266.71	266.73	266.68	266.71	7107.0
2018-04-27 07:15:00	SPY	ETF	266.61	266.64	266.56	266.64	5500.0
2018-04-27 07:20:00	SPY	ETF	266.63	266.68	266.61	266.61	26875.0
2018-04-27 07:25:00	SPY	ETF	266.64	266.73	266.64	266.72	6118.0
2018-04-27 07:30:00	SPY	ETF	266.78	266.88	266.77	266.84	23950.0
2018-04-27 07:35:00	SPY	ETF	266.86	266.89	266.84	266.88	5900.0
2018-04-27 07:40:00	SPY	ETF	266.89	266.89	266.89	266.89	720.0
2018-04-27 07:45:00	SPY	ETF	266.88	266.89	266.83	266.85	3150.0
2018-04-27 07:50:00	SPY	ETF	266.82	266.84	266.82	266.82	2391.0
2018-04-27 07:55:00	SPY	ETF	266.84	266.93	266.84	266.92	52810.0
2018-04-27 08:00:00	SPY	ETF	266.86	266.9	266.62	266.88	35320.0
2018-04-27 08:05:00	SPY	ETF	266.9	266.95	266.88	266.93	64890.0
2018-04-27 08:10:00	SPY	ETF	266.93	266.93	266.81	266.82	37928.0
2018-04-27 08:15:00	SPY	ETF	266.82	266.86	266.81	266.85	12398.0
2018-04-27 08:20:00	SPY	ETF	266.85	266.85	266.82	266.85	62102.0
2018-04-27 08:25:00	SPY	ETF	266.82	266.84	266.78	266.84	47994.0
2018-04-27 08:30:00	SPY	ETF	266.8	266.98	266.72	266.89	128879.0
2018-04-27 08:35:00	SPY	ETF	266.87	267.0	266.87	266.98	177513.0
2018-04-27 08:40:00	SPY	ETF	267.0	267.02	266.96	266.99	39644.0
2018-04-27 08:45:00	SPY	ETF	266.99	267.07	266.99	267.05	58778.0
2018-04-27 08:50:00	SPY	ETF	267.06	267.13	267.06	267.1	19113.0
2018-04-27 08:55:00	SPY	ETF	267.12	267.1899	267.09	267.17	45991.0

> showing 50 of 53,296 rows — these rows as CSV

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