PREVIEW / stock_1hour / 2008-10-09

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-10-09.parquet
  size:    863 KB
  rows:    43,633
  symbols: 3,365

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-10-09 04:00:00	AAPL	Stock	3.3014	3.3064	3.3014	3.3064	25200.0
2008-10-09 05:00:00	AAPL	Stock	3.3364	3.3364	3.3364	3.3364	2800.0
2008-10-09 06:00:00	AAPL	Stock	3.305	3.305	3.305	3.305	2800.0
2008-10-09 07:00:00	AAPL	Stock	3.3107	3.3571	3.2857	3.2857	475020.0
2008-10-09 08:00:00	AAPL	Stock	3.2964	3.3143	3.2654	3.2854	6373164.0
2008-10-09 09:00:00	AAPL	Stock	3.2857	3.4214	3.2836	3.3271	208726840.0
2008-10-09 10:00:00	AAPL	Stock	3.3267	3.3696	3.2246	3.2546	283126620.0
2008-10-09 11:00:00	AAPL	Stock	3.255	3.3343	3.1814	3.2836	256383176.0
2008-10-09 12:00:00	AAPL	Stock	3.2836	3.3339	3.2614	3.2829	141557836.0
2008-10-09 13:00:00	AAPL	Stock	3.2829	3.3425	3.2646	3.2907	152449052.0
2008-10-09 14:00:00	AAPL	Stock	3.2914	3.3214	3.2229	3.2232	163235408.0
2008-10-09 15:00:00	AAPL	Stock	3.225	3.2589	3.0929	3.1786	359434012.0
2008-10-09 16:00:00	AAPL	Stock	3.1786	3.3003	3.1375	3.1518	34640228.0
2008-10-09 17:00:00	AAPL	Stock	3.1525	3.1729	3.1429	3.1643	913248.0
2008-10-09 18:00:00	AAPL	Stock	3.1707	3.2143	3.1607	3.1921	627312.0
2008-10-09 19:00:00	AAPL	Stock	3.1857	3.2071	3.1779	3.1964	349804.0
2008-10-09 07:00:00	MSFT	Stock	23.77	23.77	23.42	23.5	20436.0
2008-10-09 08:00:00	MSFT	Stock	23.5	23.75	23.47	23.7	109033.0
2008-10-09 09:00:00	MSFT	Stock	23.74	23.91	23.27	23.608	11629735.0
2008-10-09 10:00:00	MSFT	Stock	23.6	23.75	23.42	23.58	16532359.0
2008-10-09 11:00:00	MSFT	Stock	23.58	23.75	23.21	23.37	18031152.0
2008-10-09 12:00:00	MSFT	Stock	23.37	23.68	23.31	23.54	8227588.0
2008-10-09 13:00:00	MSFT	Stock	23.56	23.9	23.54	23.66	13689002.0
2008-10-09 14:00:00	MSFT	Stock	23.66	23.73	23.27	23.31	13452235.0
2008-10-09 15:00:00	MSFT	Stock	23.31	23.4	22.07	22.32	39718230.0
2008-10-09 16:00:00	MSFT	Stock	22.31	24.14	22.128	22.32	8783247.0
2008-10-09 17:00:00	MSFT	Stock	22.32	23.557	22.3	22.41	39766.0
2008-10-09 18:00:00	MSFT	Stock	22.4	22.42	22.22	22.3	15547.0
2008-10-09 19:00:00	MSFT	Stock	22.33	22.43	22.33	22.4	7477.0
2008-10-09 04:00:00	NVDA	Stock	0.2268	0.2268	0.2132	0.2132	8000.0
2008-10-09 08:00:00	NVDA	Stock	0.19	0.1938	0.19	0.1938	316000.0
2008-10-09 09:00:00	NVDA	Stock	0.1925	0.1942	0.1863	0.1865	85633840.0
2008-10-09 10:00:00	NVDA	Stock	0.1865	0.1915	0.1828	0.184	119398760.0
2008-10-09 11:00:00	NVDA	Stock	0.184	0.189	0.1803	0.1873	147695480.0
2008-10-09 12:00:00	NVDA	Stock	0.1873	0.1913	0.1858	0.186	71208840.0
2008-10-09 13:00:00	NVDA	Stock	0.186	0.1888	0.185	0.187	77193520.0
2008-10-09 14:00:00	NVDA	Stock	0.187	0.188	0.1805	0.1808	94797920.0
2008-10-09 15:00:00	NVDA	Stock	0.1808	0.181	0.171	0.173	278609120.0
2008-10-09 16:00:00	NVDA	Stock	0.173	0.1826	0.1703	0.172	25952720.0
2008-10-09 17:00:00	NVDA	Stock	0.1841	0.1844	0.1705	0.1705	1124720.0
2008-10-09 18:00:00	NVDA	Stock	0.1713	0.1725	0.1713	0.1725	346400.0
2008-10-09 19:00:00	NVDA	Stock	0.1725	0.1725	0.1715	0.1725	112000.0
2008-10-09 08:00:00	AMZN	Stock	3.075	3.1115	3.075	3.1115	190020.0
2008-10-09 09:00:00	AMZN	Stock	3.112	3.175	3.052	3.1035	34052940.0
2008-10-09 10:00:00	AMZN	Stock	3.105	3.119	2.975	2.98	39431160.0
2008-10-09 11:00:00	AMZN	Stock	2.982	3.074	2.914	3.0105	31507140.0
2008-10-09 12:00:00	AMZN	Stock	3.012	3.0625	2.9565	2.976	14177720.0
2008-10-09 13:00:00	AMZN	Stock	2.9775	3.034	2.9625	3.023	25005200.0
2008-10-09 14:00:00	AMZN	Stock	3.0195	3.0475	2.96	2.9775	26912000.0
2008-10-09 15:00:00	AMZN	Stock	2.976	2.9885	2.8	2.8	95566180.0

> showing 50 of 43,633 rows — these rows as CSV

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