PREVIEW / stock_1hour / 2006-07-21

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-07-21.parquet
  size:    603 KB
  rows:    29,001
  symbols: 2,297

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-07-21 04:00:00	AAPL	Stock	2.1679	2.1679	2.1571	2.1571	141400.0
2006-07-21 07:00:00	AAPL	Stock	2.1571	2.1571	2.1429	2.1429	103376.0
2006-07-21 08:00:00	AAPL	Stock	2.1536	2.1564	2.1257	2.1357	4515868.0
2006-07-21 09:00:00	AAPL	Stock	2.1364	2.1579	2.1293	2.1475	162560860.0
2006-07-21 10:00:00	AAPL	Stock	2.1471	2.1782	2.1393	2.1725	190481228.0
2006-07-21 11:00:00	AAPL	Stock	2.1725	2.1839	2.1632	2.1818	104759984.0
2006-07-21 12:00:00	AAPL	Stock	2.1814	2.1818	2.1657	2.1739	76617436.0
2006-07-21 13:00:00	AAPL	Stock	2.1739	2.1782	2.1675	2.1682	70974904.0
2006-07-21 14:00:00	AAPL	Stock	2.1682	2.1689	2.1529	2.1621	104371960.0
2006-07-21 15:00:00	AAPL	Stock	2.1621	2.1739	2.1457	2.17	165847976.0
2006-07-21 16:00:00	AAPL	Stock	2.1689	2.1743	2.1675	2.1714	1680084.0
2006-07-21 17:00:00	AAPL	Stock	2.1732	2.1739	2.1686	2.1711	350784.0
2006-07-21 18:00:00	AAPL	Stock	2.1696	2.1696	2.1689	2.1689	91000.0
2006-07-21 05:00:00	MSFT	Stock	23.98	24.05	23.98	24.05	400.0
2006-07-21 06:00:00	MSFT	Stock	24.01	24.01	23.98	23.98	2100.0
2006-07-21 07:00:00	MSFT	Stock	24.02	24.11	23.75	24.01	46294.0
2006-07-21 08:00:00	MSFT	Stock	23.96	24.36	23.87	24.25	3361617.0
2006-07-21 09:00:00	MSFT	Stock	24.24	24.27	23.78	23.82	50430857.0
2006-07-21 10:00:00	MSFT	Stock	23.83	24.04	23.0	23.9	29842291.0
2006-07-21 11:00:00	MSFT	Stock	23.9	23.94	23.77	23.89	15315645.0
2006-07-21 12:00:00	MSFT	Stock	23.89	23.92	23.7	23.9	9868093.0
2006-07-21 13:00:00	MSFT	Stock	23.9	24.1	23.88	23.98	20091914.0
2006-07-21 14:00:00	MSFT	Stock	23.98	24.08	23.7	23.94	15197397.0
2006-07-21 15:00:00	MSFT	Stock	23.94	23.95	23.76	23.84	23327590.0
2006-07-21 16:00:00	MSFT	Stock	23.86	23.88	23.8	23.81	4585679.0
2006-07-21 17:00:00	MSFT	Stock	23.82	23.87	23.8	23.87	11346.0
2006-07-21 18:00:00	MSFT	Stock	23.83	23.85	23.83	23.85	5200.0
2006-07-21 07:00:00	NVDA	Stock	0.3127	0.3127	0.3127	0.3127	12000.0
2006-07-21 08:00:00	NVDA	Stock	0.3133	0.3157	0.3128	0.313	372000.0
2006-07-21 09:00:00	NVDA	Stock	0.3137	0.3137	0.3002	0.3038	102359940.0
2006-07-21 10:00:00	NVDA	Stock	0.3033	0.3078	0.3022	0.3035	97344600.0
2006-07-21 11:00:00	NVDA	Stock	0.3036	0.3092	0.297	0.3	102511140.0
2006-07-21 12:00:00	NVDA	Stock	0.3	0.3002	0.298	0.2988	47438040.0
2006-07-21 13:00:00	NVDA	Stock	0.299	0.3008	0.2968	0.3	61218300.0
2006-07-21 14:00:00	NVDA	Stock	0.3	0.3003	0.2953	0.2953	56546280.0
2006-07-21 15:00:00	NVDA	Stock	0.2953	0.2978	0.2938	0.296	148472160.0
2006-07-21 16:00:00	NVDA	Stock	0.2952	0.2963	0.2902	0.2922	3912360.0
2006-07-21 17:00:00	NVDA	Stock	0.2922	0.2942	0.2892	0.2942	2054400.0
2006-07-21 18:00:00	NVDA	Stock	0.2942	0.2948	0.2918	0.2933	150000.0
2006-07-21 08:00:00	AMZN	Stock	1.7025	1.7025	1.6975	1.6975	15000.0
2006-07-21 09:00:00	AMZN	Stock	1.6975	1.6985	1.6815	1.685	22872140.0
2006-07-21 10:00:00	AMZN	Stock	1.685	1.685	1.6475	1.668	31599960.0
2006-07-21 11:00:00	AMZN	Stock	1.6675	1.68	1.6605	1.678	14658460.0
2006-07-21 12:00:00	AMZN	Stock	1.678	1.6795	1.666	1.67	10465460.0
2006-07-21 13:00:00	AMZN	Stock	1.6705	1.68	1.663	1.6665	8496380.0
2006-07-21 14:00:00	AMZN	Stock	1.6665	1.6674	1.646	1.6555	16366180.0
2006-07-21 15:00:00	AMZN	Stock	1.6555	1.6675	1.654	1.66	32495100.0
2006-07-21 16:00:00	AMZN	Stock	1.6595	1.6665	1.658	1.6625	590240.0
2006-07-21 17:00:00	AMZN	Stock	1.658	1.658	1.658	1.658	6000.0
2006-07-21 09:00:00	CL	Stock	31.475	31.58	31.405	31.425	1172200.0

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

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