PREVIEW / stock_5min / 2016-06-20

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-06-20.parquet
  size:    5.4 MB
  rows:    362,355
  symbols: 3,295

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
2016-06-20 04:00:00	AAPL	Stock	23.8625	24.0825	23.8625	24.0775	8960.0
2016-06-20 04:05:00	AAPL	Stock	24.0775	24.0875	24.0775	24.0875	2880.0
2016-06-20 04:20:00	AAPL	Stock	24.0875	24.0875	24.08	24.08	1784.0
2016-06-20 04:35:00	AAPL	Stock	24.075	24.075	24.075	24.075	2800.0
2016-06-20 04:40:00	AAPL	Stock	24.075	24.075	24.075	24.075	800.0
2016-06-20 04:55:00	AAPL	Stock	24.0875	24.0875	24.0875	24.0875	400.0
2016-06-20 05:05:00	AAPL	Stock	24.075	24.09	24.075	24.09	800.0
2016-06-20 05:15:00	AAPL	Stock	24.095	24.095	24.095	24.095	4000.0
2016-06-20 05:20:00	AAPL	Stock	24.1	24.1	24.1	24.1	704.0
2016-06-20 05:30:00	AAPL	Stock	24.095	24.095	24.095	24.095	10000.0
2016-06-20 05:40:00	AAPL	Stock	24.0875	24.0875	24.0875	24.0875	2000.0
2016-06-20 05:45:00	AAPL	Stock	24.0825	24.0825	24.0825	24.0825	1600.0
2016-06-20 05:55:00	AAPL	Stock	24.0975	24.0975	24.0975	24.0975	464.0
2016-06-20 06:00:00	AAPL	Stock	24.0875	24.0875	24.065	24.065	6436.0
2016-06-20 06:05:00	AAPL	Stock	24.0725	24.0875	24.0725	24.0875	3464.0
2016-06-20 06:20:00	AAPL	Stock	24.085	24.0875	24.085	24.0875	1412.0
2016-06-20 06:25:00	AAPL	Stock	24.0775	24.0775	24.075	24.075	4516.0
2016-06-20 06:30:00	AAPL	Stock	24.075	24.075	24.075	24.075	2720.0
2016-06-20 06:35:00	AAPL	Stock	24.075	24.075	24.075	24.075	1200.0
2016-06-20 06:45:00	AAPL	Stock	24.075	24.075	24.065	24.065	2000.0
2016-06-20 06:55:00	AAPL	Stock	24.065	24.095	24.065	24.0875	8992.0
2016-06-20 07:00:00	AAPL	Stock	24.1	24.11	24.0875	24.11	26992.0
2016-06-20 07:05:00	AAPL	Stock	24.115	24.12	24.09	24.09	14972.0
2016-06-20 07:10:00	AAPL	Stock	24.075	24.1	24.075	24.0975	14800.0
2016-06-20 07:15:00	AAPL	Stock	24.0975	24.1	24.0875	24.1	22756.0
2016-06-20 07:20:00	AAPL	Stock	24.1125	24.1125	24.0825	24.0825	11128.0
2016-06-20 07:25:00	AAPL	Stock	24.0825	24.0825	24.0825	24.0825	1984.0
2016-06-20 07:30:00	AAPL	Stock	24.0825	24.1	24.0825	24.0825	18548.0
2016-06-20 07:35:00	AAPL	Stock	24.1	24.1125	24.05	24.0525	44504.0
2016-06-20 07:40:00	AAPL	Stock	24.0625	24.075	24.0275	24.04	11680.0
2016-06-20 07:50:00	AAPL	Stock	24.05	24.0625	24.025	24.025	29660.0
2016-06-20 07:55:00	AAPL	Stock	24.0325	24.055	24.0325	24.0475	16876.0
2016-06-20 08:00:00	AAPL	Stock	24.0475	24.1125	24.0	24.0425	143572.0
2016-06-20 08:05:00	AAPL	Stock	24.0475	24.055	24.0425	24.0475	47428.0
2016-06-20 08:10:00	AAPL	Stock	24.0475	24.0525	24.0425	24.045	46692.0
2016-06-20 08:15:00	AAPL	Stock	24.045	24.05	24.0375	24.0425	40396.0
2016-06-20 08:20:00	AAPL	Stock	24.045	24.05	24.0375	24.0375	28804.0
2016-06-20 08:25:00	AAPL	Stock	24.0425	24.0425	24.025	24.025	99540.0
2016-06-20 08:30:00	AAPL	Stock	24.025	24.0325	24.0175	24.025	35072.0
2016-06-20 08:35:00	AAPL	Stock	24.03	24.0375	24.0125	24.0275	156356.0
2016-06-20 08:40:00	AAPL	Stock	24.0325	24.035	24.025	24.03	19600.0
2016-06-20 08:45:00	AAPL	Stock	24.025	24.03	24.02	24.02	17960.0
2016-06-20 08:50:00	AAPL	Stock	24.015	24.025	23.9825	24.0	98396.0
2016-06-20 08:55:00	AAPL	Stock	23.9875	24.0	23.9825	23.9975	12300.0
2016-06-20 09:00:00	AAPL	Stock	23.99	24.005	23.99	24.0	25128.0
2016-06-20 09:05:00	AAPL	Stock	24.0	24.0075	23.975	24.0075	24824.0
2016-06-20 09:10:00	AAPL	Stock	24.005	24.02	24.0	24.02	34160.0
2016-06-20 09:15:00	AAPL	Stock	24.02	24.0225	24.0025	24.005	37468.0
2016-06-20 09:20:00	AAPL	Stock	24.01	24.0175	24.0075	24.0125	29104.0
2016-06-20 09:25:00	AAPL	Stock	24.0125	24.0825	24.005	24.005	352420.0

> showing 50 of 362,355 rows — these rows as CSV

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