PREVIEW / stock_5min / 2013-09-09

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-09-09.parquet
  size:    5.2 MB
  rows:    342,903
  symbols: 3,531

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
2013-09-09 04:00:00	AAPL	Stock	18.0268	18.0393	17.9757	18.0357	74200.0
2013-09-09 04:05:00	AAPL	Stock	18.0357	18.0357	18.0296	18.0357	72800.0
2013-09-09 04:10:00	AAPL	Stock	18.0357	18.0543	18.0357	18.0543	17472.0
2013-09-09 04:15:00	AAPL	Stock	18.0429	18.0429	18.0268	18.0268	39200.0
2013-09-09 04:25:00	AAPL	Stock	18.0225	18.0225	18.0225	18.0225	2800.0
2013-09-09 04:30:00	AAPL	Stock	18.0357	18.0582	18.0357	18.0582	25200.0
2013-09-09 04:35:00	AAPL	Stock	18.0589	18.0696	18.0589	18.0696	14000.0
2013-09-09 04:40:00	AAPL	Stock	18.0696	18.1036	18.0529	18.0714	34300.0
2013-09-09 04:45:00	AAPL	Stock	18.0636	18.0636	18.0536	18.0536	11200.0
2013-09-09 04:55:00	AAPL	Stock	18.0393	18.0393	18.0354	18.0393	12600.0
2013-09-09 05:00:00	AAPL	Stock	18.0354	18.0354	18.0354	18.0354	7000.0
2013-09-09 05:05:00	AAPL	Stock	18.0168	18.0339	18.0168	18.025	65296.0
2013-09-09 05:10:00	AAPL	Stock	18.0179	18.0179	18.0179	18.0179	3500.0
2013-09-09 05:20:00	AAPL	Stock	18.0179	18.0179	18.0179	18.0179	2800.0
2013-09-09 05:45:00	AAPL	Stock	18.0179	18.0179	18.0071	18.0071	5600.0
2013-09-09 05:50:00	AAPL	Stock	18.0071	18.0193	18.0039	18.0193	11424.0
2013-09-09 06:00:00	AAPL	Stock	18.0193	18.0357	18.0193	18.0357	15596.0
2013-09-09 06:05:00	AAPL	Stock	18.0139	18.0139	18.0132	18.0132	30800.0
2013-09-09 06:15:00	AAPL	Stock	18.0182	18.0182	18.0182	18.0182	5600.0
2013-09-09 06:25:00	AAPL	Stock	18.0354	18.0357	18.0286	18.0286	22456.0
2013-09-09 06:30:00	AAPL	Stock	18.0229	18.0229	18.0182	18.0182	21616.0
2013-09-09 06:35:00	AAPL	Stock	18.0089	18.0089	18.0043	18.0043	36400.0
2013-09-09 06:40:00	AAPL	Stock	18.0	18.0	18.0	18.0	14000.0
2013-09-09 06:50:00	AAPL	Stock	18.0	18.0	17.9911	17.9911	22400.0
2013-09-09 06:55:00	AAPL	Stock	17.9911	17.9911	17.9857	17.9911	40012.0
2013-09-09 07:00:00	AAPL	Stock	17.9807	17.9911	17.9679	17.975	215936.0
2013-09-09 07:05:00	AAPL	Stock	17.9736	17.9761	17.9679	17.9679	341348.0
2013-09-09 07:10:00	AAPL	Stock	17.9679	17.9857	17.9679	17.9857	65520.0
2013-09-09 07:15:00	AAPL	Stock	18.0	18.0214	18.0	18.0214	186564.0
2013-09-09 07:20:00	AAPL	Stock	18.0229	18.0229	18.0018	18.0075	126448.0
2013-09-09 07:25:00	AAPL	Stock	18.0075	18.0136	18.0018	18.0132	32200.0
2013-09-09 07:30:00	AAPL	Stock	18.0136	18.0136	18.0075	18.0136	105560.0
2013-09-09 07:35:00	AAPL	Stock	18.0164	18.0225	18.0086	18.0161	239988.0
2013-09-09 07:40:00	AAPL	Stock	18.0214	18.0225	18.0036	18.0036	334656.0
2013-09-09 07:45:00	AAPL	Stock	18.0021	18.0032	17.9836	17.9843	103180.0
2013-09-09 07:50:00	AAPL	Stock	17.9939	17.9943	17.985	17.9939	34020.0
2013-09-09 07:55:00	AAPL	Stock	17.9868	17.9868	17.975	17.9807	143080.0
2013-09-09 08:00:00	AAPL	Stock	17.9996	18.0225	17.9646	18.0021	814408.0
2013-09-09 08:05:00	AAPL	Stock	18.0054	18.0357	18.0054	18.0321	509712.0
2013-09-09 08:10:00	AAPL	Stock	18.0321	18.0411	18.0214	18.0357	537628.0
2013-09-09 08:15:00	AAPL	Stock	18.0321	18.0357	18.0179	18.0296	514528.0
2013-09-09 08:20:00	AAPL	Stock	18.0279	18.0286	18.0171	18.0171	337288.0
2013-09-09 08:25:00	AAPL	Stock	18.0161	18.0182	18.0	18.0046	328804.0
2013-09-09 08:30:00	AAPL	Stock	18.0068	18.0236	18.0068	18.0186	269248.0
2013-09-09 08:35:00	AAPL	Stock	18.0189	18.0204	18.005	18.0104	385056.0
2013-09-09 08:40:00	AAPL	Stock	18.0104	18.0136	18.0054	18.0125	443492.0
2013-09-09 08:45:00	AAPL	Stock	18.0125	18.0246	18.0107	18.0246	327768.0
2013-09-09 08:50:00	AAPL	Stock	18.0243	18.0446	18.0204	18.0404	729764.0
2013-09-09 08:55:00	AAPL	Stock	18.0393	18.0579	18.0357	18.0579	745444.0
2013-09-09 09:00:00	AAPL	Stock	18.055	18.0786	18.0536	18.0782	851956.0

> showing 50 of 342,903 rows — these rows as CSV

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