PREVIEW / stock_5min / 2018-03-23

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-03-23.parquet
  size:    5.6 MB
  rows:    363,381
  symbols: 2,873

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-03-23 04:00:00	AAPL	Stock	42.0275	42.1125	42.025	42.025	11900.0
2018-03-23 04:05:00	AAPL	Stock	42.0	42.0	42.0	42.0	400.0
2018-03-23 04:10:00	AAPL	Stock	41.9575	41.9575	41.9575	41.9575	400.0
2018-03-23 04:15:00	AAPL	Stock	41.935	41.935	41.9	41.9	2088.0
2018-03-23 04:20:00	AAPL	Stock	41.9	41.9	41.8575	41.9	16440.0
2018-03-23 04:25:00	AAPL	Stock	41.875	41.875	41.85	41.85	1200.0
2018-03-23 04:30:00	AAPL	Stock	41.845	41.845	41.845	41.845	1428.0
2018-03-23 04:40:00	AAPL	Stock	41.845	41.845	41.8425	41.8425	4000.0
2018-03-23 04:50:00	AAPL	Stock	41.7775	41.7775	41.7775	41.7775	3600.0
2018-03-23 04:55:00	AAPL	Stock	41.8125	41.8125	41.75	41.8125	6400.0
2018-03-23 05:00:00	AAPL	Stock	41.8	41.8	41.8	41.8	400.0
2018-03-23 05:05:00	AAPL	Stock	41.8125	41.8125	41.8125	41.8125	400.0
2018-03-23 05:15:00	AAPL	Stock	41.8725	41.8725	41.7775	41.7775	800.0
2018-03-23 05:20:00	AAPL	Stock	41.79	41.79	41.775	41.775	7896.0
2018-03-23 05:25:00	AAPL	Stock	41.7975	41.7975	41.7925	41.7925	800.0
2018-03-23 05:30:00	AAPL	Stock	41.78	41.78	41.7525	41.7525	4208.0
2018-03-23 05:45:00	AAPL	Stock	41.7075	41.7075	41.7075	41.7075	1968.0
2018-03-23 05:50:00	AAPL	Stock	41.7075	41.7075	41.675	41.7	12168.0
2018-03-23 05:55:00	AAPL	Stock	41.6775	41.6775	41.675	41.675	3600.0
2018-03-23 06:05:00	AAPL	Stock	41.6325	41.6325	41.6325	41.6325	400.0
2018-03-23 06:10:00	AAPL	Stock	41.65	41.7375	41.65	41.7375	11092.0
2018-03-23 06:15:00	AAPL	Stock	41.7725	41.7925	41.7575	41.7925	10296.0
2018-03-23 06:20:00	AAPL	Stock	41.7925	41.805	41.7925	41.7925	47600.0
2018-03-23 06:25:00	AAPL	Stock	41.7925	41.8075	41.7925	41.805	17220.0
2018-03-23 06:30:00	AAPL	Stock	41.85	41.8975	41.85	41.8975	8444.0
2018-03-23 06:35:00	AAPL	Stock	41.9	41.9075	41.85	41.9075	14336.0
2018-03-23 06:40:00	AAPL	Stock	41.8925	41.9075	41.8925	41.9075	8548.0
2018-03-23 06:45:00	AAPL	Stock	41.9075	41.9375	41.9075	41.9375	2800.0
2018-03-23 06:55:00	AAPL	Stock	41.8775	41.8775	41.8775	41.8775	480.0
2018-03-23 07:00:00	AAPL	Stock	41.885	42.0475	41.885	42.025	52836.0
2018-03-23 07:05:00	AAPL	Stock	42.05	42.07	42.025	42.05	11440.0
2018-03-23 07:10:00	AAPL	Stock	42.055	42.055	42.0	42.025	19232.0
2018-03-23 07:15:00	AAPL	Stock	42.05	42.075	42.0425	42.075	9408.0
2018-03-23 07:20:00	AAPL	Stock	42.0425	42.0425	42.0375	42.04	6400.0
2018-03-23 07:25:00	AAPL	Stock	42.0725	42.0725	42.0375	42.04	3916.0
2018-03-23 07:30:00	AAPL	Stock	42.0	42.0	41.9675	41.9875	5996.0
2018-03-23 07:35:00	AAPL	Stock	42.035	42.1	42.025	42.025	20616.0
2018-03-23 07:40:00	AAPL	Stock	42.0375	42.0675	42.0375	42.0375	9284.0
2018-03-23 07:45:00	AAPL	Stock	42.0375	42.11	42.005	42.11	19692.0
2018-03-23 07:50:00	AAPL	Stock	42.12	42.195	42.11	42.1925	77588.0
2018-03-23 07:55:00	AAPL	Stock	42.1925	42.1925	42.155	42.1675	20088.0
2018-03-23 08:00:00	AAPL	Stock	42.1775	42.3375	41.95	42.3375	187064.0
2018-03-23 08:05:00	AAPL	Stock	42.3375	42.3375	42.1875	42.2	93784.0
2018-03-23 08:10:00	AAPL	Stock	42.1925	42.2875	42.17	42.225	80484.0
2018-03-23 08:15:00	AAPL	Stock	42.2125	42.2725	42.2125	42.2625	119360.0
2018-03-23 08:20:00	AAPL	Stock	42.2625	42.2875	42.2	42.235	36944.0
2018-03-23 08:25:00	AAPL	Stock	42.235	42.269	42.225	42.2525	34652.0
2018-03-23 08:30:00	AAPL	Stock	42.2525	42.3225	42.25	42.3	35656.0
2018-03-23 08:35:00	AAPL	Stock	42.3025	42.325	42.2975	42.3	31084.0
2018-03-23 08:40:00	AAPL	Stock	42.3175	42.3675	42.2775	42.2775	96396.0

> showing 50 of 363,381 rows — these rows as CSV

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