PREVIEW / stock_5min / 2017-09-21

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-09-21.parquet
  size:    5.3 MB
  rows:    344,554
  symbols: 2,944

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-21 04:00:00	AAPL	Stock	39.0125	39.025	39.0125	39.025	800.0
2017-09-21 04:05:00	AAPL	Stock	39.05	39.05	39.05	39.05	1908.0
2017-09-21 04:10:00	AAPL	Stock	39.05	39.05	39.05	39.05	408.0
2017-09-21 04:15:00	AAPL	Stock	39.0	39.0	39.0	39.0	800.0
2017-09-21 04:25:00	AAPL	Stock	39.02	39.02	39.02	39.02	400.0
2017-09-21 05:00:00	AAPL	Stock	39.0	39.01	39.0	39.01	800.0
2017-09-21 05:05:00	AAPL	Stock	39.0	39.0	39.0	39.0	800.0
2017-09-21 05:10:00	AAPL	Stock	39.0	39.0	39.0	39.0	1536.0
2017-09-21 05:20:00	AAPL	Stock	39.0	39.0	39.0	39.0	424.0
2017-09-21 05:30:00	AAPL	Stock	38.9625	38.9625	38.9625	38.9625	748.0
2017-09-21 05:50:00	AAPL	Stock	38.9825	38.9825	38.9825	38.9825	896.0
2017-09-21 06:00:00	AAPL	Stock	38.9625	38.9625	38.9625	38.9625	732.0
2017-09-21 06:05:00	AAPL	Stock	39.0225	39.025	39.0225	39.025	2784.0
2017-09-21 06:20:00	AAPL	Stock	38.975	38.975	38.975	38.975	3936.0
2017-09-21 06:25:00	AAPL	Stock	38.975	38.975	38.975	38.975	5880.0
2017-09-21 06:30:00	AAPL	Stock	38.975	38.975	38.9625	38.9625	1572.0
2017-09-21 06:40:00	AAPL	Stock	38.975	38.975	38.975	38.975	1976.0
2017-09-21 06:45:00	AAPL	Stock	38.9575	38.9625	38.9575	38.9575	3948.0
2017-09-21 06:50:00	AAPL	Stock	38.9375	38.9575	38.9375	38.9575	2464.0
2017-09-21 06:55:00	AAPL	Stock	38.9625	39.0	38.9625	39.0	10544.0
2017-09-21 07:00:00	AAPL	Stock	39.0	39.0125	38.9625	39.0125	5548.0
2017-09-21 07:05:00	AAPL	Stock	38.99	38.99	38.975	38.9775	9720.0
2017-09-21 07:15:00	AAPL	Stock	38.9975	38.9975	38.9675	38.975	3000.0
2017-09-21 07:20:00	AAPL	Stock	38.9675	38.9675	38.9625	38.9625	2468.0
2017-09-21 07:30:00	AAPL	Stock	38.95	38.9625	38.9375	38.9625	3244.0
2017-09-21 07:45:00	AAPL	Stock	38.9625	38.965	38.955	38.955	8272.0
2017-09-21 07:50:00	AAPL	Stock	38.965	38.965	38.955	38.955	4400.0
2017-09-21 07:55:00	AAPL	Stock	38.975	38.975	38.975	38.975	1780.0
2017-09-21 08:00:00	AAPL	Stock	38.965	38.99	38.955	38.975	31060.0
2017-09-21 08:05:00	AAPL	Stock	38.9775	39.0	38.9775	38.99	6152.0
2017-09-21 08:10:00	AAPL	Stock	38.9875	39.025	38.9875	39.0175	28532.0
2017-09-21 08:15:00	AAPL	Stock	39.0375	39.0375	39.0225	39.025	17344.0
2017-09-21 08:20:00	AAPL	Stock	39.025	39.025	39.005	39.0075	20600.0
2017-09-21 08:25:00	AAPL	Stock	39.0075	39.0075	39.0025	39.0025	8400.0
2017-09-21 08:30:00	AAPL	Stock	39.0025	39.0175	39.0025	39.0175	2100.0
2017-09-21 08:35:00	AAPL	Stock	39.0025	39.0175	39.0	39.0	12784.0
2017-09-21 08:40:00	AAPL	Stock	39.0075	39.0075	39.0	39.0	5392.0
2017-09-21 08:45:00	AAPL	Stock	39.0025	39.005	39.0	39.0	9512.0
2017-09-21 08:50:00	AAPL	Stock	39.0	39.0225	39.0	39.0125	28568.0
2017-09-21 08:55:00	AAPL	Stock	39.01	39.0125	39.01	39.0125	4224.0
2017-09-21 09:00:00	AAPL	Stock	39.0075	39.01	38.97	38.97	120700.0
2017-09-21 09:05:00	AAPL	Stock	38.97	38.975	38.9625	38.97	14824.0
2017-09-21 09:10:00	AAPL	Stock	38.9725	39.0	38.965	38.965	42024.0
2017-09-21 09:15:00	AAPL	Stock	38.965	38.965	38.9275	38.935	51320.0
2017-09-21 09:20:00	AAPL	Stock	38.9325	38.9325	38.9025	38.9125	21604.0
2017-09-21 09:25:00	AAPL	Stock	38.9	38.9575	38.9	38.9575	32912.0
2017-09-21 09:30:00	AAPL	Stock	38.955	38.955	38.6	38.647	6196640.0
2017-09-21 09:35:00	AAPL	Stock	38.65	38.6825	38.5375	38.6272	3700168.0
2017-09-21 09:40:00	AAPL	Stock	38.6255	38.6475	38.52	38.56	2938680.0
2017-09-21 09:45:00	AAPL	Stock	38.56	38.605	38.5	38.565	3862900.0

> showing 50 of 344,554 rows — these rows as CSV

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