PREVIEW / stock_1hour / 2008-01-15

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-01-15.parquet
  size:    812 KB
  rows:    40,486
  symbols: 3,244

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-15 04:00:00	AAPL	Stock	6.4107	6.4143	6.4107	6.4143	11200.0
2008-01-15 05:00:00	AAPL	Stock	6.3929	6.405	6.3739	6.375	139580.0
2008-01-15 06:00:00	AAPL	Stock	6.3779	6.4143	6.3779	6.4143	165480.0
2008-01-15 07:00:00	AAPL	Stock	6.3982	6.4107	6.3396	6.3632	717920.0
2008-01-15 08:00:00	AAPL	Stock	6.3568	6.3893	6.3475	6.3614	9345756.0
2008-01-15 09:00:00	AAPL	Stock	6.3611	6.385	6.2893	6.3471	135443000.0
2008-01-15 10:00:00	AAPL	Stock	6.3464	6.4007	6.2332	6.2825	302130360.0
2008-01-15 11:00:00	AAPL	Stock	6.2825	6.31	6.1782	6.2364	186972940.0
2008-01-15 12:00:00	AAPL	Stock	6.2361	6.2743	6.0204	6.0554	420701344.0
2008-01-15 13:00:00	AAPL	Stock	6.0554	6.1743	5.9075	5.9518	469855568.0
2008-01-15 14:00:00	AAPL	Stock	5.9518	6.0393	5.93	5.9625	302691676.0
2008-01-15 15:00:00	AAPL	Stock	5.9621	6.0546	5.8807	6.0357	458856272.0
2008-01-15 16:00:00	AAPL	Stock	6.0361	6.3859	5.8357	5.85	48395452.0
2008-01-15 17:00:00	AAPL	Stock	5.8529	6.385	5.8232	5.8286	8661800.0
2008-01-15 18:00:00	AAPL	Stock	5.8286	6.2884	5.8196	5.8214	4392360.0
2008-01-15 19:00:00	AAPL	Stock	5.8264	5.8264	5.8036	5.8218	2058812.0
2008-01-15 07:00:00	MSFT	Stock	34.19	34.2	34.19	34.2	2030.0
2008-01-15 08:00:00	MSFT	Stock	34.2	34.35	34.14	34.14	12921.0
2008-01-15 09:00:00	MSFT	Stock	34.1	34.35	34.0	34.32	5067646.0
2008-01-15 10:00:00	MSFT	Stock	34.31	34.36	34.08	34.14	10784045.0
2008-01-15 11:00:00	MSFT	Stock	34.15	34.2	34.04	34.19	5964504.0
2008-01-15 12:00:00	MSFT	Stock	34.19	34.23	34.095	34.22	5927905.0
2008-01-15 13:00:00	MSFT	Stock	34.22	34.32	34.17	34.17	6179262.0
2008-01-15 14:00:00	MSFT	Stock	34.18	34.23	34.0	34.072	7932905.0
2008-01-15 15:00:00	MSFT	Stock	34.08	34.38	34.0	34.0	15062931.0
2008-01-15 16:00:00	MSFT	Stock	34.0	34.176	32.6	34.0	4354600.0
2008-01-15 17:00:00	MSFT	Stock	32.73	34.39	32.7	32.97	610725.0
2008-01-15 18:00:00	MSFT	Stock	32.95	32.98	32.93	32.97	19630.0
2008-01-15 19:00:00	MSFT	Stock	32.92	32.97	32.91	32.91	10625.0
2008-01-15 07:00:00	NVDA	Stock	0.7035	0.7035	0.7	0.7	44000.0
2008-01-15 08:00:00	NVDA	Stock	0.6992	0.7058	0.6962	0.6962	1167200.0
2008-01-15 09:00:00	NVDA	Stock	0.6962	0.702	0.6832	0.686	94280000.0
2008-01-15 10:00:00	NVDA	Stock	0.6855	0.688	0.6588	0.6665	148472640.0
2008-01-15 11:00:00	NVDA	Stock	0.6665	0.675	0.6612	0.6662	69096760.0
2008-01-15 12:00:00	NVDA	Stock	0.6662	0.6662	0.6565	0.663	71728120.0
2008-01-15 13:00:00	NVDA	Stock	0.6633	0.6718	0.661	0.663	65165800.0
2008-01-15 14:00:00	NVDA	Stock	0.6633	0.668	0.6595	0.6648	67778600.0
2008-01-15 15:00:00	NVDA	Stock	0.665	0.6798	0.6602	0.6685	166456920.0
2008-01-15 16:00:00	NVDA	Stock	0.6682	0.7219	0.605	0.6075	37093840.0
2008-01-15 17:00:00	NVDA	Stock	0.6075	0.633	0.6073	0.63	4212400.0
2008-01-15 18:00:00	NVDA	Stock	0.6288	0.63	0.6225	0.6225	173520.0
2008-01-15 19:00:00	NVDA	Stock	0.6235	0.6235	0.6138	0.62	163320.0
2008-01-15 08:00:00	AMZN	Stock	4.1	4.1105	4.027	4.04	488580.0
2008-01-15 09:00:00	AMZN	Stock	4.04	4.0495	3.981	3.9875	27835580.0
2008-01-15 10:00:00	AMZN	Stock	3.9875	3.995	3.9255	3.955	34190220.0
2008-01-15 11:00:00	AMZN	Stock	3.955	4.0	3.953	3.9885	17538580.0
2008-01-15 12:00:00	AMZN	Stock	3.9885	4.0085	3.975	4.0	16882340.0
2008-01-15 13:00:00	AMZN	Stock	4.0	4.0375	3.958	3.98	22802680.0
2008-01-15 14:00:00	AMZN	Stock	3.98	4.0	3.965	3.9725	15130960.0
2008-01-15 15:00:00	AMZN	Stock	3.9725	4.0505	3.959	4.0125	49193480.0

> showing 50 of 40,486 rows — these rows as CSV

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