PREVIEW / stock_5min / 2014-06-18

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-06-18.parquet
  size:    5.4 MB
  rows:    360,856
  symbols: 3,563

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
2014-06-18 04:00:00	AAPL	Stock	23.065	23.065	23.065	23.065	4000.0
2014-06-18 04:20:00	AAPL	Stock	23.05	23.05	23.05	23.05	800.0
2014-06-18 04:25:00	AAPL	Stock	23.025	23.025	23.025	23.025	800.0
2014-06-18 04:45:00	AAPL	Stock	23.045	23.05	23.045	23.05	2800.0
2014-06-18 05:40:00	AAPL	Stock	23.055	23.0575	23.055	23.0575	2400.0
2014-06-18 05:45:00	AAPL	Stock	23.055	23.065	23.055	23.065	2800.0
2014-06-18 06:10:00	AAPL	Stock	23.06	23.06	23.06	23.06	724.0
2014-06-18 06:25:00	AAPL	Stock	23.0625	23.065	23.0625	23.065	4000.0
2014-06-18 06:30:00	AAPL	Stock	23.06	23.06	23.06	23.06	800.0
2014-06-18 06:35:00	AAPL	Stock	23.055	23.06	23.05	23.06	3000.0
2014-06-18 06:45:00	AAPL	Stock	23.0475	23.05	23.0475	23.05	4876.0
2014-06-18 06:50:00	AAPL	Stock	23.07	23.07	23.07	23.07	400.0
2014-06-18 06:55:00	AAPL	Stock	23.0575	23.0575	23.0575	23.0575	676.0
2014-06-18 07:00:00	AAPL	Stock	23.0575	23.0575	23.0525	23.055	6304.0
2014-06-18 07:05:00	AAPL	Stock	23.055	23.065	23.055	23.065	5200.0
2014-06-18 07:10:00	AAPL	Stock	23.055	23.055	23.055	23.055	2560.0
2014-06-18 07:15:00	AAPL	Stock	23.055	23.055	23.055	23.055	7772.0
2014-06-18 07:20:00	AAPL	Stock	23.05	23.0825	23.0425	23.0825	24080.0
2014-06-18 07:25:00	AAPL	Stock	23.0825	23.1825	23.0825	23.175	166900.0
2014-06-18 07:30:00	AAPL	Stock	23.1825	23.25	23.1375	23.22	85056.0
2014-06-18 07:35:00	AAPL	Stock	23.1975	23.1975	23.175	23.1925	53164.0
2014-06-18 07:40:00	AAPL	Stock	23.195	23.195	23.175	23.175	8400.0
2014-06-18 07:45:00	AAPL	Stock	23.1775	23.1875	23.1625	23.1625	46400.0
2014-06-18 07:50:00	AAPL	Stock	23.1575	23.1625	23.1525	23.1525	2900.0
2014-06-18 07:55:00	AAPL	Stock	23.1525	23.16	23.14	23.16	8120.0
2014-06-18 08:00:00	AAPL	Stock	23.145	23.1975	23.055	23.105	94528.0
2014-06-18 08:05:00	AAPL	Stock	23.105	23.1125	23.0875	23.105	21800.0
2014-06-18 08:10:00	AAPL	Stock	23.1025	23.125	23.1	23.1225	58116.0
2014-06-18 08:15:00	AAPL	Stock	23.1225	23.125	23.11	23.1225	46428.0
2014-06-18 08:20:00	AAPL	Stock	23.1125	23.1225	23.1125	23.1225	13044.0
2014-06-18 08:25:00	AAPL	Stock	23.1225	23.1225	23.1075	23.1075	22920.0
2014-06-18 08:30:00	AAPL	Stock	23.1175	23.1225	23.1075	23.12	17900.0
2014-06-18 08:35:00	AAPL	Stock	23.1225	23.1225	23.11	23.11	6412.0
2014-06-18 08:40:00	AAPL	Stock	23.12	23.1375	23.12	23.1375	49520.0
2014-06-18 08:45:00	AAPL	Stock	23.1325	23.1325	23.12	23.12	27592.0
2014-06-18 08:50:00	AAPL	Stock	23.12	23.125	23.12	23.125	44760.0
2014-06-18 08:55:00	AAPL	Stock	23.1225	23.125	23.12	23.12	29600.0
2014-06-18 09:00:00	AAPL	Stock	23.125	23.13	23.12	23.1275	21212.0
2014-06-18 09:05:00	AAPL	Stock	23.1225	23.125	23.1175	23.1175	24084.0
2014-06-18 09:10:00	AAPL	Stock	23.115	23.115	23.09	23.1	60908.0
2014-06-18 09:15:00	AAPL	Stock	23.1	23.1075	23.065	23.07	81056.0
2014-06-18 09:20:00	AAPL	Stock	23.0675	23.0875	23.065	23.0875	142140.0
2014-06-18 09:25:00	AAPL	Stock	23.1075	23.115	23.05	23.0675	201680.0
2014-06-18 09:30:00	AAPL	Stock	23.0675	23.0725	22.965	22.983	6014132.0
2014-06-18 09:35:00	AAPL	Stock	22.9825	23.0225	22.9675	23.0125	3808572.0
2014-06-18 09:40:00	AAPL	Stock	23.015	23.02	22.925	22.95	3601892.0
2014-06-18 09:45:00	AAPL	Stock	22.95	22.9775	22.9325	22.955	2135768.0
2014-06-18 09:50:00	AAPL	Stock	22.955	22.965	22.93	22.965	2046320.0
2014-06-18 09:55:00	AAPL	Stock	22.9625	22.99	22.935	22.94	2121836.0
2014-06-18 10:00:00	AAPL	Stock	22.94	22.945	22.8675	22.87	3613984.0

> showing 50 of 360,856 rows — these rows as CSV

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