PREVIEW / stock_5min / 2018-01-19

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-01-19.parquet
  size:    5.7 MB
  rows:    365,694
  symbols: 2,901

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-19 04:00:00	AAPL	Stock	44.725	44.725	44.725	44.725	3096.0
2018-01-19 04:05:00	AAPL	Stock	44.8075	44.815	44.8075	44.815	1600.0
2018-01-19 04:20:00	AAPL	Stock	44.875	44.875	44.875	44.875	1600.0
2018-01-19 04:25:00	AAPL	Stock	44.875	44.875	44.875	44.875	400.0
2018-01-19 04:35:00	AAPL	Stock	44.9175	44.925	44.9175	44.925	5188.0
2018-01-19 04:45:00	AAPL	Stock	44.9375	44.9375	44.9375	44.9375	692.0
2018-01-19 04:55:00	AAPL	Stock	44.9425	44.9425	44.9425	44.9425	400.0
2018-01-19 05:25:00	AAPL	Stock	44.8875	44.8875	44.88	44.88	3800.0
2018-01-19 06:00:00	AAPL	Stock	44.88	44.88	44.88	44.88	800.0
2018-01-19 06:15:00	AAPL	Stock	44.875	44.875	44.8725	44.875	2660.0
2018-01-19 06:20:00	AAPL	Stock	44.8725	44.8725	44.8725	44.8725	400.0
2018-01-19 06:30:00	AAPL	Stock	44.8725	44.8725	44.8275	44.84	11204.0
2018-01-19 06:35:00	AAPL	Stock	44.8625	44.875	44.8375	44.85	19936.0
2018-01-19 06:40:00	AAPL	Stock	44.85	44.85	44.825	44.825	12024.0
2018-01-19 06:45:00	AAPL	Stock	44.8375	44.8375	44.8275	44.8275	4000.0
2018-01-19 06:50:00	AAPL	Stock	44.8275	44.8275	44.815	44.825	4400.0
2018-01-19 06:55:00	AAPL	Stock	44.8225	44.8225	44.8225	44.8225	400.0
2018-01-19 07:00:00	AAPL	Stock	44.815	44.815	44.7925	44.8125	12224.0
2018-01-19 07:05:00	AAPL	Stock	44.8125	44.8125	44.8125	44.8125	6800.0
2018-01-19 07:10:00	AAPL	Stock	44.8025	44.8025	44.7925	44.7925	22256.0
2018-01-19 07:15:00	AAPL	Stock	44.78	44.8	44.75	44.8	47224.0
2018-01-19 07:20:00	AAPL	Stock	44.8025	44.82	44.8025	44.82	6248.0
2018-01-19 07:25:00	AAPL	Stock	44.84	44.84	44.8125	44.8125	6200.0
2018-01-19 07:30:00	AAPL	Stock	44.8125	44.83	44.8125	44.83	2008.0
2018-01-19 07:35:00	AAPL	Stock	44.815	44.815	44.8	44.8	20600.0
2018-01-19 07:40:00	AAPL	Stock	44.8	44.8	44.8	44.8	2400.0
2018-01-19 07:45:00	AAPL	Stock	44.79	44.79	44.79	44.79	800.0
2018-01-19 07:50:00	AAPL	Stock	44.8	44.815	44.8	44.815	10612.0
2018-01-19 07:55:00	AAPL	Stock	44.8	44.8125	44.8	44.8125	1440.0
2018-01-19 08:00:00	AAPL	Stock	44.825	44.85	44.7775	44.78	62628.0
2018-01-19 08:05:00	AAPL	Stock	44.8	44.8	44.775	44.7875	29852.0
2018-01-19 08:10:00	AAPL	Stock	44.775	44.7875	44.7625	44.7875	12448.0
2018-01-19 08:15:00	AAPL	Stock	44.8	44.8	44.7875	44.7875	47800.0
2018-01-19 08:20:00	AAPL	Stock	44.7975	44.815	44.7625	44.7625	31704.0
2018-01-19 08:25:00	AAPL	Stock	44.7625	44.7625	44.75	44.75	13972.0
2018-01-19 08:30:00	AAPL	Stock	44.7425	44.755	44.7225	44.7525	21704.0
2018-01-19 08:35:00	AAPL	Stock	44.75	44.7525	44.7275	44.7275	6136.0
2018-01-19 08:40:00	AAPL	Stock	44.7475	44.7525	44.745	44.7525	5968.0
2018-01-19 08:45:00	AAPL	Stock	44.75	44.7675	44.7275	44.7275	16984.0
2018-01-19 08:50:00	AAPL	Stock	44.7475	44.7475	44.7275	44.7275	19252.0
2018-01-19 08:55:00	AAPL	Stock	44.7375	44.7475	44.685	44.7125	82108.0
2018-01-19 09:00:00	AAPL	Stock	44.725	44.725	44.7	44.7125	26616.0
2018-01-19 09:05:00	AAPL	Stock	44.71	44.7125	44.6025	44.6175	171004.0
2018-01-19 09:10:00	AAPL	Stock	44.625	44.71	44.5625	44.6	100360.0
2018-01-19 09:15:00	AAPL	Stock	44.625	44.625	44.605	44.6225	68404.0
2018-01-19 09:20:00	AAPL	Stock	44.625	44.625	44.6	44.625	78604.0
2018-01-19 09:25:00	AAPL	Stock	44.64	44.755	44.625	44.6525	267016.0
2018-01-19 09:30:00	AAPL	Stock	44.63	44.845	44.625	44.8225	13053448.0
2018-01-19 09:35:00	AAPL	Stock	44.8225	44.88	44.765	44.873	2203504.0
2018-01-19 09:40:00	AAPL	Stock	44.8775	44.895	44.83	44.845	1988936.0

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

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