PREVIEW / stock_1hour / 2008-11-25

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-11-25.parquet
  size:    805 KB
  rows:    40,767
  symbols: 3,337

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-11-25 07:00:00	AAPL	Stock	3.3214	3.3318	3.3036	3.3318	71400.0
2008-11-25 08:00:00	AAPL	Stock	3.3214	3.3893	3.2729	3.3821	4593568.0
2008-11-25 09:00:00	AAPL	Stock	3.3843	3.4129	3.2411	3.2543	163257948.0
2008-11-25 10:00:00	AAPL	Stock	3.2586	3.2679	3.1486	3.1818	258096552.0
2008-11-25 11:00:00	AAPL	Stock	3.1814	3.2818	3.1643	3.2657	165776576.0
2008-11-25 12:00:00	AAPL	Stock	3.2657	3.2746	3.1779	3.1857	127518132.0
2008-11-25 13:00:00	AAPL	Stock	3.185	3.2382	3.1736	3.1975	105281092.0
2008-11-25 14:00:00	AAPL	Stock	3.1986	3.2582	3.1764	3.245	121879100.0
2008-11-25 15:00:00	AAPL	Stock	3.2446	3.3082	3.2393	3.2432	244703200.0
2008-11-25 16:00:00	AAPL	Stock	3.2432	3.2705	3.2284	3.2321	35610204.0
2008-11-25 17:00:00	AAPL	Stock	3.2471	3.2514	3.2375	3.2511	749700.0
2008-11-25 18:00:00	AAPL	Stock	3.2464	3.2511	3.2386	3.2411	169540.0
2008-11-25 19:00:00	AAPL	Stock	3.2429	3.2571	3.2429	3.2571	131320.0
2008-11-25 05:00:00	MSFT	Stock	20.2	20.2	20.2	20.2	150.0
2008-11-25 08:00:00	MSFT	Stock	20.5	20.98	20.45	20.86	89456.0
2008-11-25 09:00:00	MSFT	Stock	20.85	20.93	20.21	20.36	9575026.0
2008-11-25 10:00:00	MSFT	Stock	20.36	20.52	19.94	19.97	12321565.0
2008-11-25 11:00:00	MSFT	Stock	19.97	20.22	19.78	20.11	8903203.0
2008-11-25 12:00:00	MSFT	Stock	20.12	20.15	19.7	19.748	8588044.0
2008-11-25 13:00:00	MSFT	Stock	19.76	20.0	19.73	19.85	6751671.0
2008-11-25 14:00:00	MSFT	Stock	19.841	20.02	19.55	19.99	9567613.0
2008-11-25 15:00:00	MSFT	Stock	19.99	20.4	19.99	20.0	21892634.0
2008-11-25 16:00:00	MSFT	Stock	20.0	20.263	19.85	20.088	12310961.0
2008-11-25 17:00:00	MSFT	Stock	19.97	20.11	19.94	19.97	83071.0
2008-11-25 18:00:00	MSFT	Stock	19.94	20.0	19.94	19.99	15557.0
2008-11-25 19:00:00	MSFT	Stock	19.99	20.49	19.99	20.0	11300.0
2008-11-25 08:00:00	NVDA	Stock	0.17	0.1718	0.1695	0.1718	354000.0
2008-11-25 09:00:00	NVDA	Stock	0.1735	0.1785	0.1703	0.1735	88368360.0
2008-11-25 10:00:00	NVDA	Stock	0.1735	0.1755	0.172	0.1723	78507280.0
2008-11-25 11:00:00	NVDA	Stock	0.1725	0.175	0.1713	0.1745	50751840.0
2008-11-25 12:00:00	NVDA	Stock	0.1748	0.1753	0.172	0.1735	59119320.0
2008-11-25 13:00:00	NVDA	Stock	0.1735	0.175	0.1723	0.1725	41476760.0
2008-11-25 14:00:00	NVDA	Stock	0.1725	0.175	0.1698	0.1743	48945160.0
2008-11-25 15:00:00	NVDA	Stock	0.1745	0.176	0.172	0.1748	131486840.0
2008-11-25 16:00:00	NVDA	Stock	0.175	0.1753	0.1705	0.1738	26852080.0
2008-11-25 17:00:00	NVDA	Stock	0.175	0.175	0.175	0.175	20000.0
2008-11-25 18:00:00	NVDA	Stock	0.1715	0.1748	0.1715	0.1748	160000.0
2008-11-25 19:00:00	NVDA	Stock	0.1748	0.1748	0.1718	0.1745	116800.0
2008-11-25 06:00:00	AMZN	Stock	2.115	2.1235	2.115	2.1235	18000.0
2008-11-25 07:00:00	AMZN	Stock	2.1235	2.1235	2.115	2.115	6000.0
2008-11-25 08:00:00	AMZN	Stock	2.089	2.1375	2.089	2.13	348000.0
2008-11-25 09:00:00	AMZN	Stock	2.13	2.1485	2.06	2.0705	43803340.0
2008-11-25 10:00:00	AMZN	Stock	2.0725	2.0865	2.02	2.03	40242360.0
2008-11-25 11:00:00	AMZN	Stock	2.0286	2.1225	1.9935	2.094	35004220.0
2008-11-25 12:00:00	AMZN	Stock	2.094	2.102	2.033	2.0555	19942780.0
2008-11-25 13:00:00	AMZN	Stock	2.0535	2.0665	2.0245	2.033	14539760.0
2008-11-25 14:00:00	AMZN	Stock	2.031	2.0625	1.9805	2.053	29764100.0
2008-11-25 15:00:00	AMZN	Stock	2.054	2.125	2.041	2.1095	57815780.0
2008-11-25 16:00:00	AMZN	Stock	2.1085	2.1095	2.0368	2.086	11298680.0
2008-11-25 17:00:00	AMZN	Stock	2.0697	2.0925	2.0569	2.0925	842000.0

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

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