PREVIEW / stock_5min / 2016-02-19

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-02-19.parquet
  size:    5.2 MB
  rows:    350,509
  symbols: 3,351

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-02-19 04:15:00	AAPL	Stock	24.02	24.02	24.02	24.02	720.0
2016-02-19 06:35:00	AAPL	Stock	24.065	24.07	24.065	24.07	912.0
2016-02-19 06:45:00	AAPL	Stock	24.04	24.04	24.0	24.0	23328.0
2016-02-19 06:50:00	AAPL	Stock	23.9525	23.9575	23.9525	23.9575	2152.0
2016-02-19 07:00:00	AAPL	Stock	23.96	23.9625	23.96	23.9625	5200.0
2016-02-19 07:05:00	AAPL	Stock	23.9925	23.9925	23.9875	23.9875	1200.0
2016-02-19 07:10:00	AAPL	Stock	23.9725	24.0225	23.9725	24.0225	3892.0
2016-02-19 07:20:00	AAPL	Stock	24.0	24.0	24.0	24.0	1824.0
2016-02-19 07:30:00	AAPL	Stock	24.0	24.0125	23.9875	23.9875	6800.0
2016-02-19 07:35:00	AAPL	Stock	23.99	23.99	23.99	23.99	4000.0
2016-02-19 07:40:00	AAPL	Stock	23.99	24.0225	23.99	24.0225	2880.0
2016-02-19 07:55:00	AAPL	Stock	24.025	24.025	24.025	24.025	528.0
2016-02-19 08:00:00	AAPL	Stock	24.0275	24.0575	23.9775	24.055	12600.0
2016-02-19 08:05:00	AAPL	Stock	24.05	24.055	24.0425	24.0425	15540.0
2016-02-19 08:10:00	AAPL	Stock	24.0375	24.0625	24.0375	24.05	20408.0
2016-02-19 08:15:00	AAPL	Stock	24.05	24.05	24.05	24.05	1600.0
2016-02-19 08:20:00	AAPL	Stock	24.05	24.05	24.0425	24.045	3000.0
2016-02-19 08:25:00	AAPL	Stock	24.0425	24.0425	24.0425	24.0425	1200.0
2016-02-19 08:30:00	AAPL	Stock	24.0425	24.0425	24.025	24.0425	35600.0
2016-02-19 08:35:00	AAPL	Stock	24.05	24.075	24.05	24.0725	31992.0
2016-02-19 08:40:00	AAPL	Stock	24.0675	24.0675	24.05	24.05	5200.0
2016-02-19 08:45:00	AAPL	Stock	24.045	24.045	24.015	24.015	38536.0
2016-02-19 08:50:00	AAPL	Stock	24.0125	24.0375	24.0125	24.025	41060.0
2016-02-19 08:55:00	AAPL	Stock	24.0325	24.0375	24.0125	24.015	63852.0
2016-02-19 09:00:00	AAPL	Stock	24.0025	24.01	23.9775	23.9775	105024.0
2016-02-19 09:05:00	AAPL	Stock	23.98	24.0	23.98	24.0	24020.0
2016-02-19 09:10:00	AAPL	Stock	24.0075	24.0325	24.0075	24.0325	30760.0
2016-02-19 09:15:00	AAPL	Stock	24.0375	24.04	24.0175	24.02	34836.0
2016-02-19 09:20:00	AAPL	Stock	24.0125	24.0125	23.98	23.9825	49560.0
2016-02-19 09:25:00	AAPL	Stock	24.0175	24.0475	23.9925	23.9925	103464.0
2016-02-19 09:30:00	AAPL	Stock	24.0	24.0525	23.95	23.9575	10858160.0
2016-02-19 09:35:00	AAPL	Stock	23.9575	24.0475	23.955	23.9875	2745616.0
2016-02-19 09:40:00	AAPL	Stock	23.985	24.13	23.985	24.1125	3542924.0
2016-02-19 09:45:00	AAPL	Stock	24.115	24.13	24.0375	24.0425	2181968.0
2016-02-19 09:50:00	AAPL	Stock	24.04	24.1075	24.035	24.1075	2366120.0
2016-02-19 09:55:00	AAPL	Stock	24.1075	24.145	24.0225	24.0238	1885256.0
2016-02-19 10:00:00	AAPL	Stock	24.0225	24.0275	23.965	23.9922	2881116.0
2016-02-19 10:05:00	AAPL	Stock	23.99	24.0525	23.9625	24.045	1595872.0
2016-02-19 10:10:00	AAPL	Stock	24.0425	24.0638	24.0125	24.042	1430680.0
2016-02-19 10:15:00	AAPL	Stock	24.04	24.1275	24.0025	24.1168	2284032.0
2016-02-19 10:20:00	AAPL	Stock	24.1152	24.1275	24.07	24.1112	1657588.0
2016-02-19 10:25:00	AAPL	Stock	24.11	24.125	24.055	24.1162	1544028.0
2016-02-19 10:30:00	AAPL	Stock	24.116	24.17	24.095	24.17	2500404.0
2016-02-19 10:35:00	AAPL	Stock	24.1695	24.1725	24.0872	24.099	1641740.0
2016-02-19 10:40:00	AAPL	Stock	24.0975	24.1075	24.0525	24.08	1476164.0
2016-02-19 10:45:00	AAPL	Stock	24.08	24.1325	24.0625	24.1025	1420944.0
2016-02-19 10:50:00	AAPL	Stock	24.1	24.1325	24.08	24.097	898416.0
2016-02-19 10:55:00	AAPL	Stock	24.0925	24.1325	24.085	24.0912	977444.0
2016-02-19 11:00:00	AAPL	Stock	24.09	24.09	24.0375	24.055	1513880.0
2016-02-19 11:05:00	AAPL	Stock	24.0552	24.0825	24.03	24.08	981716.0

> showing 50 of 350,509 rows — these rows as CSV

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