PREVIEW / stock_5min / 2012-01-27

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-01-27.parquet
  size:    4.7 MB
  rows:    319,880
  symbols: 3,507

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
2012-01-27 04:00:00	AAPL	Stock	15.9039	15.9039	15.9039	15.9039	2800.0
2012-01-27 04:10:00	AAPL	Stock	15.9104	15.9104	15.9104	15.9104	2800.0
2012-01-27 04:15:00	AAPL	Stock	15.925	15.925	15.925	15.925	2800.0
2012-01-27 04:20:00	AAPL	Stock	15.9396	15.9429	15.9396	15.9429	5600.0
2012-01-27 04:45:00	AAPL	Stock	15.9446	15.9464	15.9446	15.9464	8400.0
2012-01-27 04:50:00	AAPL	Stock	15.9464	15.9464	15.9464	15.9464	8400.0
2012-01-27 05:05:00	AAPL	Stock	15.9639	15.9639	15.9596	15.9596	22400.0
2012-01-27 05:10:00	AAPL	Stock	15.9636	15.9639	15.9636	15.9639	5600.0
2012-01-27 05:15:00	AAPL	Stock	15.9732	15.9732	15.9732	15.9732	5600.0
2012-01-27 05:20:00	AAPL	Stock	15.9732	15.9732	15.9732	15.9732	2800.0
2012-01-27 05:30:00	AAPL	Stock	15.975	15.9754	15.975	15.9754	5600.0
2012-01-27 05:40:00	AAPL	Stock	15.9754	15.9754	15.9754	15.9754	2800.0
2012-01-27 06:10:00	AAPL	Stock	15.9718	15.9825	15.9718	15.9825	11200.0
2012-01-27 06:15:00	AAPL	Stock	15.9686	15.9686	15.9686	15.9686	8400.0
2012-01-27 06:25:00	AAPL	Stock	15.9614	15.9614	15.9586	15.9586	11200.0
2012-01-27 06:30:00	AAPL	Stock	15.9643	15.9643	15.9643	15.9643	14000.0
2012-01-27 06:35:00	AAPL	Stock	15.9643	15.9643	15.9643	15.9643	2800.0
2012-01-27 06:40:00	AAPL	Stock	15.9607	15.9607	15.9607	15.9607	5600.0
2012-01-27 07:00:00	AAPL	Stock	15.9464	15.9464	15.9429	15.9429	22120.0
2012-01-27 07:05:00	AAPL	Stock	15.9304	15.9332	15.9279	15.9282	117600.0
2012-01-27 07:10:00	AAPL	Stock	15.9286	15.9286	15.9286	15.9286	14252.0
2012-01-27 07:20:00	AAPL	Stock	15.9286	15.9286	15.9286	15.9286	11200.0
2012-01-27 07:25:00	AAPL	Stock	15.9293	15.9357	15.9293	15.9357	16800.0
2012-01-27 07:30:00	AAPL	Stock	15.9293	15.9357	15.9293	15.9357	42000.0
2012-01-27 07:40:00	AAPL	Stock	15.9421	15.9421	15.9421	15.9421	9100.0
2012-01-27 07:45:00	AAPL	Stock	15.9293	15.9375	15.9293	15.9375	11060.0
2012-01-27 07:50:00	AAPL	Stock	15.9375	15.9375	15.9225	15.9225	22260.0
2012-01-27 07:55:00	AAPL	Stock	15.9182	15.9182	15.9036	15.9096	67200.0
2012-01-27 08:00:00	AAPL	Stock	15.9071	15.9268	15.8996	15.9071	154756.0
2012-01-27 08:05:00	AAPL	Stock	15.9036	15.92	15.9032	15.9104	66360.0
2012-01-27 08:10:00	AAPL	Stock	15.9036	15.9143	15.9036	15.9143	55888.0
2012-01-27 08:15:00	AAPL	Stock	15.8418	15.9079	15.8418	15.8929	303464.0
2012-01-27 08:20:00	AAPL	Stock	15.8929	15.9064	15.8821	15.9064	111104.0
2012-01-27 08:25:00	AAPL	Stock	15.9057	15.9157	15.9057	15.9157	24080.0
2012-01-27 08:30:00	AAPL	Stock	15.8964	15.9089	15.8571	15.8571	131824.0
2012-01-27 08:35:00	AAPL	Stock	15.8611	15.8686	15.8571	15.8686	131180.0
2012-01-27 08:40:00	AAPL	Stock	15.8643	15.8643	15.8464	15.8529	163604.0
2012-01-27 08:45:00	AAPL	Stock	15.8536	15.8614	15.8461	15.8461	136976.0
2012-01-27 08:50:00	AAPL	Stock	15.8554	15.8571	15.8386	15.8386	335692.0
2012-01-27 08:55:00	AAPL	Stock	15.8386	15.8429	15.835	15.8429	57596.0
2012-01-27 09:00:00	AAPL	Stock	15.84	15.85	15.84	15.85	100744.0
2012-01-27 09:05:00	AAPL	Stock	15.8493	15.8582	15.8493	15.8571	131880.0
2012-01-27 09:10:00	AAPL	Stock	15.8679	15.8718	15.8643	15.8661	107548.0
2012-01-27 09:15:00	AAPL	Stock	15.8632	15.8661	15.8575	15.8657	83300.0
2012-01-27 09:20:00	AAPL	Stock	15.8657	15.8696	15.8575	15.8575	77112.0
2012-01-27 09:25:00	AAPL	Stock	15.8589	15.875	15.85	15.8711	585732.0
2012-01-27 09:30:00	AAPL	Stock	15.8693	15.9082	15.8489	15.9043	13326544.0
2012-01-27 09:35:00	AAPL	Stock	15.905	15.9121	15.8696	15.9061	7924924.0
2012-01-27 09:40:00	AAPL	Stock	15.9068	15.9221	15.8914	15.9196	6970292.0
2012-01-27 09:45:00	AAPL	Stock	15.9171	15.9271	15.9107	15.9211	5073796.0

> showing 50 of 319,880 rows — these rows as CSV

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