PREVIEW / stock_1hour / 2009-09-08

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-09-08.parquet
  size:    867 KB
  rows:    42,138
  symbols: 3,353

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
2009-09-08 04:00:00	AAPL	Stock	6.1357	6.2139	6.1357	6.2139	8400.0
2009-09-08 05:00:00	AAPL	Stock	6.1357	6.1782	6.1357	6.1782	20440.0
2009-09-08 06:00:00	AAPL	Stock	6.1293	6.1293	6.1293	6.1293	11200.0
2009-09-08 07:00:00	AAPL	Stock	6.1293	6.1779	6.1293	6.1714	232120.0
2009-09-08 08:00:00	AAPL	Stock	6.1704	6.1854	6.1661	6.1707	1594880.0
2009-09-08 09:00:00	AAPL	Stock	6.17	6.1836	6.1454	6.1607	72078328.0
2009-09-08 10:00:00	AAPL	Stock	6.1618	6.1786	6.1529	6.1757	57842120.0
2009-09-08 11:00:00	AAPL	Stock	6.1757	6.1782	6.1514	6.1614	35296604.0
2009-09-08 12:00:00	AAPL	Stock	6.1618	6.1625	6.15	6.161	20924932.0
2009-09-08 13:00:00	AAPL	Stock	6.1611	6.1643	6.1429	6.1521	24995236.0
2009-09-08 14:00:00	AAPL	Stock	6.1521	6.1675	6.1432	6.1582	32737600.0
2009-09-08 15:00:00	AAPL	Stock	6.1582	6.1757	6.1536	6.1757	50002428.0
2009-09-08 16:00:00	AAPL	Stock	6.1761	6.1761	6.1629	6.1693	10201912.0
2009-09-08 17:00:00	AAPL	Stock	6.1686	6.175	6.1671	6.175	434616.0
2009-09-08 18:00:00	AAPL	Stock	6.1732	6.1771	6.1696	6.1771	466676.0
2009-09-08 19:00:00	AAPL	Stock	6.1771	6.1771	6.1696	6.1743	196700.0
2009-09-08 04:00:00	MSFT	Stock	24.83	24.83	24.83	24.83	105.0
2009-09-08 06:00:00	MSFT	Stock	24.88	24.93	24.75	24.75	3900.0
2009-09-08 07:00:00	MSFT	Stock	24.93	24.93	24.82	24.82	1700.0
2009-09-08 08:00:00	MSFT	Stock	24.79	24.82	24.71	24.8	45685.0
2009-09-08 09:00:00	MSFT	Stock	24.8	24.81	24.42	24.53	7427651.0
2009-09-08 10:00:00	MSFT	Stock	24.53	24.56	24.45	24.5	9616783.0
2009-09-08 11:00:00	MSFT	Stock	24.49	24.55	24.41	24.53	7004272.0
2009-09-08 12:00:00	MSFT	Stock	24.52	24.7	24.51	24.66	5400890.0
2009-09-08 13:00:00	MSFT	Stock	24.66	24.78	24.65	24.73	4797023.0
2009-09-08 14:00:00	MSFT	Stock	24.725	24.8	24.68	24.78	4423171.0
2009-09-08 15:00:00	MSFT	Stock	24.772	24.84	24.71	24.82	11595817.0
2009-09-08 16:00:00	MSFT	Stock	24.82	24.82	24.625	24.78	2662127.0
2009-09-08 17:00:00	MSFT	Stock	24.76	24.79	24.73	24.73	1950.0
2009-09-08 18:00:00	MSFT	Stock	24.73	24.82	24.73	24.75	20496.0
2009-09-08 19:00:00	MSFT	Stock	24.8	24.81	24.8	24.8	1400.0
2009-09-08 07:00:00	NVDA	Stock	0.3813	0.3813	0.3813	0.3813	4000.0
2009-09-08 08:00:00	NVDA	Stock	0.375	0.385	0.375	0.3845	526520.0
2009-09-08 09:00:00	NVDA	Stock	0.3815	0.385	0.3788	0.3833	70057000.0
2009-09-08 10:00:00	NVDA	Stock	0.3833	0.3848	0.3775	0.3813	137784480.0
2009-09-08 11:00:00	NVDA	Stock	0.3811	0.3831	0.379	0.383	68638240.0
2009-09-08 12:00:00	NVDA	Stock	0.383	0.385	0.3822	0.3833	62902520.0
2009-09-08 13:00:00	NVDA	Stock	0.3835	0.3859	0.383	0.3835	43990720.0
2009-09-08 14:00:00	NVDA	Stock	0.3835	0.3874	0.3825	0.3865	69272640.0
2009-09-08 15:00:00	NVDA	Stock	0.3865	0.3882	0.3848	0.388	85846000.0
2009-09-08 16:00:00	NVDA	Stock	0.388	0.3888	0.3873	0.3888	7738800.0
2009-09-08 17:00:00	NVDA	Stock	0.3778	0.3778	0.3778	0.3778	4000.0
2009-09-08 19:00:00	NVDA	Stock	0.388	0.388	0.388	0.388	26000.0
2009-09-08 04:00:00	AMZN	Stock	4.01	4.01	4.01	4.01	2000.0
2009-09-08 06:00:00	AMZN	Stock	4.004	4.004	4.004	4.004	4000.0
2009-09-08 07:00:00	AMZN	Stock	4.0045	4.0045	4.0045	4.0045	2000.0
2009-09-08 08:00:00	AMZN	Stock	4.005	4.005	3.9765	3.995	45400.0
2009-09-08 09:00:00	AMZN	Stock	3.997	3.999	3.9535	3.9555	20065380.0
2009-09-08 10:00:00	AMZN	Stock	3.954	3.983	3.9435	3.977	18216880.0
2009-09-08 11:00:00	AMZN	Stock	3.9785	3.998	3.954	3.957	12178260.0

> showing 50 of 42,138 rows — these rows as CSV

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