PREVIEW / stock_5min / 2012-07-16

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-07-16.parquet
  size:    4.6 MB
  rows:    308,377
  symbols: 3,475

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-07-16 04:00:00	AAPL	Stock	21.6071	21.6071	21.6032	21.6032	50848.0
2012-07-16 04:20:00	AAPL	Stock	21.5718	21.5718	21.5718	21.5718	8400.0
2012-07-16 04:45:00	AAPL	Stock	21.5718	21.5718	21.5718	21.5718	2800.0
2012-07-16 05:05:00	AAPL	Stock	21.6071	21.6071	21.6068	21.6071	19600.0
2012-07-16 05:20:00	AAPL	Stock	21.605	21.605	21.605	21.605	2800.0
2012-07-16 05:30:00	AAPL	Stock	21.5714	21.5714	21.5714	21.5714	8400.0
2012-07-16 07:00:00	AAPL	Stock	21.6036	21.6036	21.6036	21.6036	2800.0
2012-07-16 07:05:00	AAPL	Stock	21.6036	21.6054	21.6036	21.6054	9520.0
2012-07-16 07:20:00	AAPL	Stock	21.5982	21.5982	21.5804	21.5893	19740.0
2012-07-16 07:40:00	AAPL	Stock	21.6014	21.6018	21.6014	21.6018	5600.0
2012-07-16 07:55:00	AAPL	Stock	21.6071	21.6071	21.6071	21.6071	2800.0
2012-07-16 08:00:00	AAPL	Stock	21.5946	21.5946	21.5711	21.5868	274876.0
2012-07-16 08:05:00	AAPL	Stock	21.5868	21.5868	21.5786	21.5786	14000.0
2012-07-16 08:10:00	AAPL	Stock	21.5761	21.5886	21.5675	21.5875	72128.0
2012-07-16 08:15:00	AAPL	Stock	21.58	21.58	21.5707	21.58	36400.0
2012-07-16 08:20:00	AAPL	Stock	21.5796	21.5857	21.5796	21.5804	19320.0
2012-07-16 08:25:00	AAPL	Stock	21.5914	21.5914	21.5864	21.5864	45220.0
2012-07-16 08:30:00	AAPL	Stock	21.5793	21.5893	21.5561	21.5768	247240.0
2012-07-16 08:35:00	AAPL	Stock	21.575	21.5786	21.5679	21.5682	83300.0
2012-07-16 08:40:00	AAPL	Stock	21.5679	21.5714	21.5629	21.5714	118104.0
2012-07-16 08:45:00	AAPL	Stock	21.5714	21.5718	21.565	21.5679	43652.0
2012-07-16 08:50:00	AAPL	Stock	21.5736	21.5736	21.5679	21.5704	39200.0
2012-07-16 08:55:00	AAPL	Stock	21.5736	21.5864	21.5682	21.5729	69720.0
2012-07-16 09:00:00	AAPL	Stock	21.5854	21.5854	21.5757	21.5757	5600.0
2012-07-16 09:05:00	AAPL	Stock	21.5821	21.6107	21.5786	21.6025	172340.0
2012-07-16 09:10:00	AAPL	Stock	21.6018	21.6036	21.5968	21.6007	50148.0
2012-07-16 09:15:00	AAPL	Stock	21.6014	21.6129	21.6014	21.6125	68264.0
2012-07-16 09:20:00	AAPL	Stock	21.6143	21.6171	21.6071	21.6125	199668.0
2012-07-16 09:25:00	AAPL	Stock	21.6125	21.6196	21.6104	21.615	205436.0
2012-07-16 09:30:00	AAPL	Stock	21.615	21.7679	21.6079	21.7608	17641904.0
2012-07-16 09:35:00	AAPL	Stock	21.7643	21.7761	21.6964	21.7096	12498724.0
2012-07-16 09:40:00	AAPL	Stock	21.7061	21.7193	21.6687	21.6835	9125872.0
2012-07-16 09:45:00	AAPL	Stock	21.6796	21.6829	21.6275	21.6525	9638664.0
2012-07-16 09:50:00	AAPL	Stock	21.6525	21.7107	21.6407	21.6761	7408296.0
2012-07-16 09:55:00	AAPL	Stock	21.6786	21.7007	21.6607	21.6686	5777912.0
2012-07-16 10:00:00	AAPL	Stock	21.6686	21.7118	21.6686	21.6889	5106640.0
2012-07-16 10:05:00	AAPL	Stock	21.6893	21.7168	21.6696	21.6971	5239416.0
2012-07-16 10:10:00	AAPL	Stock	21.6964	21.7404	21.6943	21.7193	4259080.0
2012-07-16 10:15:00	AAPL	Stock	21.7193	21.7343	21.6971	21.7057	4405464.0
2012-07-16 10:20:00	AAPL	Stock	21.7071	21.7118	21.6825	21.6986	5077660.0
2012-07-16 10:25:00	AAPL	Stock	21.6964	21.7139	21.6714	21.7132	3396792.0
2012-07-16 10:30:00	AAPL	Stock	21.7139	21.73	21.7086	21.7221	3519068.0
2012-07-16 10:35:00	AAPL	Stock	21.7225	21.7357	21.7064	21.7182	3719296.0
2012-07-16 10:40:00	AAPL	Stock	21.7179	21.7286	21.6964	21.7071	2633232.0
2012-07-16 10:45:00	AAPL	Stock	21.7086	21.7214	21.6936	21.6939	2373084.0
2012-07-16 10:50:00	AAPL	Stock	21.6943	21.7086	21.6936	21.7018	2020200.0
2012-07-16 10:55:00	AAPL	Stock	21.7018	21.72	21.6969	21.7089	3421460.0
2012-07-16 11:00:00	AAPL	Stock	21.7086	21.7304	21.7011	21.7218	3539032.0
2012-07-16 11:05:00	AAPL	Stock	21.7175	21.7557	21.7175	21.75	4699912.0
2012-07-16 11:10:00	AAPL	Stock	21.7525	21.7882	21.747	21.7763	9223508.0

> showing 50 of 308,377 rows — these rows as CSV

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