PREVIEW / stock_5min / 2010-09-20

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-09-20.parquet
  size:    4.8 MB
  rows:    330,699
  symbols: 3,502

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-09-20 04:50:00	AAPL	Stock	9.8571	9.8571	9.8571	9.8571	5600.0
2010-09-20 05:25:00	AAPL	Stock	9.8571	9.8571	9.8571	9.8571	5600.0
2010-09-20 07:00:00	AAPL	Stock	9.8493	9.8493	9.8489	9.8489	8400.0
2010-09-20 07:10:00	AAPL	Stock	9.8746	9.8764	9.8746	9.8746	8400.0
2010-09-20 07:40:00	AAPL	Stock	9.8671	9.8671	9.8671	9.8671	2800.0
2010-09-20 07:45:00	AAPL	Stock	9.8686	9.8746	9.8686	9.8746	44100.0
2010-09-20 07:50:00	AAPL	Stock	9.8668	9.8746	9.8664	9.8689	22400.0
2010-09-20 07:55:00	AAPL	Stock	9.8743	9.875	9.8682	9.8682	22400.0
2010-09-20 08:00:00	AAPL	Stock	9.8739	9.8739	9.86	9.8707	359492.0
2010-09-20 08:05:00	AAPL	Stock	9.8664	9.8707	9.8664	9.8707	132664.0
2010-09-20 08:10:00	AAPL	Stock	9.8714	9.8721	9.8675	9.8682	75432.0
2010-09-20 08:15:00	AAPL	Stock	9.8704	9.8704	9.8643	9.8661	103600.0
2010-09-20 08:20:00	AAPL	Stock	9.8661	9.8661	9.8614	9.8639	102620.0
2010-09-20 08:25:00	AAPL	Stock	9.8621	9.8643	9.8571	9.8571	168140.0
2010-09-20 08:30:00	AAPL	Stock	9.8575	9.8643	9.8571	9.8614	137900.0
2010-09-20 08:35:00	AAPL	Stock	9.8582	9.8582	9.8482	9.8514	336560.0
2010-09-20 08:40:00	AAPL	Stock	9.8521	9.8536	9.8493	9.8536	159600.0
2010-09-20 08:45:00	AAPL	Stock	9.8554	9.8593	9.8532	9.8593	50624.0
2010-09-20 08:50:00	AAPL	Stock	9.8579	9.8579	9.8546	9.8554	86800.0
2010-09-20 08:55:00	AAPL	Stock	9.8546	9.8546	9.8482	9.8532	282800.0
2010-09-20 09:00:00	AAPL	Stock	9.8525	9.8571	9.8525	9.8571	155008.0
2010-09-20 09:05:00	AAPL	Stock	9.8564	9.8571	9.8536	9.8568	77112.0
2010-09-20 09:10:00	AAPL	Stock	9.8568	9.8654	9.8564	9.8654	131152.0
2010-09-20 09:15:00	AAPL	Stock	9.8639	9.8654	9.8575	9.8654	63672.0
2010-09-20 09:20:00	AAPL	Stock	9.8629	9.8664	9.8629	9.8661	42112.0
2010-09-20 09:25:00	AAPL	Stock	9.8664	9.8675	9.86	9.8611	242200.0
2010-09-20 09:30:00	AAPL	Stock	9.8629	9.9007	9.8518	9.8864	19832568.0
2010-09-20 09:35:00	AAPL	Stock	9.8868	9.9286	9.885	9.9239	20372576.0
2010-09-20 09:40:00	AAPL	Stock	9.9243	9.9471	9.9196	9.9461	21924252.0
2010-09-20 09:45:00	AAPL	Stock	9.9461	9.9639	9.9364	9.9521	21214564.0
2010-09-20 09:50:00	AAPL	Stock	9.952	9.9961	9.95	9.9911	26529300.0
2010-09-20 09:55:00	AAPL	Stock	9.9926	9.9946	9.97	9.9732	17131156.0
2010-09-20 10:00:00	AAPL	Stock	9.9739	9.9982	9.9646	9.9925	15419432.0
2010-09-20 10:05:00	AAPL	Stock	9.9925	10.0221	9.9896	10.0118	26102580.0
2010-09-20 10:10:00	AAPL	Stock	10.0184	10.0184	10.0029	10.0118	12302556.0
2010-09-20 10:15:00	AAPL	Stock	10.0121	10.0521	10.0111	10.0454	15712396.0
2010-09-20 10:20:00	AAPL	Stock	10.0446	10.0629	10.0321	10.0357	18968796.0
2010-09-20 10:25:00	AAPL	Stock	10.0343	10.0554	10.0321	10.0464	8750056.0
2010-09-20 10:30:00	AAPL	Stock	10.0471	10.0489	10.0314	10.0368	10546312.0
2010-09-20 10:35:00	AAPL	Stock	10.0364	10.0404	10.0204	10.0292	10203564.0
2010-09-20 10:40:00	AAPL	Stock	10.0293	10.0296	10.0107	10.0186	9253384.0
2010-09-20 10:45:00	AAPL	Stock	10.0189	10.0264	10.0118	10.0196	7894124.0
2010-09-20 10:50:00	AAPL	Stock	10.0199	10.0232	10.0068	10.0125	8222340.0
2010-09-20 10:55:00	AAPL	Stock	10.0118	10.0321	10.0114	10.0271	5806248.0
2010-09-20 11:00:00	AAPL	Stock	10.0271	10.0414	10.0268	10.0343	7251300.0
2010-09-20 11:05:00	AAPL	Stock	10.0348	10.0421	10.0321	10.0404	4610312.0
2010-09-20 11:10:00	AAPL	Stock	10.0407	10.0411	10.0268	10.028	3483704.0
2010-09-20 11:15:00	AAPL	Stock	10.0282	10.0296	10.0132	10.0179	4209968.0
2010-09-20 11:20:00	AAPL	Stock	10.0175	10.0246	10.015	10.0214	3125360.0
2010-09-20 11:25:00	AAPL	Stock	10.0211	10.0282	10.0196	10.0264	2782948.0

> showing 50 of 330,699 rows — these rows as CSV

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