PREVIEW / stock_5min / 2010-06-17

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-06-17.parquet
  size:    4.6 MB
  rows:    317,700
  symbols: 3,445

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
2010-06-17 04:45:00	AAPL	Stock	9.5789	9.5789	9.5789	9.5789	2800.0
2010-06-17 05:45:00	AAPL	Stock	9.6054	9.6054	9.6054	9.6054	5600.0
2010-06-17 05:55:00	AAPL	Stock	9.6054	9.6054	9.6054	9.6054	2800.0
2010-06-17 07:00:00	AAPL	Stock	9.5896	9.5896	9.5896	9.5896	13440.0
2010-06-17 07:05:00	AAPL	Stock	9.5893	9.6043	9.5893	9.5982	18452.0
2010-06-17 07:10:00	AAPL	Stock	9.6018	9.6054	9.6018	9.6036	79408.0
2010-06-17 07:15:00	AAPL	Stock	9.6111	9.625	9.5964	9.5964	139608.0
2010-06-17 07:20:00	AAPL	Stock	9.6018	9.6214	9.6018	9.6214	82824.0
2010-06-17 07:25:00	AAPL	Stock	9.6071	9.6118	9.6018	9.6118	20776.0
2010-06-17 07:30:00	AAPL	Stock	9.6071	9.6107	9.6071	9.6079	72520.0
2010-06-17 07:35:00	AAPL	Stock	9.6071	9.6261	9.6071	9.625	340340.0
2010-06-17 07:40:00	AAPL	Stock	9.63	9.63	9.6214	9.6214	16800.0
2010-06-17 07:45:00	AAPL	Stock	9.6275	9.6275	9.6179	9.625	84840.0
2010-06-17 07:50:00	AAPL	Stock	9.6243	9.625	9.6189	9.6243	22400.0
2010-06-17 07:55:00	AAPL	Stock	9.6246	9.6304	9.6143	9.6143	211036.0
2010-06-17 08:00:00	AAPL	Stock	9.6143	9.6232	9.6014	9.6196	611744.0
2010-06-17 08:05:00	AAPL	Stock	9.6179	9.6196	9.5446	9.6179	184520.0
2010-06-17 08:10:00	AAPL	Stock	9.6179	9.6187	9.6143	9.6161	140252.0
2010-06-17 08:15:00	AAPL	Stock	9.6164	9.6164	9.6018	9.6036	535332.0
2010-06-17 08:20:00	AAPL	Stock	9.607	9.6218	9.6054	9.6175	329728.0
2010-06-17 08:25:00	AAPL	Stock	9.6196	9.6216	9.6036	9.6068	491736.0
2010-06-17 08:30:00	AAPL	Stock	9.6071	9.6161	9.5786	9.5954	1254764.0
2010-06-17 08:35:00	AAPL	Stock	9.5954	9.6039	9.59	9.5957	756700.0
2010-06-17 08:40:00	AAPL	Stock	9.5954	9.6054	9.5925	9.6036	200732.0
2010-06-17 08:45:00	AAPL	Stock	9.6036	9.6157	9.5925	9.6096	662648.0
2010-06-17 08:50:00	AAPL	Stock	9.6093	9.6261	9.6071	9.625	957796.0
2010-06-17 08:55:00	AAPL	Stock	9.6261	9.6479	9.6071	9.6379	2210180.0
2010-06-17 09:00:00	AAPL	Stock	9.6379	9.6461	9.6325	9.6457	1127532.0
2010-06-17 09:05:00	AAPL	Stock	9.645	9.6475	9.6421	9.6464	1039444.0
2010-06-17 09:10:00	AAPL	Stock	9.6464	9.6671	9.6446	9.6668	1650096.0
2010-06-17 09:15:00	AAPL	Stock	9.6671	9.675	9.6607	9.6721	1108156.0
2010-06-17 09:20:00	AAPL	Stock	9.6725	9.6943	9.6682	9.6857	1843604.0
2010-06-17 09:25:00	AAPL	Stock	9.6861	9.6893	9.6589	9.6661	3013052.0
2010-06-17 09:30:00	AAPL	Stock	9.6661	9.7104	9.65	9.7039	47655916.0
2010-06-17 09:35:00	AAPL	Stock	9.7039	9.7214	9.6904	9.7049	37949240.0
2010-06-17 09:40:00	AAPL	Stock	9.7032	9.7049	9.6729	9.6796	29304324.0
2010-06-17 09:45:00	AAPL	Stock	9.6793	9.6868	9.6589	9.6697	19331284.0
2010-06-17 09:50:00	AAPL	Stock	9.6689	9.6954	9.6668	9.6796	19312356.0
2010-06-17 09:55:00	AAPL	Stock	9.6796	9.7282	9.6786	9.7275	26133296.0
2010-06-17 10:00:00	AAPL	Stock	9.7271	9.7379	9.6804	9.7343	43570744.0
2010-06-17 10:05:00	AAPL	Stock	9.7343	9.7464	9.7021	9.7089	31319876.0
2010-06-17 10:10:00	AAPL	Stock	9.7075	9.7096	9.6657	9.6774	26695564.0
2010-06-17 10:15:00	AAPL	Stock	9.6779	9.6779	9.6471	9.6611	22325240.0
2010-06-17 10:20:00	AAPL	Stock	9.6595	9.6707	9.6521	9.6689	12426316.0
2010-06-17 10:25:00	AAPL	Stock	9.6686	9.6732	9.6325	9.6511	23619148.0
2010-06-17 10:30:00	AAPL	Stock	9.6514	9.6571	9.6354	9.6446	11323452.0
2010-06-17 10:35:00	AAPL	Stock	9.6449	9.6571	9.625	9.6454	13827436.0
2010-06-17 10:40:00	AAPL	Stock	9.6446	9.6732	9.64	9.6732	14721672.0
2010-06-17 10:45:00	AAPL	Stock	9.6722	9.674	9.6454	9.6659	10411548.0
2010-06-17 10:50:00	AAPL	Stock	9.6661	9.7357	9.6636	9.6843	10388196.0

> showing 50 of 317,700 rows — these rows as CSV

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