PREVIEW / stock_1hour / 2008-12-02

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-12-02.parquet
  size:    791 KB
  rows:    40,243
  symbols: 3,329

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-02 05:00:00	AAPL	Stock	3.2189	3.2189	3.2189	3.2189	14000.0
2008-12-02 06:00:00	AAPL	Stock	3.2189	3.2232	3.2179	3.2179	47600.0
2008-12-02 07:00:00	AAPL	Stock	3.2014	3.2254	3.2014	3.2161	125720.0
2008-12-02 08:00:00	AAPL	Stock	3.2164	3.2307	3.2161	3.2207	1040368.0
2008-12-02 09:00:00	AAPL	Stock	3.2218	3.2275	3.0893	3.1129	145969264.0
2008-12-02 10:00:00	AAPL	Stock	3.1114	3.2532	3.0986	3.2471	239328936.0
2008-12-02 11:00:00	AAPL	Stock	3.2471	3.2679	3.2186	3.2593	146949292.0
2008-12-02 12:00:00	AAPL	Stock	3.2593	3.2821	3.2321	3.2532	103950112.0
2008-12-02 13:00:00	AAPL	Stock	3.2532	3.2711	3.2082	3.2171	98683984.0
2008-12-02 14:00:00	AAPL	Stock	3.2171	3.25	3.1679	3.2454	148389276.0
2008-12-02 15:00:00	AAPL	Stock	3.2457	3.3089	3.1954	3.3032	158275628.0
2008-12-02 16:00:00	AAPL	Stock	3.3036	3.3036	3.2073	3.2911	28552328.0
2008-12-02 17:00:00	AAPL	Stock	3.2979	3.2986	3.2921	3.2964	264460.0
2008-12-02 18:00:00	AAPL	Stock	3.2964	3.3014	3.2929	3.2936	277452.0
2008-12-02 19:00:00	AAPL	Stock	3.2936	3.3043	3.2936	3.3036	455420.0
2008-12-02 05:00:00	MSFT	Stock	19.84	19.84	19.84	19.84	100.0
2008-12-02 07:00:00	MSFT	Stock	18.95	19.08	18.95	19.04	5011.0
2008-12-02 08:00:00	MSFT	Stock	18.97	19.02	18.82	19.0	46040.0
2008-12-02 09:00:00	MSFT	Stock	19.03	19.03	18.56	18.8	6188152.0
2008-12-02 10:00:00	MSFT	Stock	18.79	19.118	18.76	19.036	10403001.0
2008-12-02 11:00:00	MSFT	Stock	19.04	19.28	18.89	19.21	6454633.0
2008-12-02 12:00:00	MSFT	Stock	19.2	19.3	18.75	19.228	6499944.0
2008-12-02 13:00:00	MSFT	Stock	19.22	19.31	19.0	19.013	7524505.0
2008-12-02 14:00:00	MSFT	Stock	19.01	19.07	18.63	18.92	11470538.0
2008-12-02 15:00:00	MSFT	Stock	18.91	19.19	18.63	19.16	11973052.0
2008-12-02 16:00:00	MSFT	Stock	19.15	19.2	18.654	19.07	9847415.0
2008-12-02 17:00:00	MSFT	Stock	19.15	19.15	19.05	19.1	38911.0
2008-12-02 18:00:00	MSFT	Stock	19.1	19.13	19.05	19.05	2900.0
2008-12-02 19:00:00	MSFT	Stock	19.1	19.1	19.05	19.05	700.0
2008-12-02 08:00:00	NVDA	Stock	0.172	0.1785	0.172	0.1785	316000.0
2008-12-02 09:00:00	NVDA	Stock	0.1783	0.1783	0.1718	0.1733	55183920.0
2008-12-02 10:00:00	NVDA	Stock	0.173	0.1775	0.1725	0.1768	72986920.0
2008-12-02 11:00:00	NVDA	Stock	0.1768	0.1788	0.175	0.1783	41328600.0
2008-12-02 12:00:00	NVDA	Stock	0.178	0.1824	0.1778	0.1795	54545200.0
2008-12-02 13:00:00	NVDA	Stock	0.1795	0.181	0.177	0.1775	64111000.0
2008-12-02 14:00:00	NVDA	Stock	0.1773	0.1785	0.173	0.178	59833360.0
2008-12-02 15:00:00	NVDA	Stock	0.178	0.181	0.175	0.1803	109155080.0
2008-12-02 16:00:00	NVDA	Stock	0.18	0.1808	0.18	0.1808	28000.0
2008-12-02 04:00:00	AMZN	Stock	2.03	2.03	2.03	2.03	2000.0
2008-12-02 06:00:00	AMZN	Stock	2.0725	2.0725	2.0725	2.0725	8000.0
2008-12-02 08:00:00	AMZN	Stock	2.0625	2.092	2.0555	2.092	64600.0
2008-12-02 09:00:00	AMZN	Stock	2.08	2.08	1.941	1.9845	26115680.0
2008-12-02 10:00:00	AMZN	Stock	1.9835	2.062	1.978	2.0556	31010680.0
2008-12-02 11:00:00	AMZN	Stock	2.053	2.0855	2.0195	2.067	18315540.0
2008-12-02 12:00:00	AMZN	Stock	2.0665	2.0715	2.0485	2.0655	18702360.0
2008-12-02 13:00:00	AMZN	Stock	2.065	2.08	2.047	2.05	12433880.0
2008-12-02 14:00:00	AMZN	Stock	2.0485	2.0535	2.0015	2.043	24388280.0
2008-12-02 15:00:00	AMZN	Stock	2.043	2.0815	2.0185	2.0695	33423240.0
2008-12-02 16:00:00	AMZN	Stock	2.069	2.08	2.0592	2.08	225900.0
2008-12-02 18:00:00	AMZN	Stock	2.075	2.075	2.075	2.075	4000.0

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

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