PREVIEW / stock_1hour / 2007-08-27

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-08-27.parquet
  size:    745 KB
  rows:    37,282
  symbols: 3,109

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-08-27 09:00:00	AAPL	Stock	4.764	4.78	4.74	4.7743	126891492.0
2007-08-27 10:00:00	AAPL	Stock	4.7746	4.8093	4.7564	4.7786	137237352.0
2007-08-27 11:00:00	AAPL	Stock	4.7782	4.7789	4.7514	4.7586	68770380.0
2007-08-27 12:00:00	AAPL	Stock	4.7589	4.7707	4.7464	4.7646	61345592.0
2007-08-27 13:00:00	AAPL	Stock	4.765	4.7811	4.75	4.7582	52808168.0
2007-08-27 14:00:00	AAPL	Stock	4.7582	4.775	4.7511	4.7572	56635992.0
2007-08-27 15:00:00	AAPL	Stock	4.7575	4.7596	4.7179	4.725	114252096.0
2007-08-27 16:00:00	AAPL	Stock	4.725	4.7254	4.7193	4.7232	2873892.0
2007-08-27 09:00:00	MSFT	Stock	28.61	28.77	28.54	28.65	2388496.0
2007-08-27 10:00:00	MSFT	Stock	28.66	28.69	28.5	28.503	3519957.0
2007-08-27 11:00:00	MSFT	Stock	28.51	28.51	28.42	28.44	2410618.0
2007-08-27 12:00:00	MSFT	Stock	28.45	28.55	28.4	28.53	2254724.0
2007-08-27 13:00:00	MSFT	Stock	28.53	28.58	28.5	28.562	2986754.0
2007-08-27 14:00:00	MSFT	Stock	28.562	28.61	28.5	28.51	2491409.0
2007-08-27 15:00:00	MSFT	Stock	28.51	28.52	28.43	28.49	5182918.0
2007-08-27 16:00:00	MSFT	Stock	28.48	28.49	28.48	28.49	1063270.0
2007-08-27 07:00:00	NVDA	Stock	0.8053	0.8053	0.8053	0.8053	6000.0
2007-08-27 08:00:00	NVDA	Stock	0.8082	0.8082	0.8025	0.8025	138000.0
2007-08-27 09:00:00	NVDA	Stock	0.8025	0.8148	0.8	0.8143	47261700.0
2007-08-27 10:00:00	NVDA	Stock	0.8145	0.8265	0.8113	0.8183	116174460.0
2007-08-27 11:00:00	NVDA	Stock	0.818	0.8242	0.814	0.8227	71545500.0
2007-08-27 12:00:00	NVDA	Stock	0.8227	0.8233	0.8168	0.8225	51446220.0
2007-08-27 13:00:00	NVDA	Stock	0.8225	0.8265	0.8212	0.8238	60757260.0
2007-08-27 14:00:00	NVDA	Stock	0.8237	0.8308	0.8228	0.8258	72070560.0
2007-08-27 15:00:00	NVDA	Stock	0.8257	0.829	0.8212	0.8227	109347240.0
2007-08-27 16:00:00	NVDA	Stock	0.8227	0.8227	0.8207	0.8222	21489540.0
2007-08-27 17:00:00	NVDA	Stock	0.8222	0.8232	0.8222	0.8232	66600.0
2007-08-27 18:00:00	NVDA	Stock	0.8267	0.8288	0.825	0.825	320400.0
2007-08-27 19:00:00	NVDA	Stock	0.825	0.825	0.8223	0.8223	163260.0
2007-08-27 07:00:00	AMZN	Stock	3.925	4.0375	3.925	4.035	347360.0
2007-08-27 08:00:00	AMZN	Stock	4.0255	4.047	4.023	4.0255	1046920.0
2007-08-27 09:00:00	AMZN	Stock	4.026	4.045	3.98	3.993	27975360.0
2007-08-27 10:00:00	AMZN	Stock	3.9925	4.0085	3.9725	3.999	19701440.0
2007-08-27 11:00:00	AMZN	Stock	3.9985	4.004	3.95	3.975	18721080.0
2007-08-27 12:00:00	AMZN	Stock	3.976	3.9875	3.9655	3.9785	11331140.0
2007-08-27 13:00:00	AMZN	Stock	3.978	3.989	3.961	3.972	9719640.0
2007-08-27 14:00:00	AMZN	Stock	3.9715	3.9845	3.955	3.9675	16328360.0
2007-08-27 15:00:00	AMZN	Stock	3.967	3.9695	3.921	3.93	23102760.0
2007-08-27 16:00:00	AMZN	Stock	3.9325	3.9325	3.9035	3.9175	2329000.0
2007-08-27 17:00:00	AMZN	Stock	3.9145	3.92	3.913	3.9135	31000.0
2007-08-27 18:00:00	AMZN	Stock	3.922	3.922	3.921	3.921	12000.0
2007-08-27 19:00:00	AMZN	Stock	3.9215	3.9215	3.9175	3.9175	22780.0
2007-08-27 09:00:00	TLT	Stock	88.28	88.3	88.21	88.26	105600.0
2007-08-27 10:00:00	TLT	Stock	88.23	88.41	88.15	88.36	400000.0
2007-08-27 11:00:00	TLT	Stock	88.35	88.43	88.33	88.37	332000.0
2007-08-27 12:00:00	TLT	Stock	88.37	88.41	88.25	88.26	171600.0
2007-08-27 13:00:00	TLT	Stock	88.25	88.35	88.21	88.35	177300.0
2007-08-27 14:00:00	TLT	Stock	88.34	88.4	88.28	88.34	185900.0
2007-08-27 15:00:00	TLT	Stock	88.34	88.45	88.31	88.45	123600.0
2007-08-27 16:00:00	TLT	Stock	88.45	88.48	88.31	88.31	15300.0

> showing 50 of 37,282 rows — these rows as CSV

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