PREVIEW / stock_1hour / 2011-03-02

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-03-02.parquet
  size:    930 KB
  rows:    44,163
  symbols: 3,525

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
2011-03-02 04:00:00	AAPL	Stock	12.4607	12.4907	12.4607	12.4907	8400.0
2011-03-02 05:00:00	AAPL	Stock	12.5	12.5725	12.5	12.5343	53200.0
2011-03-02 06:00:00	AAPL	Stock	12.5139	12.5343	12.5139	12.5343	5600.0
2011-03-02 07:00:00	AAPL	Stock	12.5071	12.55	12.5004	12.55	415380.0
2011-03-02 08:00:00	AAPL	Stock	12.5379	12.5621	12.4604	12.4964	1977808.0
2011-03-02 09:00:00	AAPL	Stock	12.4946	12.5446	12.4486	12.5168	55075748.0
2011-03-02 10:00:00	AAPL	Stock	12.5171	12.5661	12.4429	12.5496	72183692.0
2011-03-02 11:00:00	AAPL	Stock	12.55	12.5868	12.5	12.505	54888064.0
2011-03-02 12:00:00	AAPL	Stock	12.505	12.5461	12.4911	12.5098	40267640.0
2011-03-02 13:00:00	AAPL	Stock	12.5104	12.6407	12.51	12.5579	164900512.0
2011-03-02 14:00:00	AAPL	Stock	12.5604	12.6211	12.5236	12.6182	98537516.0
2011-03-02 15:00:00	AAPL	Stock	12.6185	12.6554	12.5596	12.5757	101390184.0
2011-03-02 16:00:00	AAPL	Stock	12.5757	12.6198	12.5139	12.5768	6987176.0
2011-03-02 17:00:00	AAPL	Stock	12.5768	12.5954	12.5768	12.5946	391104.0
2011-03-02 18:00:00	AAPL	Stock	12.5946	12.6068	12.5757	12.6054	278236.0
2011-03-02 19:00:00	AAPL	Stock	12.6054	12.6068	12.6	12.6032	482440.0
2011-03-02 07:00:00	MSFT	Stock	26.25	26.26	26.11	26.2	5650.0
2011-03-02 08:00:00	MSFT	Stock	26.2	26.2	26.12	26.14	10519.0
2011-03-02 09:00:00	MSFT	Stock	26.16	26.3	26.1	26.2	5339500.0
2011-03-02 10:00:00	MSFT	Stock	26.2	26.32	26.175	26.285	7085193.0
2011-03-02 11:00:00	MSFT	Stock	26.29	26.37	26.2	26.21	5878886.0
2011-03-02 12:00:00	MSFT	Stock	26.21	26.33	26.2	26.21	5115329.0
2011-03-02 13:00:00	MSFT	Stock	26.21	26.23	26.06	26.09	7300296.0
2011-03-02 14:00:00	MSFT	Stock	26.1	26.16	26.06	26.14	6578409.0
2011-03-02 15:00:00	MSFT	Stock	26.14	26.24	26.04	26.07	9639769.0
2011-03-02 16:00:00	MSFT	Stock	26.07	26.2	26.04	26.07	1514264.0
2011-03-02 17:00:00	MSFT	Stock	26.07	26.08	26.07	26.08	15715.0
2011-03-02 18:00:00	MSFT	Stock	26.08	26.09	26.08	26.09	23179.0
2011-03-02 19:00:00	MSFT	Stock	26.09	26.09	26.06	26.06	5720.0
2011-03-02 07:00:00	NVDA	Stock	0.5378	0.539	0.5378	0.5388	112000.0
2011-03-02 08:00:00	NVDA	Stock	0.539	0.5438	0.539	0.5425	2058640.0
2011-03-02 09:00:00	NVDA	Stock	0.5422	0.5438	0.5308	0.5322	146720280.0
2011-03-02 10:00:00	NVDA	Stock	0.5322	0.5505	0.5318	0.5478	211570000.0
2011-03-02 11:00:00	NVDA	Stock	0.5478	0.5508	0.5302	0.5302	171871080.0
2011-03-02 12:00:00	NVDA	Stock	0.5302	0.5365	0.5287	0.5351	115230720.0
2011-03-02 13:00:00	NVDA	Stock	0.535	0.538	0.521	0.5224	222777040.0
2011-03-02 14:00:00	NVDA	Stock	0.5225	0.5242	0.5062	0.513	450608320.0
2011-03-02 15:00:00	NVDA	Stock	0.513	0.5247	0.5128	0.5188	364378720.0
2011-03-02 16:00:00	NVDA	Stock	0.5182	0.5268	0.5175	0.5188	30410840.0
2011-03-02 17:00:00	NVDA	Stock	0.5188	0.522	0.5188	0.5218	668800.0
2011-03-02 18:00:00	NVDA	Stock	0.5215	0.5242	0.521	0.521	211000.0
2011-03-02 19:00:00	NVDA	Stock	0.5225	0.5238	0.521	0.5235	327040.0
2011-03-02 07:00:00	AMZN	Stock	8.4515	8.4825	8.4515	8.4825	4000.0
2011-03-02 08:00:00	AMZN	Stock	8.4575	8.482	8.4375	8.4375	22100.0
2011-03-02 09:00:00	AMZN	Stock	8.4415	8.5445	8.4175	8.5	14940280.0
2011-03-02 10:00:00	AMZN	Stock	8.4986	8.6415	8.4365	8.6125	27221760.0
2011-03-02 11:00:00	AMZN	Stock	8.6175	8.665	8.5411	8.553	16716580.0
2011-03-02 12:00:00	AMZN	Stock	8.5485	8.625	8.5403	8.6005	6736300.0
2011-03-02 13:00:00	AMZN	Stock	8.6005	8.622	8.564	8.5875	6872020.0
2011-03-02 14:00:00	AMZN	Stock	8.588	8.6355	8.56	8.6285	8497340.0

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

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