PREVIEW / stock_30min / 2008-02-14

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-02-14.parquet
  size:    1.2 MB
  rows:    68,458
  symbols: 3,229

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
2008-02-14 04:00:00	AAPL	Stock	4.6621	4.6621	4.6621	4.6621	2800.0
2008-02-14 05:00:00	AAPL	Stock	4.6621	4.6621	4.6621	4.6621	2800.0
2008-02-14 05:30:00	AAPL	Stock	4.6607	4.6607	4.6543	4.6543	28000.0
2008-02-14 06:00:00	AAPL	Stock	4.6432	4.6593	4.6432	4.6464	36400.0
2008-02-14 06:30:00	AAPL	Stock	4.6464	4.6464	4.6429	4.6429	16800.0
2008-02-14 07:00:00	AAPL	Stock	4.6436	4.66	4.6436	4.66	19600.0
2008-02-14 07:30:00	AAPL	Stock	4.6607	4.6607	4.6454	4.6482	161840.0
2008-02-14 08:00:00	AAPL	Stock	4.6464	4.6564	4.6325	4.6464	1473724.0
2008-02-14 08:30:00	AAPL	Stock	4.6464	4.6518	4.6343	4.6361	1331428.0
2008-02-14 09:00:00	AAPL	Stock	4.6389	4.6425	4.6143	4.62	2004436.0
2008-02-14 09:30:00	AAPL	Stock	4.6211	4.6268	4.5586	4.6014	130842152.0
2008-02-14 10:00:00	AAPL	Stock	4.6011	4.6714	4.5954	4.6496	123630360.0
2008-02-14 10:30:00	AAPL	Stock	4.65	4.6554	4.5804	4.5811	92108800.0
2008-02-14 11:00:00	AAPL	Stock	4.5811	4.5979	4.5607	4.5846	87166744.0
2008-02-14 11:30:00	AAPL	Stock	4.5854	4.5989	4.5721	4.5875	60415264.0
2008-02-14 12:00:00	AAPL	Stock	4.5882	4.6171	4.5789	4.6118	49352744.0
2008-02-14 12:30:00	AAPL	Stock	4.6132	4.6154	4.5714	4.5732	39081252.0
2008-02-14 13:00:00	AAPL	Stock	4.5729	4.5818	4.5546	4.5786	51576728.0
2008-02-14 13:30:00	AAPL	Stock	4.5786	4.5921	4.5643	4.5818	43336804.0
2008-02-14 14:00:00	AAPL	Stock	4.5818	4.5971	4.5686	4.5739	49221704.0
2008-02-14 14:30:00	AAPL	Stock	4.5732	4.5786	4.5443	4.5523	57089732.0
2008-02-14 15:00:00	AAPL	Stock	4.5543	4.575	4.5361	4.5611	77886284.0
2008-02-14 15:30:00	AAPL	Stock	4.5611	4.5739	4.5457	4.5536	73614184.0
2008-02-14 16:00:00	AAPL	Stock	4.5528	4.6529	4.5468	4.5521	11818828.0
2008-02-14 16:30:00	AAPL	Stock	4.5511	4.5568	4.55	4.5536	1552516.0
2008-02-14 17:00:00	AAPL	Stock	4.5536	4.5571	4.5521	4.5521	213948.0
2008-02-14 17:30:00	AAPL	Stock	4.5521	4.555	4.5454	4.5454	112112.0
2008-02-14 18:00:00	AAPL	Stock	4.5543	4.5546	4.5504	4.5518	69468.0
2008-02-14 18:30:00	AAPL	Stock	4.5518	4.5536	4.55	4.55	93940.0
2008-02-14 19:00:00	AAPL	Stock	4.55	4.5543	4.5482	4.5543	128688.0
2008-02-14 19:30:00	AAPL	Stock	4.5464	4.55	4.5379	4.5379	181356.0
2008-02-14 08:00:00	MSFT	Stock	29.0	29.05	28.89	28.94	17651.0
2008-02-14 08:30:00	MSFT	Stock	28.9	28.93	28.86	28.93	8300.0
2008-02-14 09:00:00	MSFT	Stock	28.9	28.95	28.85	28.9	48654.0
2008-02-14 09:30:00	MSFT	Stock	28.89	29.03	28.6	28.95	9402985.0
2008-02-14 10:00:00	MSFT	Stock	28.96	29.04	28.84	28.86	5551004.0
2008-02-14 10:30:00	MSFT	Stock	28.86	28.89	28.77	28.82	3881185.0
2008-02-14 11:00:00	MSFT	Stock	28.82	28.84	28.7	28.77	5538526.0
2008-02-14 11:30:00	MSFT	Stock	28.78	28.79	28.672	28.72	5297029.0
2008-02-14 12:00:00	MSFT	Stock	28.73	28.81	28.66	28.77	3582272.0
2008-02-14 12:30:00	MSFT	Stock	28.77	28.81	28.65	28.66	3012261.0
2008-02-14 13:00:00	MSFT	Stock	28.66	28.73	28.62	28.72	3687196.0
2008-02-14 13:30:00	MSFT	Stock	28.73	28.74	28.63	28.65	2612836.0
2008-02-14 14:00:00	MSFT	Stock	28.66	28.71	28.61	28.63	3301593.0
2008-02-14 14:30:00	MSFT	Stock	28.63	28.67	28.46	28.56	5056094.0
2008-02-14 15:00:00	MSFT	Stock	28.56	28.7	28.48	28.63	5580037.0
2008-02-14 15:30:00	MSFT	Stock	28.63	28.66	28.47	28.52	8862104.0
2008-02-14 16:00:00	MSFT	Stock	28.52	29.08	28.49	28.5	2323144.0
2008-02-14 16:30:00	MSFT	Stock	28.5	28.704	28.5	28.5	509728.0
2008-02-14 17:00:00	MSFT	Stock	28.56	28.56	28.5	28.51	19950.0

> showing 50 of 68,458 rows — these rows as CSV

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