PREVIEW / stock_1hour / 2007-10-09

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-10-09.parquet
  size:    797 KB
  rows:    39,423
  symbols: 3,136

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
2007-10-09 05:00:00	AAPL	Stock	6.0157	6.0157	6.0157	6.0157	22400.0
2007-10-09 06:00:00	AAPL	Stock	6.0371	6.0371	6.0179	6.0307	131124.0
2007-10-09 07:00:00	AAPL	Stock	6.0346	6.0532	6.0346	6.0393	1097180.0
2007-10-09 08:00:00	AAPL	Stock	6.0429	6.0839	6.0357	6.0821	12701332.0
2007-10-09 09:00:00	AAPL	Stock	6.0818	6.1111	5.9968	6.0329	224850276.0
2007-10-09 10:00:00	AAPL	Stock	6.0321	6.0332	5.9529	5.9996	238987168.0
2007-10-09 11:00:00	AAPL	Stock	6.0	6.0607	5.975	6.0223	128830772.0
2007-10-09 12:00:00	AAPL	Stock	6.0223	6.0223	5.9796	6.0036	97379212.0
2007-10-09 13:00:00	AAPL	Stock	6.0036	6.0154	5.9571	5.9818	118158880.0
2007-10-09 14:00:00	AAPL	Stock	5.9818	6.0304	5.9743	6.0121	141924636.0
2007-10-09 15:00:00	AAPL	Stock	6.0118	6.0214	5.9825	5.9971	124095468.0
2007-10-09 16:00:00	AAPL	Stock	5.9961	6.0337	5.9857	5.995	14917140.0
2007-10-09 17:00:00	AAPL	Stock	5.9939	6.0207	5.9839	5.9861	1433516.0
2007-10-09 18:00:00	AAPL	Stock	5.995	5.995	5.975	5.9818	1031324.0
2007-10-09 19:00:00	AAPL	Stock	5.9804	6.0018	5.975	5.9818	509880.0
2007-10-09 07:00:00	MSFT	Stock	30.0	30.0	30.0	30.0	900.0
2007-10-09 08:00:00	MSFT	Stock	29.95	30.18	29.94	30.15	316467.0
2007-10-09 09:00:00	MSFT	Stock	30.15	30.3	29.84	30.23	12688394.0
2007-10-09 10:00:00	MSFT	Stock	30.22	30.39	30.21	30.36	11042623.0
2007-10-09 11:00:00	MSFT	Stock	30.36	30.38	30.25	30.32	5991175.0
2007-10-09 12:00:00	MSFT	Stock	30.32	30.33	30.15	30.183	4837615.0
2007-10-09 13:00:00	MSFT	Stock	30.19	30.25	30.16	30.21	4021173.0
2007-10-09 14:00:00	MSFT	Stock	30.21	30.3	30.19	30.19	7871491.0
2007-10-09 15:00:00	MSFT	Stock	30.2	30.23	30.04	30.1	13653025.0
2007-10-09 16:00:00	MSFT	Stock	30.09	30.31	30.049	30.1	2930466.0
2007-10-09 17:00:00	MSFT	Stock	30.1	30.28	30.08	30.1	383138.0
2007-10-09 18:00:00	MSFT	Stock	30.1	30.13	30.1	30.13	12654.0
2007-10-09 19:00:00	MSFT	Stock	30.13	30.13	30.13	30.13	150.0
2007-10-09 07:00:00	NVDA	Stock	0.9858	0.9858	0.9838	0.9858	20000.0
2007-10-09 08:00:00	NVDA	Stock	0.943	0.9498	0.943	0.9482	366040.0
2007-10-09 09:00:00	NVDA	Stock	0.9488	0.9498	0.927	0.9305	43935800.0
2007-10-09 10:00:00	NVDA	Stock	0.9308	0.931	0.9162	0.9203	52727160.0
2007-10-09 11:00:00	NVDA	Stock	0.9205	0.9262	0.9175	0.925	35813120.0
2007-10-09 12:00:00	NVDA	Stock	0.9252	0.9268	0.9118	0.9158	67432800.0
2007-10-09 13:00:00	NVDA	Stock	0.9158	0.9258	0.908	0.9142	63289280.0
2007-10-09 14:00:00	NVDA	Stock	0.9145	0.9205	0.911	0.9171	52824640.0
2007-10-09 15:00:00	NVDA	Stock	0.9172	0.9248	0.9152	0.921	74755080.0
2007-10-09 16:00:00	NVDA	Stock	0.9213	0.9242	0.92	0.9242	11520480.0
2007-10-09 17:00:00	NVDA	Stock	0.9218	0.9242	0.9213	0.9218	317160.0
2007-10-09 18:00:00	NVDA	Stock	0.9188	0.9238	0.9188	0.9238	46840.0
2007-10-09 04:00:00	AMZN	Stock	4.793	4.793	4.793	4.793	2000.0
2007-10-09 08:00:00	AMZN	Stock	4.8275	4.855	4.8125	4.833	1522440.0
2007-10-09 09:00:00	AMZN	Stock	4.835	4.8425	4.7725	4.7825	24407440.0
2007-10-09 10:00:00	AMZN	Stock	4.783	4.7874	4.7375	4.772	27666600.0
2007-10-09 11:00:00	AMZN	Stock	4.772	4.7805	4.7495	4.775	10307560.0
2007-10-09 12:00:00	AMZN	Stock	4.776	4.779	4.7525	4.7575	11477220.0
2007-10-09 13:00:00	AMZN	Stock	4.7585	4.777	4.75	4.757	13899440.0
2007-10-09 14:00:00	AMZN	Stock	4.758	4.7785	4.7525	4.7745	28481220.0
2007-10-09 15:00:00	AMZN	Stock	4.7745	4.794	4.7635	4.7665	18395480.0
2007-10-09 16:00:00	AMZN	Stock	4.7675	4.8175	4.764	4.7662	7140600.0

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

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