PREVIEW / stock_1hour / 2008-01-09

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-01-09.parquet
  size:    842 KB
  rows:    41,594
  symbols: 3,276

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-01-09 04:00:00	AAPL	Stock	6.1729	6.2018	6.1711	6.1711	42000.0
2008-01-09 05:00:00	AAPL	Stock	6.1625	6.1914	6.1589	6.1796	53200.0
2008-01-09 06:00:00	AAPL	Stock	6.195	6.1964	6.1786	6.1786	17808.0
2008-01-09 07:00:00	AAPL	Stock	6.1821	6.1893	6.1607	6.1714	706916.0
2008-01-09 08:00:00	AAPL	Stock	6.1764	6.1768	6.1021	6.1307	9412396.0
2008-01-09 09:00:00	AAPL	Stock	6.1336	6.2314	6.0786	6.1714	223621832.0
2008-01-09 10:00:00	AAPL	Stock	6.1718	6.2121	6.04	6.1625	294036372.0
2008-01-09 11:00:00	AAPL	Stock	6.1621	6.1807	6.0179	6.0711	221265884.0
2008-01-09 12:00:00	AAPL	Stock	6.0711	6.1546	6.0575	6.1346	160300812.0
2008-01-09 13:00:00	AAPL	Stock	6.1354	6.1471	6.0439	6.0857	150643080.0
2008-01-09 14:00:00	AAPL	Stock	6.0857	6.2264	6.0107	6.2125	302798132.0
2008-01-09 15:00:00	AAPL	Stock	6.2111	6.4107	6.1929	6.4107	426972476.0
2008-01-09 16:00:00	AAPL	Stock	6.4098	6.4521	6.1216	6.4429	22383592.0
2008-01-09 17:00:00	AAPL	Stock	6.4425	6.4643	6.4393	6.4589	2789696.0
2008-01-09 18:00:00	AAPL	Stock	6.4557	6.4589	6.4464	6.4518	791812.0
2008-01-09 19:00:00	AAPL	Stock	6.4571	6.4604	6.4514	6.4561	629636.0
2008-01-09 06:00:00	MSFT	Stock	33.53	33.56	33.51	33.51	1400.0
2008-01-09 07:00:00	MSFT	Stock	33.43	33.43	33.43	33.43	200.0
2008-01-09 08:00:00	MSFT	Stock	33.5	33.51	33.4	33.45	13202.0
2008-01-09 09:00:00	MSFT	Stock	33.4	34.18	33.35	34.04	7476607.0
2008-01-09 10:00:00	MSFT	Stock	34.03	34.17	33.82	34.11	12283595.0
2008-01-09 11:00:00	MSFT	Stock	34.1	34.16	33.81	34.11	8789128.0
2008-01-09 12:00:00	MSFT	Stock	34.11	34.31	34.04	34.19	5884753.0
2008-01-09 13:00:00	MSFT	Stock	34.19	34.21	33.88	34.02	8275656.0
2008-01-09 14:00:00	MSFT	Stock	34.02	34.37	33.88	34.27	10248329.0
2008-01-09 15:00:00	MSFT	Stock	34.27	34.54	34.14	34.44	18101400.0
2008-01-09 16:00:00	MSFT	Stock	34.44	34.45	33.975	34.4	3017028.0
2008-01-09 17:00:00	MSFT	Stock	34.43	34.44	33.57	34.44	26303.0
2008-01-09 18:00:00	MSFT	Stock	34.42	34.45	34.4	34.45	10621.0
2008-01-09 19:00:00	MSFT	Stock	34.4	34.49	34.4	34.49	1050.0
2008-01-09 08:00:00	NVDA	Stock	0.6962	0.6988	0.6902	0.6988	418200.0
2008-01-09 09:00:00	NVDA	Stock	0.6945	0.7165	0.6898	0.7045	96493480.0
2008-01-09 10:00:00	NVDA	Stock	0.7042	0.7225	0.7027	0.7105	112482440.0
2008-01-09 11:00:00	NVDA	Stock	0.711	0.7113	0.6858	0.694	82002760.0
2008-01-09 12:00:00	NVDA	Stock	0.694	0.705	0.6925	0.701	65711960.0
2008-01-09 13:00:00	NVDA	Stock	0.7008	0.705	0.6928	0.6982	68936440.0
2008-01-09 14:00:00	NVDA	Stock	0.6985	0.7143	0.6935	0.7093	100612000.0
2008-01-09 15:00:00	NVDA	Stock	0.7093	0.7225	0.7085	0.7203	188783520.0
2008-01-09 16:00:00	NVDA	Stock	0.7203	0.7225	0.6962	0.7225	15213600.0
2008-01-09 17:00:00	NVDA	Stock	0.7213	0.725	0.7071	0.725	996400.0
2008-01-09 18:00:00	NVDA	Stock	0.7295	0.7318	0.7275	0.7275	559600.0
2008-01-09 19:00:00	NVDA	Stock	0.7278	0.731	0.7265	0.731	47200.0
2008-01-09 07:00:00	AMZN	Stock	4.4	4.4	4.4	4.4	2000.0
2008-01-09 08:00:00	AMZN	Stock	4.444	4.45	4.3905	4.3905	342540.0
2008-01-09 09:00:00	AMZN	Stock	4.3905	4.3905	4.24	4.2935	40065640.0
2008-01-09 10:00:00	AMZN	Stock	4.2935	4.324	4.166	4.2015	59385680.0
2008-01-09 11:00:00	AMZN	Stock	4.201	4.229	4.1025	4.157	37234140.0
2008-01-09 12:00:00	AMZN	Stock	4.1558	4.225	4.138	4.152	24504640.0
2008-01-09 13:00:00	AMZN	Stock	4.1525	4.1635	4.056	4.078	37676320.0
2008-01-09 14:00:00	AMZN	Stock	4.0795	4.2025	4.012	4.196	55647840.0

> showing 50 of 41,594 rows — these rows as CSV

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