PREVIEW / stock_5min / 2017-04-28

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-04-28.parquet
  size:    5.3 MB
  rows:    348,931
  symbols: 3,050

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-04-28 04:30:00	AAPL	Stock	35.99	35.99	35.99	35.99	400.0
2017-04-28 05:05:00	AAPL	Stock	35.995	35.995	35.995	35.995	420.0
2017-04-28 05:10:00	AAPL	Stock	35.995	35.995	35.995	35.995	628.0
2017-04-28 05:15:00	AAPL	Stock	35.9975	35.9975	35.9975	35.9975	772.0
2017-04-28 05:55:00	AAPL	Stock	35.995	35.9975	35.995	35.9975	800.0
2017-04-28 06:00:00	AAPL	Stock	35.9975	35.9975	35.9975	35.9975	560.0
2017-04-28 06:20:00	AAPL	Stock	35.9975	36.0	35.9975	36.0	1340.0
2017-04-28 06:25:00	AAPL	Stock	36.0	36.0	36.0	36.0	1200.0
2017-04-28 06:40:00	AAPL	Stock	36.0	36.0	36.0	36.0	3600.0
2017-04-28 06:55:00	AAPL	Stock	36.0	36.0	36.0	36.0	400.0
2017-04-28 07:10:00	AAPL	Stock	35.975	35.975	35.975	35.975	2956.0
2017-04-28 07:15:00	AAPL	Stock	35.9725	35.975	35.9725	35.975	4000.0
2017-04-28 07:20:00	AAPL	Stock	36.0	36.0	36.0	36.0	2000.0
2017-04-28 07:25:00	AAPL	Stock	36.0	36.0	36.0	36.0	3236.0
2017-04-28 07:30:00	AAPL	Stock	35.995	36.0	35.965	35.9675	23700.0
2017-04-28 07:35:00	AAPL	Stock	35.98	35.98	35.98	35.98	400.0
2017-04-28 07:50:00	AAPL	Stock	35.9675	35.975	35.9675	35.975	3380.0
2017-04-28 07:55:00	AAPL	Stock	35.9925	35.995	35.9925	35.995	1124.0
2017-04-28 08:00:00	AAPL	Stock	35.975	35.9975	35.975	35.9875	19000.0
2017-04-28 08:05:00	AAPL	Stock	35.9975	35.9975	35.975	35.975	17664.0
2017-04-28 08:10:00	AAPL	Stock	35.9875	35.9875	35.975	35.975	4516.0
2017-04-28 08:15:00	AAPL	Stock	35.97	35.97	35.9625	35.9625	3976.0
2017-04-28 08:20:00	AAPL	Stock	35.975	35.975	35.975	35.975	4240.0
2017-04-28 08:25:00	AAPL	Stock	35.975	35.975	35.975	35.975	1600.0
2017-04-28 08:30:00	AAPL	Stock	35.975	35.995	35.9675	35.975	16528.0
2017-04-28 08:35:00	AAPL	Stock	35.9875	35.9975	35.975	35.995	7608.0
2017-04-28 08:40:00	AAPL	Stock	35.9775	35.9775	35.9775	35.9775	800.0
2017-04-28 08:45:00	AAPL	Stock	36.0	36.0	35.975	35.975	8300.0
2017-04-28 08:50:00	AAPL	Stock	35.975	35.9875	35.9675	35.9875	7324.0
2017-04-28 08:55:00	AAPL	Stock	35.975	35.995	35.975	35.9875	8224.0
2017-04-28 09:00:00	AAPL	Stock	35.9875	35.9875	35.9875	35.9875	552.0
2017-04-28 09:05:00	AAPL	Stock	35.9875	35.9875	35.975	35.975	5416.0
2017-04-28 09:10:00	AAPL	Stock	35.975	35.9825	35.9675	35.9675	14456.0
2017-04-28 09:15:00	AAPL	Stock	35.965	35.965	35.95	35.9625	26352.0
2017-04-28 09:20:00	AAPL	Stock	35.9625	35.9625	35.94	35.94	3200.0
2017-04-28 09:25:00	AAPL	Stock	35.94	36.045	35.94	36.0075	584068.0
2017-04-28 09:30:00	AAPL	Stock	36.0225	36.025	35.8875	35.9525	4370916.0
2017-04-28 09:35:00	AAPL	Stock	35.9525	35.955	35.8838	35.9	1319364.0
2017-04-28 09:40:00	AAPL	Stock	35.9025	35.9375	35.865	35.8812	1582024.0
2017-04-28 09:45:00	AAPL	Stock	35.88	35.9125	35.8175	35.82	1291124.0
2017-04-28 09:50:00	AAPL	Stock	35.82	35.8795	35.8175	35.8425	1319300.0
2017-04-28 09:55:00	AAPL	Stock	35.8425	35.8525	35.825	35.8375	897544.0
2017-04-28 10:00:00	AAPL	Stock	35.835	35.89	35.8342	35.8775	856736.0
2017-04-28 10:05:00	AAPL	Stock	35.875	35.8925	35.8475	35.8475	1069568.0
2017-04-28 10:10:00	AAPL	Stock	35.8475	35.8825	35.845	35.8775	1087816.0
2017-04-28 10:15:00	AAPL	Stock	35.88	35.912	35.8625	35.8925	636096.0
2017-04-28 10:20:00	AAPL	Stock	35.89	35.93	35.875	35.91	646156.0
2017-04-28 10:25:00	AAPL	Stock	35.91	35.9225	35.9	35.915	427580.0
2017-04-28 10:30:00	AAPL	Stock	35.915	35.92	35.885	35.9	453976.0
2017-04-28 10:35:00	AAPL	Stock	35.8995	35.9325	35.8975	35.9192	403756.0

> showing 50 of 348,931 rows — these rows as CSV

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