PREVIEW / stock_5min / 2016-09-06

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-09-06.parquet
  size:    5.4 MB
  rows:    361,606
  symbols: 3,271

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
2016-09-06 04:00:00	AAPL	Stock	26.985	26.985	26.975	26.975	31500.0
2016-09-06 04:15:00	AAPL	Stock	26.97	26.97	26.97	26.97	1596.0
2016-09-06 04:30:00	AAPL	Stock	26.97	26.97	26.97	26.97	1380.0
2016-09-06 04:35:00	AAPL	Stock	26.9875	27.0	26.9875	27.0	1200.0
2016-09-06 04:40:00	AAPL	Stock	26.9925	26.9925	26.9925	26.9925	400.0
2016-09-06 05:20:00	AAPL	Stock	26.97	26.97	26.97	26.97	2000.0
2016-09-06 05:40:00	AAPL	Stock	26.99	26.99	26.99	26.99	2000.0
2016-09-06 05:45:00	AAPL	Stock	26.99	27.0	26.99	27.0	1712.0
2016-09-06 05:55:00	AAPL	Stock	27.0	27.0	27.0	27.0	4768.0
2016-09-06 06:00:00	AAPL	Stock	27.035	27.045	27.035	27.035	2400.0
2016-09-06 06:05:00	AAPL	Stock	27.025	27.025	27.0	27.0	1200.0
2016-09-06 06:20:00	AAPL	Stock	27.0	27.025	27.0	27.025	1200.0
2016-09-06 06:30:00	AAPL	Stock	27.025	27.025	26.99	26.99	1228.0
2016-09-06 07:00:00	AAPL	Stock	27.0175	27.0175	27.0	27.0	10660.0
2016-09-06 07:05:00	AAPL	Stock	27.0225	27.0225	27.0	27.0	6092.0
2016-09-06 07:10:00	AAPL	Stock	27.0	27.0	27.0	27.0	7852.0
2016-09-06 07:15:00	AAPL	Stock	27.0175	27.025	27.0075	27.0075	43596.0
2016-09-06 07:20:00	AAPL	Stock	27.0225	27.0425	27.0225	27.0425	10060.0
2016-09-06 07:25:00	AAPL	Stock	27.025	27.04	27.025	27.0275	5968.0
2016-09-06 07:30:00	AAPL	Stock	27.04	27.04	27.015	27.015	31796.0
2016-09-06 07:35:00	AAPL	Stock	27.0125	27.0125	27.0125	27.0125	3220.0
2016-09-06 07:40:00	AAPL	Stock	27.0175	27.02	27.0175	27.02	20400.0
2016-09-06 07:45:00	AAPL	Stock	27.0325	27.0325	27.0325	27.0325	2000.0
2016-09-06 07:50:00	AAPL	Stock	27.0275	27.0275	27.0175	27.0175	10600.0
2016-09-06 07:55:00	AAPL	Stock	27.0125	27.0125	27.0125	27.0125	22292.0
2016-09-06 08:00:00	AAPL	Stock	27.0	27.04	26.99	27.0	118704.0
2016-09-06 08:05:00	AAPL	Stock	27.01	27.0125	26.985	27.0025	12800.0
2016-09-06 08:10:00	AAPL	Stock	27.0025	27.0075	27.0025	27.0075	7732.0
2016-09-06 08:15:00	AAPL	Stock	27.01	27.0275	27.0075	27.0125	63872.0
2016-09-06 08:20:00	AAPL	Stock	27.01	27.0225	27.0025	27.0225	24800.0
2016-09-06 08:25:00	AAPL	Stock	27.0075	27.01	27.0075	27.01	1200.0
2016-09-06 08:30:00	AAPL	Stock	27.01	27.0125	27.0	27.01	24136.0
2016-09-06 08:35:00	AAPL	Stock	27.0075	27.01	27.0075	27.01	4504.0
2016-09-06 08:40:00	AAPL	Stock	27.01	27.0175	27.01	27.0175	18600.0
2016-09-06 08:45:00	AAPL	Stock	27.0175	27.0175	27.0125	27.0125	11600.0
2016-09-06 08:50:00	AAPL	Stock	27.015	27.015	27.01	27.01	2400.0
2016-09-06 08:55:00	AAPL	Stock	27.0125	27.0175	27.0125	27.0125	7332.0
2016-09-06 09:00:00	AAPL	Stock	27.0125	27.0175	27.0125	27.0175	12520.0
2016-09-06 09:05:00	AAPL	Stock	27.0175	27.02	27.015	27.02	16904.0
2016-09-06 09:10:00	AAPL	Stock	27.015	27.03	27.0125	27.015	69628.0
2016-09-06 09:15:00	AAPL	Stock	27.015	27.02	27.0075	27.0125	44680.0
2016-09-06 09:20:00	AAPL	Stock	27.0125	27.015	26.9775	26.9775	72348.0
2016-09-06 09:25:00	AAPL	Stock	26.9875	26.99	26.9575	26.9575	64444.0
2016-09-06 09:30:00	AAPL	Stock	26.9575	27.0	26.9375	26.9875	5479424.0
2016-09-06 09:35:00	AAPL	Stock	26.9875	27.0325	26.9725	26.99	3970992.0
2016-09-06 09:40:00	AAPL	Stock	26.99	27.0725	26.99	27.0568	2957664.0
2016-09-06 09:45:00	AAPL	Stock	27.055	27.075	27.04	27.064	1874284.0
2016-09-06 09:50:00	AAPL	Stock	27.065	27.075	27.0125	27.025	1600572.0
2016-09-06 09:55:00	AAPL	Stock	27.025	27.04	27.0	27.0275	1492960.0
2016-09-06 10:00:00	AAPL	Stock	27.025	27.05	27.015	27.0252	1571200.0

> showing 50 of 361,606 rows — these rows as CSV

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