PREVIEW / stock_1hour / 2012-02-28

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-02-28.parquet
  size:    949 KB
  rows:    44,793
  symbols: 3,538

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
2012-02-28 04:00:00	AAPL	Stock	18.875	18.8757	18.8571	18.8679	39620.0
2012-02-28 05:00:00	AAPL	Stock	18.8732	18.875	18.8579	18.8607	61712.0
2012-02-28 06:00:00	AAPL	Stock	18.875	18.88	18.8611	18.8611	28000.0
2012-02-28 07:00:00	AAPL	Stock	18.8607	18.8729	18.8393	18.8646	484904.0
2012-02-28 08:00:00	AAPL	Stock	18.865	18.8732	18.7754	18.8171	5989872.0
2012-02-28 09:00:00	AAPL	Stock	18.8125	18.9275	18.7804	18.9275	77658980.0
2012-02-28 10:00:00	AAPL	Stock	18.9279	19.0429	18.8996	18.9857	127757700.0
2012-02-28 11:00:00	AAPL	Stock	18.9889	19.0314	18.9611	19.0164	65131360.0
2012-02-28 12:00:00	AAPL	Stock	19.0146	19.0886	18.9811	19.0732	60793936.0
2012-02-28 13:00:00	AAPL	Stock	19.0764	19.0936	18.9686	19.0071	64589084.0
2012-02-28 14:00:00	AAPL	Stock	19.0118	19.0643	18.9843	19.0464	67860380.0
2012-02-28 15:00:00	AAPL	Stock	19.0461	19.1207	19.0433	19.1182	104188168.0
2012-02-28 16:00:00	AAPL	Stock	19.1218	19.1607	18.7771	19.1518	15212316.0
2012-02-28 17:00:00	AAPL	Stock	19.1493	19.1586	19.1218	19.1564	733152.0
2012-02-28 18:00:00	AAPL	Stock	19.1571	19.1871	19.1554	19.1821	1309868.0
2012-02-28 19:00:00	AAPL	Stock	19.1793	19.1979	19.1768	19.1904	932456.0
2012-02-28 06:00:00	MSFT	Stock	31.46	31.61	31.46	31.61	3000.0
2012-02-28 07:00:00	MSFT	Stock	31.49	31.5	31.45	31.45	4222.0
2012-02-28 08:00:00	MSFT	Stock	31.45	31.48	31.34	31.38	22988.0
2012-02-28 09:00:00	MSFT	Stock	31.39	31.65	31.38	31.635	4109410.0
2012-02-28 10:00:00	MSFT	Stock	31.65	31.74	31.52	31.715	6801727.0
2012-02-28 11:00:00	MSFT	Stock	31.71	31.75	31.66	31.75	4922566.0
2012-02-28 12:00:00	MSFT	Stock	31.75	31.85	31.72	31.82	5664188.0
2012-02-28 13:00:00	MSFT	Stock	31.824	31.93	31.74	31.75	5875355.0
2012-02-28 14:00:00	MSFT	Stock	31.75	31.78	31.62	31.725	5628239.0
2012-02-28 15:00:00	MSFT	Stock	31.73	31.89	31.71	31.87	7830119.0
2012-02-28 16:00:00	MSFT	Stock	31.86	31.88	31.35	31.85	2511606.0
2012-02-28 17:00:00	MSFT	Stock	31.87	31.87	31.84	31.87	7455.0
2012-02-28 18:00:00	MSFT	Stock	31.87	31.89	31.86	31.89	6037.0
2012-02-28 19:00:00	MSFT	Stock	31.91	31.97	31.8	31.97	10657.0
2012-02-28 08:00:00	NVDA	Stock	0.3882	0.39	0.3882	0.3898	72000.0
2012-02-28 09:00:00	NVDA	Stock	0.388	0.3913	0.385	0.3885	80692160.0
2012-02-28 10:00:00	NVDA	Stock	0.3888	0.39	0.3875	0.3882	80777240.0
2012-02-28 11:00:00	NVDA	Stock	0.3885	0.3893	0.3858	0.3858	82314480.0
2012-02-28 12:00:00	NVDA	Stock	0.3859	0.3865	0.3845	0.3848	76443280.0
2012-02-28 13:00:00	NVDA	Stock	0.3848	0.385	0.3793	0.3803	87928680.0
2012-02-28 14:00:00	NVDA	Stock	0.3803	0.382	0.3798	0.3798	110740120.0
2012-02-28 15:00:00	NVDA	Stock	0.38	0.3838	0.3799	0.383	155608760.0
2012-02-28 16:00:00	NVDA	Stock	0.3833	0.3868	0.3824	0.3833	12356800.0
2012-02-28 17:00:00	NVDA	Stock	0.3842	0.3842	0.3842	0.3842	15000.0
2012-02-28 19:00:00	NVDA	Stock	0.3842	0.3842	0.3842	0.3842	39000.0
2012-02-28 07:00:00	AMZN	Stock	8.9605	8.9605	8.9605	8.9605	2600.0
2012-02-28 08:00:00	AMZN	Stock	8.974	8.975	8.9375	8.945	67600.0
2012-02-28 09:00:00	AMZN	Stock	8.9405	9.009	8.8975	8.9905	13017740.0
2012-02-28 10:00:00	AMZN	Stock	8.9905	9.0975	8.9635	9.08	19642700.0
2012-02-28 11:00:00	AMZN	Stock	9.08	9.1245	9.075	9.1169	14482260.0
2012-02-28 12:00:00	AMZN	Stock	9.1175	9.13	9.095	9.1045	9980580.0
2012-02-28 13:00:00	AMZN	Stock	9.1035	9.125	9.1	9.1	10269980.0
2012-02-28 14:00:00	AMZN	Stock	9.102	9.125	9.083	9.1185	10282040.0
2012-02-28 15:00:00	AMZN	Stock	9.12	9.2145	9.115	9.1825	29096860.0

> showing 50 of 44,793 rows — these rows as CSV

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