PREVIEW / stock_5min / 2018-02-06

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-02-06.parquet
  size:    6.2 MB
  rows:    393,209
  symbols: 2,917

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-02-06 04:00:00	AAPL	Stock	38.9025	39.175	38.875	39.13	19224.0
2018-02-06 04:05:00	AAPL	Stock	39.0	39.1775	39.0	39.0	26760.0
2018-02-06 04:10:00	AAPL	Stock	39.1625	39.225	39.125	39.125	3144.0
2018-02-06 04:15:00	AAPL	Stock	39.1425	39.1575	39.09	39.155	7788.0
2018-02-06 04:20:00	AAPL	Stock	39.155	39.2075	39.155	39.2075	5708.0
2018-02-06 04:25:00	AAPL	Stock	39.2175	39.2175	39.19	39.19	5548.0
2018-02-06 04:30:00	AAPL	Stock	39.22	39.22	39.125	39.125	22420.0
2018-02-06 04:35:00	AAPL	Stock	39.1875	39.22	39.145	39.22	12008.0
2018-02-06 04:40:00	AAPL	Stock	39.125	39.125	38.96	39.005	18448.0
2018-02-06 04:45:00	AAPL	Stock	39.0025	39.0025	38.96	38.96	2460.0
2018-02-06 04:50:00	AAPL	Stock	38.9525	38.9875	38.905	38.9875	1600.0
2018-02-06 04:55:00	AAPL	Stock	39.0725	39.0725	39.0075	39.0075	20820.0
2018-02-06 05:00:00	AAPL	Stock	38.93	38.93	38.84	38.84	30784.0
2018-02-06 05:05:00	AAPL	Stock	38.8775	38.8775	38.7875	38.815	7464.0
2018-02-06 05:10:00	AAPL	Stock	38.9	38.9225	38.83	38.83	3796.0
2018-02-06 05:15:00	AAPL	Stock	38.92	38.9325	38.9025	38.91	12152.0
2018-02-06 05:20:00	AAPL	Stock	38.9525	38.9525	38.9075	38.9075	800.0
2018-02-06 05:25:00	AAPL	Stock	38.9025	38.9475	38.815	38.815	41008.0
2018-02-06 05:30:00	AAPL	Stock	38.8	38.8725	38.79	38.8725	1600.0
2018-02-06 05:35:00	AAPL	Stock	38.89	39.1725	38.89	39.1425	16260.0
2018-02-06 05:40:00	AAPL	Stock	39.0775	39.1375	39.0775	39.125	4000.0
2018-02-06 05:45:00	AAPL	Stock	39.145	39.145	39.0725	39.0775	11476.0
2018-02-06 05:50:00	AAPL	Stock	39.1225	39.1225	39.1225	39.1225	800.0
2018-02-06 05:55:00	AAPL	Stock	39.145	39.17	39.145	39.17	4412.0
2018-02-06 06:00:00	AAPL	Stock	39.13	39.17	39.075	39.075	32996.0
2018-02-06 06:05:00	AAPL	Stock	38.995	39.0275	38.925	38.95	33548.0
2018-02-06 06:10:00	AAPL	Stock	38.95	39.1375	38.95	39.025	7200.0
2018-02-06 06:20:00	AAPL	Stock	39.0075	39.0975	39.0	39.05	20772.0
2018-02-06 06:25:00	AAPL	Stock	39.0625	39.0625	39.0075	39.0075	4800.0
2018-02-06 06:30:00	AAPL	Stock	39.0075	39.0075	38.95	38.95	4680.0
2018-02-06 06:35:00	AAPL	Stock	38.8625	39.0625	38.835	39.04	31444.0
2018-02-06 06:40:00	AAPL	Stock	39.04	39.04	39.0	39.0	28492.0
2018-02-06 06:45:00	AAPL	Stock	38.9525	38.975	38.925	38.975	7384.0
2018-02-06 06:50:00	AAPL	Stock	38.9475	38.9475	38.8525	38.89	9348.0
2018-02-06 06:55:00	AAPL	Stock	38.835	38.835	38.775	38.8	25408.0
2018-02-06 07:00:00	AAPL	Stock	38.815	38.815	38.6225	38.655	76908.0
2018-02-06 07:05:00	AAPL	Stock	38.71	38.81	38.64	38.73	58652.0
2018-02-06 07:10:00	AAPL	Stock	38.795	38.8125	38.635	38.74	36028.0
2018-02-06 07:15:00	AAPL	Stock	38.74	38.8375	38.7375	38.82	38896.0
2018-02-06 07:20:00	AAPL	Stock	38.825	39.005	38.6875	38.98	115708.0
2018-02-06 07:25:00	AAPL	Stock	39.0	39.1325	38.88	38.925	57980.0
2018-02-06 07:30:00	AAPL	Stock	38.925	38.975	38.85	38.9	36860.0
2018-02-06 07:35:00	AAPL	Stock	38.9325	38.9625	38.8375	38.8375	27212.0
2018-02-06 07:40:00	AAPL	Stock	38.85	38.8975	38.8125	38.8975	36872.0
2018-02-06 07:45:00	AAPL	Stock	38.875	38.875	38.7775	38.8	40472.0
2018-02-06 07:50:00	AAPL	Stock	38.81	38.875	38.775	38.875	30504.0
2018-02-06 07:55:00	AAPL	Stock	38.875	39.03	38.85	38.9475	69224.0
2018-02-06 08:00:00	AAPL	Stock	39.0	39.125	38.625	38.855	212500.0
2018-02-06 08:05:00	AAPL	Stock	38.8525	38.91	38.8075	38.8625	67912.0
2018-02-06 08:10:00	AAPL	Stock	38.835	38.9125	38.835	38.875	57660.0

> showing 50 of 393,209 rows — these rows as CSV

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