PREVIEW / etf_5min / 2019-03-27

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-03-27.parquet
  size:    1.4 MB
  rows:    63,831

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
2019-03-27 04:00:00	SPY	ETF	281.77	281.78	281.68	281.68	2278.0
2019-03-27 04:05:00	SPY	ETF	281.55	281.55	281.55	281.55	200.0
2019-03-27 04:10:00	SPY	ETF	281.63	281.63	281.63	281.63	100.0
2019-03-27 04:20:00	SPY	ETF	281.53	281.53	281.48	281.48	200.0
2019-03-27 04:25:00	SPY	ETF	281.36	281.36	281.25	281.25	3105.0
2019-03-27 04:35:00	SPY	ETF	281.34	281.34	281.32	281.32	295.0
2019-03-27 04:45:00	SPY	ETF	281.31	281.35	281.29	281.35	3700.0
2019-03-27 04:50:00	SPY	ETF	281.35	281.35	281.35	281.35	100.0
2019-03-27 04:55:00	SPY	ETF	281.3	281.3	281.3	281.3	1018.0
2019-03-27 05:00:00	SPY	ETF	281.22	281.25	281.22	281.25	615.0
2019-03-27 05:10:00	SPY	ETF	281.33	281.39	281.33	281.39	600.0
2019-03-27 05:20:00	SPY	ETF	281.45	281.45	281.45	281.45	200.0
2019-03-27 05:25:00	SPY	ETF	281.49	281.55	281.49	281.55	230.0
2019-03-27 05:30:00	SPY	ETF	281.61	281.67	281.61	281.67	3705.0
2019-03-27 05:40:00	SPY	ETF	281.6	281.6	281.3	281.3	505.0
2019-03-27 05:45:00	SPY	ETF	281.25	281.25	281.15	281.15	1504.0
2019-03-27 05:50:00	SPY	ETF	281.0	281.02	280.87	280.93	617.0
2019-03-27 05:55:00	SPY	ETF	280.9	280.9	280.79	280.85	2875.0
2019-03-27 06:00:00	SPY	ETF	280.7	280.7	280.7	280.7	1015.0
2019-03-27 06:05:00	SPY	ETF	280.7	280.7	280.42	280.57	9245.0
2019-03-27 06:10:00	SPY	ETF	280.57	280.6	280.49	280.54	5800.0
2019-03-27 06:15:00	SPY	ETF	280.65	280.65	280.47	280.49	25200.0
2019-03-27 06:20:00	SPY	ETF	280.64	280.64	280.6	280.62	3600.0
2019-03-27 06:25:00	SPY	ETF	280.62	280.7	280.6	280.7	3438.0
2019-03-27 06:30:00	SPY	ETF	280.72	280.72	280.6	280.6	569.0
2019-03-27 06:35:00	SPY	ETF	280.54	280.54	280.41	280.41	2050.0
2019-03-27 06:40:00	SPY	ETF	280.51	280.59	280.5	280.5	2976.0
2019-03-27 06:45:00	SPY	ETF	280.5	280.55	280.4	280.55	5945.0
2019-03-27 06:50:00	SPY	ETF	280.57	280.57	280.45	280.49	2200.0
2019-03-27 06:55:00	SPY	ETF	280.45	280.45	280.24	280.24	6602.0
2019-03-27 07:00:00	SPY	ETF	280.25	280.32	280.15	280.32	8022.0
2019-03-27 07:05:00	SPY	ETF	280.3	280.32	280.16	280.26	5464.0
2019-03-27 07:10:00	SPY	ETF	280.26	280.29	280.15	280.29	15885.0
2019-03-27 07:15:00	SPY	ETF	280.29	280.6	280.25	280.48	34838.0
2019-03-27 07:20:00	SPY	ETF	280.49	280.5	280.4	280.5	24650.0
2019-03-27 07:25:00	SPY	ETF	280.49	280.52	280.46	280.5	2863.0
2019-03-27 07:30:00	SPY	ETF	280.52	280.55	280.5	280.5	2394.0
2019-03-27 07:35:00	SPY	ETF	280.48	280.57	280.45	280.55	6170.0
2019-03-27 07:40:00	SPY	ETF	280.55	280.65	280.53	280.56	8905.0
2019-03-27 07:45:00	SPY	ETF	280.55	280.65	280.5	280.65	5855.0
2019-03-27 07:50:00	SPY	ETF	280.65	280.75	280.65	280.67	21106.0
2019-03-27 07:55:00	SPY	ETF	280.65	280.7	280.65	280.65	2215.0
2019-03-27 08:00:00	SPY	ETF	280.7	281.77	280.1901	280.64	53820.0
2019-03-27 08:05:00	SPY	ETF	280.62	280.62	280.45	280.5	19129.0
2019-03-27 08:10:00	SPY	ETF	280.51	280.51	280.34	280.37	58022.0
2019-03-27 08:15:00	SPY	ETF	280.34	280.45	280.28	280.45	38108.0
2019-03-27 08:20:00	SPY	ETF	280.45	280.6	280.34	280.6	19407.0
2019-03-27 08:25:00	SPY	ETF	280.55	280.76	280.55	280.72	46257.0
2019-03-27 08:30:00	SPY	ETF	280.75	281.06	280.64	281.06	71170.0
2019-03-27 08:35:00	SPY	ETF	281.04	281.04	280.96	281.03	72372.0

> showing 50 of 63,831 rows — these rows as CSV

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