PREVIEW / stock_1hour / 2006-06-08

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-06-08.parquet
  size:    618 KB
  rows:    29,336
  symbols: 2,288

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-08 04:00:00	AAPL	Stock	2.0696	2.0696	2.0696	2.0696	5600.0
2006-06-08 05:00:00	AAPL	Stock	2.0679	2.0679	2.0679	2.0679	5600.0
2006-06-08 07:00:00	AAPL	Stock	2.0693	2.075	2.0671	2.0714	305200.0
2006-06-08 08:00:00	AAPL	Stock	2.0714	2.1	2.0714	2.0964	4031916.0
2006-06-08 09:00:00	AAPL	Stock	2.0964	2.1196	2.0843	2.1014	130383764.0
2006-06-08 10:00:00	AAPL	Stock	2.1011	2.1125	2.0411	2.0689	250414080.0
2006-06-08 11:00:00	AAPL	Stock	2.0689	2.088	2.0518	2.0818	202653444.0
2006-06-08 12:00:00	AAPL	Stock	2.0818	2.1139	2.0814	2.1071	173344472.0
2006-06-08 13:00:00	AAPL	Stock	2.1075	2.1161	2.0864	2.1161	146777316.0
2006-06-08 14:00:00	AAPL	Stock	2.1161	2.1475	2.1061	2.1386	200790548.0
2006-06-08 15:00:00	AAPL	Stock	2.1386	2.1761	2.1361	2.1707	275203740.0
2006-06-08 16:00:00	AAPL	Stock	2.1704	2.175	2.1607	2.1696	4408236.0
2006-06-08 17:00:00	AAPL	Stock	2.1704	2.175	2.1664	2.175	633640.0
2006-06-08 18:00:00	AAPL	Stock	2.1757	2.1768	2.1699	2.1746	293468.0
2006-06-08 04:00:00	MSFT	Stock	21.88	21.88	21.85	21.85	200.0
2006-06-08 05:00:00	MSFT	Stock	21.91	21.91	21.9	21.9	300.0
2006-06-08 06:00:00	MSFT	Stock	21.9	21.9	21.89	21.89	1250.0
2006-06-08 07:00:00	MSFT	Stock	21.9	21.94	21.86	21.94	15121.0
2006-06-08 08:00:00	MSFT	Stock	21.99	22.03	21.93	22.0	76300.0
2006-06-08 09:00:00	MSFT	Stock	22.03	22.17	21.98	22.11	11279898.0
2006-06-08 10:00:00	MSFT	Stock	22.11	22.18	22.04	22.1	19434280.0
2006-06-08 11:00:00	MSFT	Stock	22.1	22.16	21.97	22.02	20853679.0
2006-06-08 12:00:00	MSFT	Stock	22.02	22.13	22.0	22.07	11105534.0
2006-06-08 13:00:00	MSFT	Stock	22.07	22.14	22.0	22.12	10008261.0
2006-06-08 14:00:00	MSFT	Stock	22.12	22.15	22.03	22.09	10098797.0
2006-06-08 15:00:00	MSFT	Stock	22.09	22.21	22.08	22.12	18224746.0
2006-06-08 16:00:00	MSFT	Stock	22.1	22.193	22.08	22.11	1496477.0
2006-06-08 17:00:00	MSFT	Stock	22.1	22.13	22.09	22.1	121524.0
2006-06-08 18:00:00	MSFT	Stock	22.13	22.14	22.109	22.13	12181.0
2006-06-08 08:00:00	NVDA	Stock	0.359	0.3617	0.3585	0.3617	270000.0
2006-06-08 09:00:00	NVDA	Stock	0.3593	0.3642	0.3495	0.356	77202600.0
2006-06-08 10:00:00	NVDA	Stock	0.356	0.356	0.3453	0.3512	122857140.0
2006-06-08 11:00:00	NVDA	Stock	0.3512	0.3598	0.3427	0.3455	111705240.0
2006-06-08 12:00:00	NVDA	Stock	0.3457	0.3525	0.3448	0.3507	78484740.0
2006-06-08 13:00:00	NVDA	Stock	0.3507	0.3508	0.3433	0.3495	80367960.0
2006-06-08 14:00:00	NVDA	Stock	0.3495	0.3582	0.3488	0.351	110210460.0
2006-06-08 15:00:00	NVDA	Stock	0.351	0.3592	0.3503	0.3565	135675600.0
2006-06-08 16:00:00	NVDA	Stock	0.357	0.3583	0.3553	0.3553	2412180.0
2006-06-08 17:00:00	NVDA	Stock	0.3553	0.3553	0.3553	0.3553	7620.0
2006-06-08 18:00:00	NVDA	Stock	0.3568	0.3572	0.3568	0.357	106800.0
2006-06-08 08:00:00	AMZN	Stock	1.688	1.688	1.688	1.688	32000.0
2006-06-08 09:00:00	AMZN	Stock	1.685	1.703	1.675	1.684	11927620.0
2006-06-08 10:00:00	AMZN	Stock	1.683	1.698	1.657	1.66	14905180.0
2006-06-08 11:00:00	AMZN	Stock	1.6595	1.6715	1.631	1.638	29235060.0
2006-06-08 12:00:00	AMZN	Stock	1.638	1.649	1.6255	1.6265	26896060.0
2006-06-08 13:00:00	AMZN	Stock	1.6265	1.665	1.621	1.6645	20819000.0
2006-06-08 14:00:00	AMZN	Stock	1.665	1.678	1.654	1.6605	18064920.0
2006-06-08 15:00:00	AMZN	Stock	1.6605	1.6805	1.6595	1.6755	40587880.0
2006-06-08 16:00:00	AMZN	Stock	1.675	1.6795	1.6705	1.6755	128420.0
2006-06-08 17:00:00	AMZN	Stock	1.631	1.631	1.631	1.631	6000.0

> showing 50 of 29,336 rows — these rows as CSV

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