PREVIEW / stock_5min / 2015-03-20

all stock 5-min files

  file:    by_date/stock_5min/2015/2015-03-20.parquet
  size:    5.7 MB
  rows:    376,802
  symbols: 3,528

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
2015-03-20 04:00:00	AAPL	Stock	31.92	32.045	31.92	32.045	14400.0
2015-03-20 04:05:00	AAPL	Stock	31.965	31.965	31.9625	31.9625	2800.0
2015-03-20 04:10:00	AAPL	Stock	31.9625	31.9625	31.9625	31.9625	800.0
2015-03-20 04:55:00	AAPL	Stock	31.9975	31.9975	31.9975	31.9975	680.0
2015-03-20 05:10:00	AAPL	Stock	31.9975	32.025	31.9975	32.025	4640.0
2015-03-20 05:15:00	AAPL	Stock	32.0125	32.0125	32.0125	32.0125	2000.0
2015-03-20 05:45:00	AAPL	Stock	32.0225	32.045	32.0225	32.045	4460.0
2015-03-20 05:50:00	AAPL	Stock	32.05	32.05	32.0	32.0	60700.0
2015-03-20 05:55:00	AAPL	Stock	32.045	32.045	32.045	32.045	400.0
2015-03-20 06:05:00	AAPL	Stock	32.0	32.0	32.0	32.0	2592.0
2015-03-20 06:15:00	AAPL	Stock	31.9625	31.9625	31.955	31.9575	16288.0
2015-03-20 06:20:00	AAPL	Stock	31.97	31.97	31.97	31.97	400.0
2015-03-20 06:25:00	AAPL	Stock	31.995	31.995	31.975	31.9775	19120.0
2015-03-20 06:35:00	AAPL	Stock	31.9775	31.9775	31.975	31.975	3888.0
2015-03-20 06:40:00	AAPL	Stock	31.98	32.0	31.98	32.0	6244.0
2015-03-20 06:55:00	AAPL	Stock	31.995	31.995	31.9875	31.9875	4400.0
2015-03-20 07:00:00	AAPL	Stock	31.985	31.9875	31.975	31.9875	7720.0
2015-03-20 07:05:00	AAPL	Stock	31.99	31.9925	31.99	31.9925	1200.0
2015-03-20 07:10:00	AAPL	Stock	31.99	31.99	31.99	31.99	400.0
2015-03-20 07:15:00	AAPL	Stock	31.9925	32.0125	31.9875	32.01	14332.0
2015-03-20 07:20:00	AAPL	Stock	32.0075	32.01	32.0	32.0	31612.0
2015-03-20 07:30:00	AAPL	Stock	32.0	32.0175	31.99	31.99	21564.0
2015-03-20 07:35:00	AAPL	Stock	32.0175	32.0175	32.0175	32.0175	660.0
2015-03-20 07:40:00	AAPL	Stock	32.02	32.02	32.02	32.02	2400.0
2015-03-20 07:45:00	AAPL	Stock	32.025	32.0375	31.9925	31.9925	29112.0
2015-03-20 07:50:00	AAPL	Stock	32.0	32.0125	31.9925	32.0	24912.0
2015-03-20 07:55:00	AAPL	Stock	31.9975	32.025	31.9975	32.025	7728.0
2015-03-20 08:00:00	AAPL	Stock	32.0025	32.0125	31.875	32.0125	127320.0
2015-03-20 08:05:00	AAPL	Stock	32.0125	32.025	32.0025	32.025	46796.0
2015-03-20 08:10:00	AAPL	Stock	32.025	32.025	32.0	32.0	42372.0
2015-03-20 08:15:00	AAPL	Stock	32.0	32.035	31.9875	32.025	56460.0
2015-03-20 08:20:00	AAPL	Stock	32.025	32.0375	32.025	32.03	19896.0
2015-03-20 08:25:00	AAPL	Stock	32.03	32.03	32.0175	32.0225	9820.0
2015-03-20 08:30:00	AAPL	Stock	32.03	32.03	32.0225	32.03	18720.0
2015-03-20 08:35:00	AAPL	Stock	32.035	32.035	32.025	32.035	19404.0
2015-03-20 08:40:00	AAPL	Stock	32.035	32.0375	32.0275	32.0372	73452.0
2015-03-20 08:45:00	AAPL	Stock	32.035	32.0625	32.035	32.06	81728.0
2015-03-20 08:50:00	AAPL	Stock	32.0525	32.0625	32.05	32.06	65924.0
2015-03-20 08:55:00	AAPL	Stock	32.055	32.06	32.055	32.055	35088.0
2015-03-20 09:00:00	AAPL	Stock	32.0575	32.0625	32.0525	32.06	43136.0
2015-03-20 09:05:00	AAPL	Stock	32.0525	32.0525	32.0325	32.0325	79864.0
2015-03-20 09:10:00	AAPL	Stock	32.0325	32.035	32.015	32.025	105020.0
2015-03-20 09:15:00	AAPL	Stock	32.0225	32.035	32.0125	32.0225	59680.0
2015-03-20 09:20:00	AAPL	Stock	32.025	32.025	32.015	32.0225	29860.0
2015-03-20 09:25:00	AAPL	Stock	32.015	32.0825	31.975	32.0725	720088.0
2015-03-20 09:30:00	AAPL	Stock	32.0725	32.1	32.0	32.0488	38290536.0
2015-03-20 09:35:00	AAPL	Stock	32.0525	32.0725	31.93	31.9425	4340492.0
2015-03-20 09:40:00	AAPL	Stock	31.945	31.9925	31.9125	31.955	2643532.0
2015-03-20 09:45:00	AAPL	Stock	31.9538	32.035	31.9392	31.9402	2442552.0
2015-03-20 09:50:00	AAPL	Stock	31.9425	31.9975	31.9425	31.9775	1616456.0

> showing 50 of 376,802 rows — these rows as CSV

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