PREVIEW / stock_5min / 2018-10-31

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-10-31.parquet
  size:    5.8 MB
  rows:    365,512
  symbols: 2,789

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
2018-10-31 04:05:00	AAPL	Stock	54.0	54.0	54.0	54.0	400.0
2018-10-31 04:10:00	AAPL	Stock	54.0	54.0	54.0	54.0	4144.0
2018-10-31 04:15:00	AAPL	Stock	53.975	53.975	53.975	53.975	400.0
2018-10-31 04:20:00	AAPL	Stock	54.0	54.0	54.0	54.0	400.0
2018-10-31 04:25:00	AAPL	Stock	54.0	54.0	54.0	54.0	5596.0
2018-10-31 04:30:00	AAPL	Stock	54.1875	54.1875	54.1875	54.1875	800.0
2018-10-31 04:35:00	AAPL	Stock	54.175	54.18	54.175	54.18	2800.0
2018-10-31 04:40:00	AAPL	Stock	54.1175	54.175	54.1175	54.175	1248.0
2018-10-31 04:45:00	AAPL	Stock	54.185	54.185	54.18	54.18	2400.0
2018-10-31 04:50:00	AAPL	Stock	54.145	54.145	54.145	54.145	600.0
2018-10-31 04:55:00	AAPL	Stock	54.125	54.1725	54.125	54.1725	1648.0
2018-10-31 05:00:00	AAPL	Stock	54.1625	54.1725	54.1625	54.1725	2400.0
2018-10-31 05:05:00	AAPL	Stock	54.095	54.095	54.095	54.095	2000.0
2018-10-31 05:15:00	AAPL	Stock	54.075	54.075	54.075	54.075	520.0
2018-10-31 05:20:00	AAPL	Stock	54.075	54.075	54.0625	54.0625	7600.0
2018-10-31 05:25:00	AAPL	Stock	54.0625	54.1175	54.0625	54.1175	3440.0
2018-10-31 05:30:00	AAPL	Stock	54.125	54.155	54.1225	54.155	10680.0
2018-10-31 05:40:00	AAPL	Stock	54.075	54.075	54.0625	54.0625	2888.0
2018-10-31 05:45:00	AAPL	Stock	54.0225	54.025	54.0225	54.025	1704.0
2018-10-31 05:50:00	AAPL	Stock	54.0075	54.0075	54.0075	54.0075	2280.0
2018-10-31 05:55:00	AAPL	Stock	54.0375	54.0375	54.0375	54.0375	400.0
2018-10-31 06:00:00	AAPL	Stock	53.9775	53.9775	53.9775	53.9775	1760.0
2018-10-31 06:05:00	AAPL	Stock	53.9825	53.9825	53.9825	53.9825	400.0
2018-10-31 06:10:00	AAPL	Stock	53.9775	53.9775	53.975	53.975	2752.0
2018-10-31 06:15:00	AAPL	Stock	53.9625	53.995	53.9625	53.995	892.0
2018-10-31 06:25:00	AAPL	Stock	53.895	53.895	53.8625	53.8625	30752.0
2018-10-31 06:30:00	AAPL	Stock	53.8625	53.9125	53.85	53.8625	17400.0
2018-10-31 06:35:00	AAPL	Stock	53.8375	53.86	53.8375	53.86	1264.0
2018-10-31 06:40:00	AAPL	Stock	53.8875	53.925	53.8875	53.925	21720.0
2018-10-31 06:45:00	AAPL	Stock	53.95	53.9675	53.95	53.9675	2400.0
2018-10-31 06:50:00	AAPL	Stock	53.9625	53.985	53.9625	53.9625	6376.0
2018-10-31 06:55:00	AAPL	Stock	53.9625	53.9625	53.9275	53.9275	7268.0
2018-10-31 07:00:00	AAPL	Stock	53.975	53.9825	53.675	53.6925	460152.0
2018-10-31 07:05:00	AAPL	Stock	53.6875	53.8	53.655	53.785	43264.0
2018-10-31 07:10:00	AAPL	Stock	53.7975	53.7975	53.6875	53.725	31828.0
2018-10-31 07:15:00	AAPL	Stock	53.73	53.765	53.6975	53.7475	51072.0
2018-10-31 07:20:00	AAPL	Stock	53.7475	53.7625	53.7	53.7125	39432.0
2018-10-31 07:25:00	AAPL	Stock	53.705	53.705	53.6	53.6	51916.0
2018-10-31 07:30:00	AAPL	Stock	53.65	53.6625	53.625	53.625	18704.0
2018-10-31 07:35:00	AAPL	Stock	53.6025	53.625	53.6025	53.625	1204.0
2018-10-31 07:40:00	AAPL	Stock	53.6975	53.775	53.6975	53.775	19368.0
2018-10-31 07:45:00	AAPL	Stock	53.7925	53.8	53.75	53.75	33288.0
2018-10-31 07:50:00	AAPL	Stock	53.7625	53.875	53.7625	53.86	110372.0
2018-10-31 07:55:00	AAPL	Stock	53.8675	53.87	53.7875	53.7875	33080.0
2018-10-31 08:00:00	AAPL	Stock	53.9245	53.95	53.625	53.86	151888.0
2018-10-31 08:05:00	AAPL	Stock	53.8125	53.85	53.8125	53.8375	68592.0
2018-10-31 08:10:00	AAPL	Stock	53.8325	53.925	53.8325	53.925	38176.0
2018-10-31 08:15:00	AAPL	Stock	53.935	53.995	53.9075	53.985	93684.0
2018-10-31 08:20:00	AAPL	Stock	53.9875	54.0525	53.9875	54.0325	103108.0
2018-10-31 08:25:00	AAPL	Stock	54.0325	54.0625	53.95	53.95	71768.0

> showing 50 of 365,512 rows — these rows as CSV

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