PREVIEW / stock_5min / 2017-10-10

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-10-10.parquet
  size:    5.3 MB
  rows:    348,178
  symbols: 2,947

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-10-10 04:05:00	AAPL	Stock	38.93	38.93	38.93	38.93	1008.0
2017-10-10 04:20:00	AAPL	Stock	38.99	38.99	38.99	38.99	960.0
2017-10-10 05:35:00	AAPL	Stock	38.9925	39.0	38.9925	39.0	9200.0
2017-10-10 05:40:00	AAPL	Stock	39.025	39.025	39.025	39.025	400.0
2017-10-10 06:15:00	AAPL	Stock	39.0325	39.0325	39.0	39.0	4388.0
2017-10-10 06:35:00	AAPL	Stock	39.025	39.025	39.025	39.025	400.0
2017-10-10 06:40:00	AAPL	Stock	39.0025	39.0025	39.0025	39.0025	800.0
2017-10-10 06:50:00	AAPL	Stock	39.0	39.0	39.0	39.0	7616.0
2017-10-10 06:55:00	AAPL	Stock	38.975	38.975	38.975	38.975	400.0
2017-10-10 07:00:00	AAPL	Stock	38.995	39.015	38.96	38.975	77428.0
2017-10-10 07:05:00	AAPL	Stock	38.995	39.0	38.995	38.9975	13200.0
2017-10-10 07:10:00	AAPL	Stock	38.995	38.9975	38.995	38.9975	2000.0
2017-10-10 07:15:00	AAPL	Stock	38.995	38.995	38.9925	38.9925	3600.0
2017-10-10 07:20:00	AAPL	Stock	38.965	38.965	38.9625	38.9625	7052.0
2017-10-10 07:35:00	AAPL	Stock	38.94	38.96	38.93	38.9375	24568.0
2017-10-10 07:40:00	AAPL	Stock	38.9025	38.9375	38.9	38.9375	3664.0
2017-10-10 07:45:00	AAPL	Stock	38.95	38.95	38.95	38.95	400.0
2017-10-10 07:50:00	AAPL	Stock	38.9575	38.9575	38.95	38.95	8800.0
2017-10-10 07:55:00	AAPL	Stock	38.955	38.955	38.935	38.95	12320.0
2017-10-10 08:00:00	AAPL	Stock	38.95	38.9975	38.9375	38.975	41560.0
2017-10-10 08:05:00	AAPL	Stock	38.975	38.995	38.97	38.99	24876.0
2017-10-10 08:10:00	AAPL	Stock	38.995	38.995	38.9825	38.9925	2800.0
2017-10-10 08:15:00	AAPL	Stock	38.9875	38.995	38.965	38.965	4800.0
2017-10-10 08:20:00	AAPL	Stock	38.965	38.995	38.965	38.995	4400.0
2017-10-10 08:25:00	AAPL	Stock	38.995	39.025	38.995	39.025	19648.0
2017-10-10 08:30:00	AAPL	Stock	39.025	39.025	39.0	39.025	20140.0
2017-10-10 08:35:00	AAPL	Stock	39.025	39.03	39.0125	39.03	18200.0
2017-10-10 08:40:00	AAPL	Stock	39.025	39.0325	39.025	39.0325	12264.0
2017-10-10 08:45:00	AAPL	Stock	39.03	39.03	39.0025	39.0025	12884.0
2017-10-10 08:50:00	AAPL	Stock	39.0025	39.0275	39.0025	39.0275	1600.0
2017-10-10 08:55:00	AAPL	Stock	39.02	39.0375	39.0025	39.025	33608.0
2017-10-10 09:00:00	AAPL	Stock	39.025	39.0375	39.02	39.0375	28364.0
2017-10-10 09:05:00	AAPL	Stock	39.03	39.0325	39.03	39.0325	2000.0
2017-10-10 09:10:00	AAPL	Stock	39.025	39.0375	39.025	39.0375	14824.0
2017-10-10 09:15:00	AAPL	Stock	39.03	39.0375	39.0225	39.0225	10628.0
2017-10-10 09:25:00	AAPL	Stock	39.025	39.025	38.9875	38.99	31868.0
2017-10-10 09:30:00	AAPL	Stock	39.0	39.09	38.9775	39.0575	3325584.0
2017-10-10 09:35:00	AAPL	Stock	39.055	39.5	39.0425	39.125	2646752.0
2017-10-10 09:40:00	AAPL	Stock	39.1225	39.13	39.06	39.0612	1411636.0
2017-10-10 09:45:00	AAPL	Stock	39.065	39.0825	39.0325	39.0475	999820.0
2017-10-10 09:50:00	AAPL	Stock	39.0495	39.0825	39.0325	39.0675	1197348.0
2017-10-10 09:55:00	AAPL	Stock	39.07	39.0822	39.0225	39.025	1159076.0
2017-10-10 10:00:00	AAPL	Stock	39.0325	39.0462	38.9852	38.9925	1309744.0
2017-10-10 10:05:00	AAPL	Stock	38.9925	39.0	38.905	38.951	1496500.0
2017-10-10 10:10:00	AAPL	Stock	38.955	38.98	38.9125	38.9263	1184336.0
2017-10-10 10:15:00	AAPL	Stock	38.9252	38.9263	38.7775	38.8075	1879132.0
2017-10-10 10:20:00	AAPL	Stock	38.805	38.8975	38.775	38.8725	1247160.0
2017-10-10 10:25:00	AAPL	Stock	38.875	38.925	38.8748	38.9175	710224.0
2017-10-10 10:30:00	AAPL	Stock	38.92	38.94	38.89	38.93	709552.0
2017-10-10 10:35:00	AAPL	Stock	38.9323	38.9378	38.8787	38.89	554684.0

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

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