PREVIEW / stock_5min / 2010-07-16

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-07-16.parquet
  size:    4.6 MB
  rows:    316,625
  symbols: 3,439

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-07-16 05:55:00	AAPL	Stock	9.0214	9.0214	9.0214	9.0214	2800.0
2010-07-16 06:30:00	AAPL	Stock	9.0286	9.0357	9.0286	9.0357	33600.0
2010-07-16 06:35:00	AAPL	Stock	9.0357	9.0357	9.0357	9.0357	5600.0
2010-07-16 07:05:00	AAPL	Stock	9.0307	9.0307	9.0025	9.0075	25200.0
2010-07-16 07:10:00	AAPL	Stock	9.0179	9.0446	9.0175	9.0446	82600.0
2010-07-16 07:15:00	AAPL	Stock	9.0536	9.0589	9.0254	9.0268	49588.0
2010-07-16 07:25:00	AAPL	Stock	9.0443	9.0443	9.0443	9.0443	2800.0
2010-07-16 07:30:00	AAPL	Stock	9.0314	9.0314	9.0314	9.0314	8400.0
2010-07-16 07:35:00	AAPL	Stock	9.0296	9.0304	9.0161	9.03	42700.0
2010-07-16 07:40:00	AAPL	Stock	9.015	9.015	9.015	9.015	2800.0
2010-07-16 07:45:00	AAPL	Stock	9.0179	9.025	9.0179	9.025	42000.0
2010-07-16 07:50:00	AAPL	Stock	9.025	9.0254	9.0107	9.0107	86800.0
2010-07-16 07:55:00	AAPL	Stock	8.995	9.0104	8.9929	9.0104	26460.0
2010-07-16 08:00:00	AAPL	Stock	9.0104	9.0304	8.9968	9.0289	179060.0
2010-07-16 08:05:00	AAPL	Stock	9.02	9.0304	9.0143	9.0304	108640.0
2010-07-16 08:10:00	AAPL	Stock	9.0304	9.0304	9.0089	9.0089	161000.0
2010-07-16 08:15:00	AAPL	Stock	9.0057	9.0264	8.9982	9.0232	262612.0
2010-07-16 08:20:00	AAPL	Stock	9.0232	9.0307	9.0189	9.0304	79800.0
2010-07-16 08:25:00	AAPL	Stock	9.0214	9.0214	9.0121	9.0179	49000.0
2010-07-16 08:30:00	AAPL	Stock	9.0125	9.0204	9.0093	9.0175	72800.0
2010-07-16 08:35:00	AAPL	Stock	9.0218	9.0275	9.0204	9.0229	71400.0
2010-07-16 08:40:00	AAPL	Stock	9.0275	9.0482	9.0275	9.0446	302876.0
2010-07-16 08:45:00	AAPL	Stock	9.0446	9.0575	9.0389	9.0554	331184.0
2010-07-16 08:50:00	AAPL	Stock	9.06	9.0643	9.0421	9.0421	558404.0
2010-07-16 08:55:00	AAPL	Stock	9.0389	9.0457	9.0214	9.0286	432964.0
2010-07-16 09:00:00	AAPL	Stock	9.0321	9.0357	9.0232	9.0232	278292.0
2010-07-16 09:05:00	AAPL	Stock	9.0232	9.0264	9.0179	9.02	493920.0
2010-07-16 09:10:00	AAPL	Stock	9.0232	9.0268	9.0182	9.0239	189728.0
2010-07-16 09:15:00	AAPL	Stock	9.0261	9.0296	9.0107	9.0107	531636.0
2010-07-16 09:20:00	AAPL	Stock	9.0086	9.0168	8.9804	9.0111	371280.0
2010-07-16 09:25:00	AAPL	Stock	9.0107	9.0421	9.0093	9.0375	1060052.0
2010-07-16 09:30:00	AAPL	Stock	9.0375	9.0571	8.9821	9.0121	53658304.0
2010-07-16 09:35:00	AAPL	Stock	9.0121	9.035	8.9943	9.0064	15802892.0
2010-07-16 09:40:00	AAPL	Stock	9.0071	9.0436	9.0071	9.0146	14254016.0
2010-07-16 09:45:00	AAPL	Stock	9.0143	9.0246	8.9646	8.9893	16610580.0
2010-07-16 09:50:00	AAPL	Stock	8.9871	9.0021	8.9679	8.9839	12010572.0
2010-07-16 09:55:00	AAPL	Stock	8.9839	9.0	8.975	8.9925	16606128.0
2010-07-16 10:00:00	AAPL	Stock	8.9914	9.0111	8.9886	8.9932	13002864.0
2010-07-16 10:05:00	AAPL	Stock	8.9932	9.0004	8.9475	8.9682	15459024.0
2010-07-16 10:10:00	AAPL	Stock	8.9686	8.9836	8.9593	8.9832	9983204.0
2010-07-16 10:15:00	AAPL	Stock	8.9832	8.9907	8.9718	8.9871	7573748.0
2010-07-16 10:20:00	AAPL	Stock	8.9875	8.9882	8.9643	8.97	9201220.0
2010-07-16 10:25:00	AAPL	Stock	8.9707	8.9857	8.9589	8.9629	11175304.0
2010-07-16 10:30:00	AAPL	Stock	8.9625	8.965	8.9143	8.9457	17727556.0
2010-07-16 10:35:00	AAPL	Stock	8.9479	8.955	8.9429	8.9521	6866692.0
2010-07-16 10:40:00	AAPL	Stock	8.9518	8.9714	8.9375	8.9711	6867308.0
2010-07-16 10:45:00	AAPL	Stock	8.9714	8.9739	8.9532	8.9571	5257448.0
2010-07-16 10:50:00	AAPL	Stock	8.9564	8.9642	8.9436	8.9436	6438068.0
2010-07-16 10:55:00	AAPL	Stock	8.9432	8.9493	8.9321	8.9411	6381928.0
2010-07-16 11:00:00	AAPL	Stock	8.9393	8.9561	8.9375	8.9386	6334804.0

> showing 50 of 316,625 rows — these rows as CSV

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