PREVIEW / stock_1hour / 2011-02-08

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-02-08.parquet
  size:    949 KB
  rows:    44,699
  symbols: 3,535

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-02-08 05:00:00	AAPL	Stock	12.5661	12.5661	12.5661	12.5661	2800.0
2011-02-08 06:00:00	AAPL	Stock	12.5771	12.5857	12.5493	12.5857	16800.0
2011-02-08 07:00:00	AAPL	Stock	12.5671	12.5893	12.55	12.5804	330848.0
2011-02-08 08:00:00	AAPL	Stock	12.5804	12.6139	12.5771	12.5929	2930900.0
2011-02-08 09:00:00	AAPL	Stock	12.5921	12.6614	12.5768	12.6465	86355696.0
2011-02-08 10:00:00	AAPL	Stock	12.6461	12.6829	12.6307	12.6739	81812024.0
2011-02-08 11:00:00	AAPL	Stock	12.6736	12.6796	12.6493	12.6724	40062988.0
2011-02-08 12:00:00	AAPL	Stock	12.6732	12.6957	12.67	12.6929	33464088.0
2011-02-08 13:00:00	AAPL	Stock	12.6921	12.6946	12.6604	12.6693	34157816.0
2011-02-08 14:00:00	AAPL	Stock	12.6693	12.6914	12.6629	12.6724	27124692.0
2011-02-08 15:00:00	AAPL	Stock	12.6725	12.6971	12.6689	12.69	55544944.0
2011-02-08 16:00:00	AAPL	Stock	12.6889	12.6961	12.6358	12.6886	9284688.0
2011-02-08 17:00:00	AAPL	Stock	12.6893	12.7089	12.6643	12.6786	2112852.0
2011-02-08 18:00:00	AAPL	Stock	12.6768	12.6857	12.6757	12.6829	134988.0
2011-02-08 19:00:00	AAPL	Stock	12.6829	12.6986	12.6829	12.6932	724024.0
2011-02-08 05:00:00	MSFT	Stock	28.25	28.25	28.25	28.25	1400.0
2011-02-08 06:00:00	MSFT	Stock	28.25	28.25	28.22	28.22	1200.0
2011-02-08 07:00:00	MSFT	Stock	28.22	28.24	28.22	28.24	1100.0
2011-02-08 08:00:00	MSFT	Stock	28.22	28.22	28.16	28.16	26500.0
2011-02-08 09:00:00	MSFT	Stock	28.16	28.34	28.05	28.301	5508979.0
2011-02-08 10:00:00	MSFT	Stock	28.3	28.33	28.2	28.215	5372111.0
2011-02-08 11:00:00	MSFT	Stock	28.219	28.26	28.13	28.21	5381499.0
2011-02-08 12:00:00	MSFT	Stock	28.21	28.21	28.14	28.179	2302995.0
2011-02-08 13:00:00	MSFT	Stock	28.173	28.18	28.11	28.18	3350671.0
2011-02-08 14:00:00	MSFT	Stock	28.18	28.24	28.17	28.221	4197263.0
2011-02-08 15:00:00	MSFT	Stock	28.22	28.3	28.19	28.29	6083555.0
2011-02-08 16:00:00	MSFT	Stock	28.29	28.36	28.188	28.294	1887710.0
2011-02-08 17:00:00	MSFT	Stock	28.28	28.3	28.27	28.27	40445.0
2011-02-08 18:00:00	MSFT	Stock	28.29	28.29	28.28	28.28	3671.0
2011-02-08 19:00:00	MSFT	Stock	28.25	28.28	28.25	28.28	2790.0
2011-02-08 08:00:00	NVDA	Stock	0.6125	0.62	0.6125	0.6175	404600.0
2011-02-08 09:00:00	NVDA	Stock	0.6153	0.6196	0.6088	0.6166	99310240.0
2011-02-08 10:00:00	NVDA	Stock	0.6168	0.6183	0.6075	0.6098	121402200.0
2011-02-08 11:00:00	NVDA	Stock	0.6098	0.6102	0.6038	0.6063	148846160.0
2011-02-08 12:00:00	NVDA	Stock	0.6063	0.6085	0.6038	0.6044	96691120.0
2011-02-08 13:00:00	NVDA	Stock	0.6044	0.6048	0.5943	0.5952	191070920.0
2011-02-08 14:00:00	NVDA	Stock	0.5952	0.6003	0.594	0.5978	140914240.0
2011-02-08 15:00:00	NVDA	Stock	0.5975	0.599	0.5943	0.597	211326520.0
2011-02-08 16:00:00	NVDA	Stock	0.597	0.6056	0.5968	0.6023	64950640.0
2011-02-08 17:00:00	NVDA	Stock	0.6025	0.6025	0.5973	0.5975	975760.0
2011-02-08 18:00:00	NVDA	Stock	0.6015	0.6025	0.5992	0.6013	218800.0
2011-02-08 19:00:00	NVDA	Stock	0.6	0.6018	0.5988	0.5988	176600.0
2011-02-08 04:00:00	AMZN	Stock	8.8215	8.8215	8.8215	8.8215	2000.0
2011-02-08 06:00:00	AMZN	Stock	8.849	8.8865	8.849	8.885	12000.0
2011-02-08 07:00:00	AMZN	Stock	8.829	8.8315	8.803	8.803	12000.0
2011-02-08 09:00:00	AMZN	Stock	8.825	8.929	8.82	8.924	14361120.0
2011-02-08 10:00:00	AMZN	Stock	8.9245	8.945	8.8895	8.923	19597160.0
2011-02-08 11:00:00	AMZN	Stock	8.923	8.96	8.9	8.954	13202020.0
2011-02-08 12:00:00	AMZN	Stock	8.9545	9.0215	8.9505	8.9945	22410200.0
2011-02-08 13:00:00	AMZN	Stock	8.9945	9.005	8.9825	8.9978	9491260.0

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

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