PREVIEW / stock_5min / 2017-05-16

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-05-16.parquet
  size:    5.4 MB
  rows:    353,454
  symbols: 3,030

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-05-16 04:00:00	AAPL	Stock	38.975	38.975	38.975	38.975	520.0
2017-05-16 04:05:00	AAPL	Stock	38.975	38.9875	38.975	38.9875	3984.0
2017-05-16 04:15:00	AAPL	Stock	38.975	38.975	38.975	38.975	2432.0
2017-05-16 04:55:00	AAPL	Stock	38.9725	38.9725	38.9725	38.9725	400.0
2017-05-16 05:10:00	AAPL	Stock	38.97	38.97	38.97	38.97	800.0
2017-05-16 05:50:00	AAPL	Stock	38.96	38.96	38.96	38.96	648.0
2017-05-16 05:55:00	AAPL	Stock	38.95	38.95	38.95	38.95	600.0
2017-05-16 06:30:00	AAPL	Stock	38.975	38.975	38.975	38.975	400.0
2017-05-16 06:35:00	AAPL	Stock	38.975	38.975	38.975	38.975	3600.0
2017-05-16 06:45:00	AAPL	Stock	38.9875	38.9875	38.9875	38.9875	400.0
2017-05-16 07:05:00	AAPL	Stock	38.9875	38.9875	38.9875	38.9875	400.0
2017-05-16 07:10:00	AAPL	Stock	38.9975	39.0	38.9875	39.0	7152.0
2017-05-16 07:15:00	AAPL	Stock	39.0075	39.0225	39.0075	39.0225	2800.0
2017-05-16 07:25:00	AAPL	Stock	39.0125	39.025	39.0125	39.025	4200.0
2017-05-16 07:30:00	AAPL	Stock	39.0425	39.0425	39.0425	39.0425	2200.0
2017-05-16 07:35:00	AAPL	Stock	39.0375	39.0375	39.0375	39.0375	1200.0
2017-05-16 07:40:00	AAPL	Stock	39.0375	39.0425	39.0375	39.0425	6000.0
2017-05-16 07:45:00	AAPL	Stock	39.0375	39.0375	39.0375	39.0375	1200.0
2017-05-16 07:50:00	AAPL	Stock	39.0425	39.0475	39.0425	39.0475	800.0
2017-05-16 07:55:00	AAPL	Stock	39.0425	39.0425	39.0425	39.0425	800.0
2017-05-16 08:00:00	AAPL	Stock	39.0375	39.065	39.0375	39.055	26816.0
2017-05-16 08:05:00	AAPL	Stock	39.0625	39.0625	39.0625	39.0625	4440.0
2017-05-16 08:10:00	AAPL	Stock	39.05	39.0625	39.025	39.025	34872.0
2017-05-16 08:15:00	AAPL	Stock	39.025	39.0475	39.025	39.0475	19200.0
2017-05-16 08:20:00	AAPL	Stock	39.0275	39.0325	39.025	39.025	17200.0
2017-05-16 08:25:00	AAPL	Stock	39.025	39.025	39.0	39.0	20436.0
2017-05-16 08:30:00	AAPL	Stock	38.9875	39.0225	38.9875	39.0	41416.0
2017-05-16 08:35:00	AAPL	Stock	38.995	39.0	38.9875	38.9925	11084.0
2017-05-16 08:40:00	AAPL	Stock	39.0	39.0375	39.0	39.0325	36064.0
2017-05-16 08:45:00	AAPL	Stock	39.035	39.05	39.025	39.045	23812.0
2017-05-16 08:50:00	AAPL	Stock	39.0425	39.045	39.0275	39.045	12136.0
2017-05-16 08:55:00	AAPL	Stock	39.0425	39.0425	39.0425	39.0425	400.0
2017-05-16 09:00:00	AAPL	Stock	39.025	39.0375	39.025	39.0375	8188.0
2017-05-16 09:05:00	AAPL	Stock	39.0375	39.0375	39.0225	39.0225	10200.0
2017-05-16 09:10:00	AAPL	Stock	39.0175	39.0175	39.0	39.0	56780.0
2017-05-16 09:15:00	AAPL	Stock	39.0	39.005	38.9875	39.005	25360.0
2017-05-16 09:20:00	AAPL	Stock	39.005	39.005	38.975	38.975	33604.0
2017-05-16 09:25:00	AAPL	Stock	38.995	39.0175	38.98	38.9925	49260.0
2017-05-16 09:30:00	AAPL	Stock	38.985	39.015	38.92	38.9225	4199600.0
2017-05-16 09:35:00	AAPL	Stock	38.9288	38.9625	38.8275	38.885	2163396.0
2017-05-16 09:40:00	AAPL	Stock	38.89	38.9075	38.8	38.805	1959876.0
2017-05-16 09:45:00	AAPL	Stock	38.8075	38.9125	38.8062	38.89	1655812.0
2017-05-16 09:50:00	AAPL	Stock	38.89	38.97	38.86	38.9662	1140528.0
2017-05-16 09:55:00	AAPL	Stock	38.9675	38.9675	38.86	38.8675	1178252.0
2017-05-16 10:00:00	AAPL	Stock	38.8675	38.9138	38.8612	38.9075	851056.0
2017-05-16 10:05:00	AAPL	Stock	38.9075	38.9275	38.8638	38.865	1136292.0
2017-05-16 10:10:00	AAPL	Stock	38.8662	38.875	38.825	38.835	971564.0
2017-05-16 10:15:00	AAPL	Stock	38.835	38.8625	38.82	38.8575	871168.0
2017-05-16 10:20:00	AAPL	Stock	38.861	38.8675	38.7775	38.795	1373444.0
2017-05-16 10:25:00	AAPL	Stock	38.7932	38.8175	38.7	38.7012	2501216.0

> showing 50 of 353,454 rows — these rows as CSV

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