PREVIEW / stock_1hour / 2008-12-05

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-12-05.parquet
  size:    784 KB
  rows:    39,582
  symbols: 3,319

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-12-05 04:00:00	AAPL	Stock	3.2786	3.2786	3.2714	3.2714	5600.0
2008-12-05 05:00:00	AAPL	Stock	3.2786	3.2786	3.2786	3.2786	2800.0
2008-12-05 07:00:00	AAPL	Stock	3.2429	3.2429	3.2143	3.2411	22400.0
2008-12-05 08:00:00	AAPL	Stock	3.2321	3.2411	3.1961	3.2218	6006476.0
2008-12-05 09:00:00	AAPL	Stock	3.2232	3.2729	3.1789	3.1911	115624712.0
2008-12-05 10:00:00	AAPL	Stock	3.1914	3.2286	3.1736	3.2096	151048380.0
2008-12-05 11:00:00	AAPL	Stock	3.2099	3.2471	3.1964	3.2389	94318252.0
2008-12-05 12:00:00	AAPL	Stock	3.2392	3.2529	3.2057	3.2271	82054840.0
2008-12-05 13:00:00	AAPL	Stock	3.2279	3.3204	3.2261	3.3071	131050808.0
2008-12-05 14:00:00	AAPL	Stock	3.3071	3.3625	3.2811	3.3532	187410916.0
2008-12-05 15:00:00	AAPL	Stock	3.3525	3.3746	3.3261	3.3568	235268572.0
2008-12-05 16:00:00	AAPL	Stock	3.3575	3.3582	3.2746	3.3571	29328516.0
2008-12-05 17:00:00	AAPL	Stock	3.3536	3.3646	3.3529	3.3554	244748.0
2008-12-05 18:00:00	AAPL	Stock	3.3557	3.3571	3.3518	3.3529	581196.0
2008-12-05 19:00:00	AAPL	Stock	3.3536	3.3536	3.35	3.35	132664.0
2008-12-05 07:00:00	MSFT	Stock	18.77	19.09	18.77	18.86	1200.0
2008-12-05 08:00:00	MSFT	Stock	19.11	19.11	18.81	18.94	125452.0
2008-12-05 09:00:00	MSFT	Stock	18.94	18.99	18.67	18.68	6675523.0
2008-12-05 10:00:00	MSFT	Stock	18.67	18.74	18.47	18.65	11319455.0
2008-12-05 11:00:00	MSFT	Stock	18.65	18.78	18.6	18.702	8311658.0
2008-12-05 12:00:00	MSFT	Stock	18.7	18.8	18.6	18.68	5668855.0
2008-12-05 13:00:00	MSFT	Stock	18.68	19.22	18.67	19.13	9432380.0
2008-12-05 14:00:00	MSFT	Stock	19.13	19.71	19.0	19.53	13364125.0
2008-12-05 15:00:00	MSFT	Stock	19.53	19.98	19.37	19.83	27889457.0
2008-12-05 16:00:00	MSFT	Stock	19.83	19.88	19.166	19.87	7486509.0
2008-12-05 17:00:00	MSFT	Stock	19.75	19.79	19.75	19.79	2160.0
2008-12-05 18:00:00	MSFT	Stock	19.76	19.76	19.75	19.75	1040.0
2008-12-05 19:00:00	MSFT	Stock	19.75	19.75	19.73	19.75	1550.0
2008-12-05 08:00:00	NVDA	Stock	0.175	0.175	0.1703	0.1703	320000.0
2008-12-05 09:00:00	NVDA	Stock	0.172	0.1793	0.1715	0.1755	44636640.0
2008-12-05 10:00:00	NVDA	Stock	0.1755	0.1758	0.17	0.1728	60345200.0
2008-12-05 11:00:00	NVDA	Stock	0.1725	0.1736	0.17	0.1715	44415480.0
2008-12-05 12:00:00	NVDA	Stock	0.1715	0.173	0.1685	0.1688	41035320.0
2008-12-05 13:00:00	NVDA	Stock	0.1689	0.1783	0.1688	0.1778	47774160.0
2008-12-05 14:00:00	NVDA	Stock	0.1778	0.184	0.176	0.1818	67623560.0
2008-12-05 15:00:00	NVDA	Stock	0.182	0.1848	0.179	0.184	107080720.0
2008-12-05 16:00:00	NVDA	Stock	0.1838	0.1845	0.1713	0.1713	1027520.0
2008-12-05 18:00:00	NVDA	Stock	0.1825	0.1825	0.1825	0.1825	20000.0
2008-12-05 08:00:00	AMZN	Stock	2.36	2.36	2.3	2.305	688700.0
2008-12-05 09:00:00	AMZN	Stock	2.304	2.349	2.21	2.217	41521580.0
2008-12-05 10:00:00	AMZN	Stock	2.218	2.231	2.165	2.203	52900280.0
2008-12-05 11:00:00	AMZN	Stock	2.204	2.224	2.1875	2.2223	23417660.0
2008-12-05 12:00:00	AMZN	Stock	2.224	2.2416	2.2065	2.2245	22419660.0
2008-12-05 13:00:00	AMZN	Stock	2.226	2.3415	2.2255	2.3135	35657540.0
2008-12-05 14:00:00	AMZN	Stock	2.316	2.4245	2.261	2.3825	48842520.0
2008-12-05 15:00:00	AMZN	Stock	2.3815	2.418	2.333	2.414	58134920.0
2008-12-05 16:00:00	AMZN	Stock	2.4025	2.4085	2.394	2.404	856680.0
2008-12-05 17:00:00	AMZN	Stock	2.3945	2.404	2.3945	2.404	45100.0
2008-12-05 18:00:00	AMZN	Stock	2.404	2.41	2.404	2.41	29160.0
2008-12-05 19:00:00	AMZN	Stock	2.41	2.415	2.41	2.415	6800.0

> showing 50 of 39,582 rows — these rows as CSV

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