PREVIEW / stock_1hour / 2006-06-09

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-06-09.parquet
  size:    594 KB
  rows:    28,204
  symbols: 2,271

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
2006-06-09 07:00:00	AAPL	Stock	2.1821	2.1879	2.1521	2.1839	160160.0
2006-06-09 08:00:00	AAPL	Stock	2.1864	2.1964	2.1729	2.1832	5130104.0
2006-06-09 09:00:00	AAPL	Stock	2.1821	2.1986	2.1632	2.165	159790736.0
2006-06-09 10:00:00	AAPL	Stock	2.165	2.17	2.1271	2.135	188267828.0
2006-06-09 11:00:00	AAPL	Stock	2.135	2.1554	2.1311	2.1407	100678340.0
2006-06-09 12:00:00	AAPL	Stock	2.1407	2.145	2.1257	2.13	47828508.0
2006-06-09 13:00:00	AAPL	Stock	2.13	2.1332	2.1118	2.1282	74756332.0
2006-06-09 14:00:00	AAPL	Stock	2.1282	2.145	2.1196	2.1304	75625452.0
2006-06-09 15:00:00	AAPL	Stock	2.1307	2.1332	2.1107	2.1154	113113028.0
2006-06-09 16:00:00	AAPL	Stock	2.1161	2.1339	2.1107	2.1132	3896172.0
2006-06-09 17:00:00	AAPL	Stock	2.1132	2.1157	2.1125	2.1125	106064.0
2006-06-09 18:00:00	AAPL	Stock	2.1136	2.1136	2.1118	2.1118	121436.0
2006-06-09 07:00:00	MSFT	Stock	22.2	22.2	22.14	22.16	5400.0
2006-06-09 08:00:00	MSFT	Stock	22.16	22.2	22.14	22.17	81176.0
2006-06-09 09:00:00	MSFT	Stock	22.16	22.19	22.04	22.09	7702727.0
2006-06-09 10:00:00	MSFT	Stock	22.1	22.11	22.02	22.08	9293788.0
2006-06-09 11:00:00	MSFT	Stock	22.08	22.09	22.02	22.05	7753623.0
2006-06-09 12:00:00	MSFT	Stock	22.04	22.06	22.0	22.01	3883202.0
2006-06-09 13:00:00	MSFT	Stock	22.01	22.1	22.0	22.0	4433649.0
2006-06-09 14:00:00	MSFT	Stock	22.0	22.08	21.97	22.067	5852113.0
2006-06-09 15:00:00	MSFT	Stock	22.06	22.08	21.89	21.93	11262671.0
2006-06-09 16:00:00	MSFT	Stock	21.93	22.02	21.88	21.9	1238546.0
2006-06-09 17:00:00	MSFT	Stock	21.92	21.94	21.92	21.93	16851.0
2006-06-09 18:00:00	MSFT	Stock	21.93	21.93	21.906	21.92	1937.0
2006-06-09 08:00:00	NVDA	Stock	0.3632	0.364	0.3617	0.3617	180000.0
2006-06-09 09:00:00	NVDA	Stock	0.363	0.3678	0.3602	0.3635	59271660.0
2006-06-09 10:00:00	NVDA	Stock	0.3635	0.365	0.3577	0.3605	99969960.0
2006-06-09 11:00:00	NVDA	Stock	0.3607	0.3647	0.3602	0.3618	62193660.0
2006-06-09 12:00:00	NVDA	Stock	0.3617	0.3623	0.3565	0.3568	43841880.0
2006-06-09 13:00:00	NVDA	Stock	0.3568	0.3595	0.3528	0.3572	58170900.0
2006-06-09 14:00:00	NVDA	Stock	0.3573	0.362	0.357	0.3605	39946680.0
2006-06-09 15:00:00	NVDA	Stock	0.3605	0.3605	0.3558	0.3558	56509620.0
2006-06-09 16:00:00	NVDA	Stock	0.3558	0.3572	0.3548	0.3558	600420.0
2006-06-09 17:00:00	NVDA	Stock	0.3553	0.3553	0.3547	0.3547	189300.0
2006-06-09 07:00:00	AMZN	Stock	1.6785	1.6785	1.6785	1.6785	6000.0
2006-06-09 08:00:00	AMZN	Stock	1.68	1.68	1.672	1.672	6000.0
2006-06-09 09:00:00	AMZN	Stock	1.68	1.708	1.6725	1.7035	14878940.0
2006-06-09 10:00:00	AMZN	Stock	1.703	1.7175	1.6865	1.695	24890640.0
2006-06-09 11:00:00	AMZN	Stock	1.6951	1.703	1.684	1.6935	11218720.0
2006-06-09 12:00:00	AMZN	Stock	1.6925	1.698	1.6845	1.6865	7209580.0
2006-06-09 13:00:00	AMZN	Stock	1.687	1.691	1.6795	1.6865	8754340.0
2006-06-09 14:00:00	AMZN	Stock	1.686	1.706	1.685	1.698	12252500.0
2006-06-09 15:00:00	AMZN	Stock	1.698	1.7035	1.688	1.688	23962020.0
2006-06-09 16:00:00	AMZN	Stock	1.6915	1.695	1.689	1.689	312320.0
2006-06-09 17:00:00	AMZN	Stock	1.689	1.689	1.688	1.688	6000.0
2006-06-09 18:00:00	AMZN	Stock	1.6865	1.6885	1.6865	1.6885	6000.0
2006-06-09 09:00:00	CL	Stock	30.535	30.67	30.5	30.56	459600.0
2006-06-09 10:00:00	CL	Stock	30.555	30.74	30.505	30.665	762000.0
2006-06-09 11:00:00	CL	Stock	30.665	30.795	30.64	30.705	747600.0
2006-06-09 12:00:00	CL	Stock	30.705	30.765	30.635	30.685	695600.0

> showing 50 of 28,204 rows — these rows as CSV

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