PREVIEW / stock_5min / 2010-04-23

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-04-23.parquet
  size:    4.9 MB
  rows:    336,158
  symbols: 3,494

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-04-23 04:05:00	AAPL	Stock	9.5264	9.5264	9.5264	9.5264	14000.0
2010-04-23 04:10:00	AAPL	Stock	9.5268	9.5268	9.5268	9.5268	16800.0
2010-04-23 04:15:00	AAPL	Stock	9.5232	9.5232	9.5232	9.5232	14000.0
2010-04-23 04:25:00	AAPL	Stock	9.5121	9.5121	9.5121	9.5121	5600.0
2010-04-23 04:30:00	AAPL	Stock	9.5157	9.5157	9.5157	9.5157	14000.0
2010-04-23 04:35:00	AAPL	Stock	9.5182	9.5186	9.5157	9.5171	42000.0
2010-04-23 04:40:00	AAPL	Stock	9.5182	9.5714	9.5143	9.5714	67200.0
2010-04-23 04:45:00	AAPL	Stock	9.5668	9.5668	9.5668	9.5668	9240.0
2010-04-23 04:55:00	AAPL	Stock	9.5221	9.5221	9.5221	9.5221	2800.0
2010-04-23 05:05:00	AAPL	Stock	9.5464	9.5464	9.5429	9.5429	5600.0
2010-04-23 05:25:00	AAPL	Stock	9.5586	9.5586	9.5586	9.5586	5600.0
2010-04-23 05:35:00	AAPL	Stock	9.5571	9.5589	9.5571	9.5589	59752.0
2010-04-23 06:05:00	AAPL	Stock	9.5607	9.5607	9.5589	9.5589	41048.0
2010-04-23 06:40:00	AAPL	Stock	9.5589	9.5589	9.5457	9.5457	8400.0
2010-04-23 06:55:00	AAPL	Stock	9.55	9.55	9.55	9.55	12824.0
2010-04-23 07:00:00	AAPL	Stock	9.5625	9.5625	9.5571	9.5571	24920.0
2010-04-23 07:05:00	AAPL	Stock	9.56	9.56	9.545	9.545	14000.0
2010-04-23 07:10:00	AAPL	Stock	9.5532	9.5536	9.5529	9.5536	28000.0
2010-04-23 07:15:00	AAPL	Stock	9.5539	9.5589	9.5536	9.5564	58240.0
2010-04-23 07:20:00	AAPL	Stock	9.5575	9.5575	9.5529	9.5529	36400.0
2010-04-23 07:25:00	AAPL	Stock	9.5554	9.5554	9.5411	9.5411	52080.0
2010-04-23 07:30:00	AAPL	Stock	9.545	9.5464	9.5429	9.5464	19096.0
2010-04-23 07:35:00	AAPL	Stock	9.5464	9.5464	9.5357	9.5357	30716.0
2010-04-23 07:40:00	AAPL	Stock	9.5375	9.5411	9.5357	9.5357	47600.0
2010-04-23 07:45:00	AAPL	Stock	9.5411	9.5446	9.5357	9.5411	50400.0
2010-04-23 07:50:00	AAPL	Stock	9.5464	9.5586	9.5464	9.5586	8708.0
2010-04-23 08:00:00	AAPL	Stock	9.55	9.5739	9.55	9.5714	690788.0
2010-04-23 08:05:00	AAPL	Stock	9.5714	9.5814	9.5711	9.5768	456484.0
2010-04-23 08:10:00	AAPL	Stock	9.5786	9.6	9.575	9.5843	745360.0
2010-04-23 08:15:00	AAPL	Stock	9.5857	9.6036	9.5821	9.5857	491064.0
2010-04-23 08:20:00	AAPL	Stock	9.5857	9.5929	9.5829	9.5893	526092.0
2010-04-23 08:25:00	AAPL	Stock	9.5882	9.5979	9.5834	9.5929	361844.0
2010-04-23 08:30:00	AAPL	Stock	9.5936	9.5977	9.5832	9.5929	734244.0
2010-04-23 08:35:00	AAPL	Stock	9.5904	9.5929	9.575	9.5814	589764.0
2010-04-23 08:40:00	AAPL	Stock	9.5793	9.5818	9.5768	9.5818	578760.0
2010-04-23 08:45:00	AAPL	Stock	9.5818	9.5925	9.5804	9.5925	262780.0
2010-04-23 08:50:00	AAPL	Stock	9.5914	9.5925	9.5832	9.5886	312312.0
2010-04-23 08:55:00	AAPL	Stock	9.5907	9.6018	9.585	9.6	594664.0
2010-04-23 09:00:00	AAPL	Stock	9.5982	9.6	9.5914	9.5982	613508.0
2010-04-23 09:05:00	AAPL	Stock	9.5986	9.6071	9.5971	9.6071	546756.0
2010-04-23 09:10:00	AAPL	Stock	9.6046	9.6107	9.6043	9.6089	814856.0
2010-04-23 09:15:00	AAPL	Stock	9.6075	9.6107	9.6071	9.6071	748664.0
2010-04-23 09:20:00	AAPL	Stock	9.6096	9.6107	9.6014	9.6021	475384.0
2010-04-23 09:25:00	AAPL	Stock	9.6025	9.6039	9.5686	9.5714	1415176.0
2010-04-23 09:30:00	AAPL	Stock	9.5711	9.625	9.5357	9.6189	36755544.0
2010-04-23 09:35:00	AAPL	Stock	9.6175	9.6725	9.6114	9.6675	38196816.0
2010-04-23 09:40:00	AAPL	Stock	9.6675	9.7207	9.6607	9.6796	51297876.0
2010-04-23 09:45:00	AAPL	Stock	9.6793	9.6834	9.6371	9.6786	33900468.0
2010-04-23 09:50:00	AAPL	Stock	9.6793	9.7157	9.6586	9.7143	27200264.0
2010-04-23 09:55:00	AAPL	Stock	9.7161	9.7164	9.6879	9.6991	26328400.0

> showing 50 of 336,158 rows — these rows as CSV

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