PREVIEW / stock_5min / 2018-01-12

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-01-12.parquet
  size:    5.8 MB
  rows:    367,248
  symbols: 2,902

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-01-12 04:00:00	AAPL	Stock	43.925	43.925	43.925	43.925	3720.0
2018-01-12 04:40:00	AAPL	Stock	43.8675	43.8675	43.8675	43.8675	600.0
2018-01-12 04:50:00	AAPL	Stock	43.8675	43.8675	43.85	43.85	6600.0
2018-01-12 05:00:00	AAPL	Stock	43.85	43.85	43.85	43.85	800.0
2018-01-12 06:30:00	AAPL	Stock	43.935	43.935	43.935	43.935	804.0
2018-01-12 06:45:00	AAPL	Stock	43.915	43.915	43.9125	43.9125	2400.0
2018-01-12 06:50:00	AAPL	Stock	43.9125	43.9125	43.9125	43.9125	640.0
2018-01-12 07:00:00	AAPL	Stock	43.8875	43.8975	43.875	43.8825	3372.0
2018-01-12 07:05:00	AAPL	Stock	43.9	43.9	43.8875	43.89	8600.0
2018-01-12 07:10:00	AAPL	Stock	43.89	43.91	43.86	43.91	8744.0
2018-01-12 07:15:00	AAPL	Stock	43.9125	43.92	43.9125	43.92	800.0
2018-01-12 07:20:00	AAPL	Stock	43.92	43.935	43.9125	43.925	19700.0
2018-01-12 07:25:00	AAPL	Stock	43.9325	43.95	43.92	43.9275	30104.0
2018-01-12 07:30:00	AAPL	Stock	43.9425	43.945	43.9425	43.945	1924.0
2018-01-12 07:35:00	AAPL	Stock	43.93	43.9425	43.9225	43.9375	11204.0
2018-01-12 07:40:00	AAPL	Stock	43.935	43.9375	43.935	43.9375	10636.0
2018-01-12 07:45:00	AAPL	Stock	43.9375	43.95	43.9375	43.95	3296.0
2018-01-12 07:50:00	AAPL	Stock	43.93	43.985	43.925	43.985	22400.0
2018-01-12 07:55:00	AAPL	Stock	43.975	43.9775	43.97	43.9775	4156.0
2018-01-12 08:00:00	AAPL	Stock	43.875	43.9775	43.875	43.975	26104.0
2018-01-12 08:05:00	AAPL	Stock	43.975	44.0175	43.975	44.0	94700.0
2018-01-12 08:10:00	AAPL	Stock	43.99	43.995	43.975	43.99	11704.0
2018-01-12 08:15:00	AAPL	Stock	44.0	44.0125	43.9825	44.0	23944.0
2018-01-12 08:20:00	AAPL	Stock	44.01	44.0825	44.0	44.0825	89440.0
2018-01-12 08:25:00	AAPL	Stock	44.07	44.1275	44.0625	44.1225	94220.0
2018-01-12 08:30:00	AAPL	Stock	44.1225	44.15	44.0625	44.0675	206640.0
2018-01-12 08:35:00	AAPL	Stock	44.0675	44.0675	43.9375	44.0	154852.0
2018-01-12 08:40:00	AAPL	Stock	43.9875	44.0325	43.9775	43.9775	31596.0
2018-01-12 08:45:00	AAPL	Stock	44.0	44.02	43.9575	43.9575	44224.0
2018-01-12 08:50:00	AAPL	Stock	43.95	43.9625	43.925	43.925	95808.0
2018-01-12 08:55:00	AAPL	Stock	43.9225	43.9375	43.9025	43.9125	65980.0
2018-01-12 09:00:00	AAPL	Stock	43.92	43.975	43.905	43.9625	74796.0
2018-01-12 09:05:00	AAPL	Stock	43.975	43.975	43.9525	43.975	23484.0
2018-01-12 09:10:00	AAPL	Stock	43.975	43.975	43.9175	43.96	26096.0
2018-01-12 09:15:00	AAPL	Stock	43.9425	43.9425	43.91	43.93	8600.0
2018-01-12 09:20:00	AAPL	Stock	43.9225	43.9275	43.905	43.925	20456.0
2018-01-12 09:25:00	AAPL	Stock	43.91	44.0125	43.91	44.0025	83392.0
2018-01-12 09:30:00	AAPL	Stock	44.045	44.0825	43.9425	44.0475	4825624.0
2018-01-12 09:35:00	AAPL	Stock	44.0475	44.0825	44.0	44.011	2162452.0
2018-01-12 09:40:00	AAPL	Stock	44.0075	44.0425	43.9588	43.9988	1866080.0
2018-01-12 09:45:00	AAPL	Stock	43.9975	44.01	43.9125	44.005	1988228.0
2018-01-12 09:50:00	AAPL	Stock	44.01	44.0275	43.9688	43.989	778940.0
2018-01-12 09:55:00	AAPL	Stock	43.9915	44.0125	43.975	43.9925	1019312.0
2018-01-12 10:00:00	AAPL	Stock	43.9925	44.0375	43.986	44.0338	908608.0
2018-01-12 10:05:00	AAPL	Stock	44.034	44.045	43.9975	44.0305	924200.0
2018-01-12 10:10:00	AAPL	Stock	44.0325	44.04	44.0075	44.0332	659812.0
2018-01-12 10:15:00	AAPL	Stock	44.0325	44.0825	44.0318	44.0775	1203632.0
2018-01-12 10:20:00	AAPL	Stock	44.08	44.083	44.04	44.055	921424.0
2018-01-12 10:25:00	AAPL	Stock	44.0552	44.0988	44.0525	44.0975	983084.0
2018-01-12 10:30:00	AAPL	Stock	44.0975	44.1175	44.09	44.1058	1120928.0

> showing 50 of 367,248 rows — these rows as CSV

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