PREVIEW / etf_5min / 2017-09-15

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-09-15.parquet
  size:    1.2 MB
  rows:    51,091

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
2017-09-15 04:00:00	SPY	ETF	248.72	248.72	248.65	248.7	6406.0
2017-09-15 04:10:00	SPY	ETF	248.56	248.56	248.56	248.56	1000.0
2017-09-15 04:20:00	SPY	ETF	248.66	248.66	248.66	248.66	1000.0
2017-09-15 04:25:00	SPY	ETF	248.7	248.7	248.7	248.7	1000.0
2017-09-15 04:30:00	SPY	ETF	248.68	248.73	248.68	248.73	200.0
2017-09-15 04:35:00	SPY	ETF	248.71	248.71	248.71	248.71	727.0
2017-09-15 04:40:00	SPY	ETF	248.72	248.72	248.69	248.69	1100.0
2017-09-15 04:45:00	SPY	ETF	248.7	248.7	248.67	248.67	1300.0
2017-09-15 04:50:00	SPY	ETF	248.65	248.71	248.65	248.71	500.0
2017-09-15 04:55:00	SPY	ETF	248.74	248.74	248.74	248.74	11200.0
2017-09-15 05:10:00	SPY	ETF	248.75	248.75	248.74	248.74	400.0
2017-09-15 05:15:00	SPY	ETF	248.71	248.71	248.71	248.71	100.0
2017-09-15 05:25:00	SPY	ETF	248.83	248.83	248.83	248.83	100.0
2017-09-15 05:50:00	SPY	ETF	248.6	248.6	248.6	248.6	100.0
2017-09-15 05:55:00	SPY	ETF	248.63	248.63	248.63	248.63	200.0
2017-09-15 06:00:00	SPY	ETF	248.57	248.58	248.52	248.58	4590.0
2017-09-15 06:05:00	SPY	ETF	248.58	248.58	248.55	248.58	800.0
2017-09-15 06:10:00	SPY	ETF	248.56	248.59	248.55	248.55	5500.0
2017-09-15 06:15:00	SPY	ETF	248.56	248.59	248.56	248.59	2000.0
2017-09-15 06:20:00	SPY	ETF	248.55	248.55	248.55	248.55	500.0
2017-09-15 06:25:00	SPY	ETF	248.59	248.59	248.58	248.58	4200.0
2017-09-15 06:30:00	SPY	ETF	248.59	248.62	248.59	248.62	11625.0
2017-09-15 06:35:00	SPY	ETF	248.59	248.59	248.59	248.59	2000.0
2017-09-15 06:40:00	SPY	ETF	248.62	248.62	248.62	248.62	200.0
2017-09-15 06:45:00	SPY	ETF	248.65	248.65	248.59	248.61	8635.0
2017-09-15 06:50:00	SPY	ETF	248.61	248.61	248.56	248.56	6389.0
2017-09-15 06:55:00	SPY	ETF	248.6	248.6	248.55	248.56	16500.0
2017-09-15 07:00:00	SPY	ETF	248.59	248.62	248.55	248.62	2550.0
2017-09-15 07:05:00	SPY	ETF	248.6	248.61	248.6	248.6	1800.0
2017-09-15 07:10:00	SPY	ETF	248.6	248.6	248.58	248.6	3500.0
2017-09-15 07:15:00	SPY	ETF	248.6	248.6	248.58	248.58	27200.0
2017-09-15 07:20:00	SPY	ETF	248.56	248.58	248.55	248.58	26100.0
2017-09-15 07:25:00	SPY	ETF	248.6	248.63	248.57	248.63	31113.0
2017-09-15 07:30:00	SPY	ETF	248.63	248.7	248.63	248.7	35400.0
2017-09-15 07:35:00	SPY	ETF	248.69	248.69	248.67	248.68	27421.0
2017-09-15 07:40:00	SPY	ETF	248.7	248.71	248.68	248.7	7100.0
2017-09-15 07:45:00	SPY	ETF	248.7	248.78	248.7	248.78	32835.0
2017-09-15 07:50:00	SPY	ETF	248.78	248.81	248.77	248.79	26450.0
2017-09-15 07:55:00	SPY	ETF	248.76	248.76	248.76	248.76	7600.0
2017-09-15 08:00:00	SPY	ETF	248.78	248.8	248.58	248.75	45154.0
2017-09-15 08:05:00	SPY	ETF	248.75	248.82	248.75	248.8	42492.0
2017-09-15 08:10:00	SPY	ETF	248.82	248.82	248.75	248.76	19527.0
2017-09-15 08:15:00	SPY	ETF	248.75	248.77	248.71	248.71	23191.0
2017-09-15 08:20:00	SPY	ETF	248.71	248.74	248.71	248.73	9503.0
2017-09-15 08:25:00	SPY	ETF	248.72	248.72	248.68	248.71	28052.0
2017-09-15 08:30:00	SPY	ETF	248.67	248.71	248.6	248.66	47779.0
2017-09-15 08:35:00	SPY	ETF	248.68	248.71	248.64	248.67	18346.0
2017-09-15 08:40:00	SPY	ETF	248.69	248.73	248.66	248.72	29695.0
2017-09-15 08:45:00	SPY	ETF	248.72	248.73	248.64	248.66	72764.0
2017-09-15 08:50:00	SPY	ETF	248.66	248.66	248.6	248.6	31454.0

> showing 50 of 51,091 rows — these rows as CSV

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