PREVIEW / stock_1hour / 2008-09-08

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-09-08.parquet
  size:    834 KB
  rows:    40,678
  symbols: 3,320

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
2008-09-08 04:00:00	AAPL	Stock	5.78	5.78	5.78	5.78	2800.0
2008-09-08 06:00:00	AAPL	Stock	5.8571	5.875	5.8571	5.875	64484.0
2008-09-08 07:00:00	AAPL	Stock	5.8754	5.8839	5.8429	5.8571	713776.0
2008-09-08 08:00:00	AAPL	Stock	5.8571	5.875	5.8429	5.8643	4586092.0
2008-09-08 09:00:00	AAPL	Stock	5.8646	5.8946	5.6786	5.6846	142010568.0
2008-09-08 10:00:00	AAPL	Stock	5.6836	5.7375	5.6114	5.6168	188257804.0
2008-09-08 11:00:00	AAPL	Stock	5.6168	5.6875	5.4479	5.4771	186567192.0
2008-09-08 12:00:00	AAPL	Stock	5.4775	5.5982	5.4092	5.5768	151665640.0
2008-09-08 13:00:00	AAPL	Stock	5.5768	5.5954	5.5082	5.515	92615740.0
2008-09-08 14:00:00	AAPL	Stock	5.5146	5.6182	5.4979	5.5821	111386688.0
2008-09-08 15:00:00	AAPL	Stock	5.5821	5.6657	5.5414	5.6407	146822984.0
2008-09-08 16:00:00	AAPL	Stock	5.64	5.64	5.5854	5.6204	9998576.0
2008-09-08 17:00:00	AAPL	Stock	5.6164	5.7207	5.6111	5.6311	3022404.0
2008-09-08 18:00:00	AAPL	Stock	5.625	5.64	5.6196	5.6314	182616.0
2008-09-08 19:00:00	AAPL	Stock	5.6207	5.6275	5.6196	5.6246	124264.0
2008-09-08 07:00:00	MSFT	Stock	26.25	26.3	26.25	26.28	1550.0
2008-09-08 08:00:00	MSFT	Stock	26.16	26.2	26.01	26.15	57029.0
2008-09-08 09:00:00	MSFT	Stock	26.19	26.33	25.74	25.76	9152527.0
2008-09-08 10:00:00	MSFT	Stock	25.76	26.19	25.67	25.85	11829104.0
2008-09-08 11:00:00	MSFT	Stock	25.85	26.0	25.69	25.84	9224126.0
2008-09-08 12:00:00	MSFT	Stock	25.842	26.01	25.73	25.96	6099053.0
2008-09-08 13:00:00	MSFT	Stock	25.97	25.99	25.75	25.76	4776323.0
2008-09-08 14:00:00	MSFT	Stock	25.76	25.95	25.75	25.85	4855819.0
2008-09-08 15:00:00	MSFT	Stock	25.84	26.13	25.75	26.13	10716566.0
2008-09-08 16:00:00	MSFT	Stock	26.13	26.2	25.904	26.15	3523519.0
2008-09-08 17:00:00	MSFT	Stock	26.06	26.19	25.65	26.19	253797.0
2008-09-08 19:00:00	MSFT	Stock	26.12	26.17	26.12	26.12	2762.0
2008-09-08 08:00:00	NVDA	Stock	0.3055	0.3055	0.2945	0.2958	427960.0
2008-09-08 09:00:00	NVDA	Stock	0.2958	0.3	0.281	0.2848	185043680.0
2008-09-08 10:00:00	NVDA	Stock	0.285	0.2895	0.2828	0.2832	203306040.0
2008-09-08 11:00:00	NVDA	Stock	0.2832	0.2845	0.2812	0.2838	199608320.0
2008-09-08 12:00:00	NVDA	Stock	0.2838	0.2838	0.2772	0.2783	192013120.0
2008-09-08 13:00:00	NVDA	Stock	0.2782	0.279	0.276	0.2763	162151160.0
2008-09-08 14:00:00	NVDA	Stock	0.2763	0.28	0.275	0.278	154318360.0
2008-09-08 15:00:00	NVDA	Stock	0.2778	0.2822	0.2778	0.2795	188519000.0
2008-09-08 16:00:00	NVDA	Stock	0.2803	0.2816	0.2785	0.2798	4815920.0
2008-09-08 17:00:00	NVDA	Stock	0.2788	0.2788	0.278	0.2788	1788800.0
2008-09-08 18:00:00	NVDA	Stock	0.2788	0.28	0.2788	0.28	50000.0
2008-09-08 19:00:00	NVDA	Stock	0.2792	0.2792	0.279	0.2792	22000.0
2008-09-08 08:00:00	AMZN	Stock	4.0925	4.125	4.075	4.1025	673480.0
2008-09-08 09:00:00	AMZN	Stock	4.1245	4.1875	4.085	4.0915	43293600.0
2008-09-08 10:00:00	AMZN	Stock	4.093	4.124	4.0485	4.0641	25847700.0
2008-09-08 11:00:00	AMZN	Stock	4.063	4.092	3.969	3.982	31477560.0
2008-09-08 12:00:00	AMZN	Stock	3.98	4.043	3.9425	4.0315	21421780.0
2008-09-08 13:00:00	AMZN	Stock	4.0315	4.036	3.965	3.9685	17927240.0
2008-09-08 14:00:00	AMZN	Stock	3.9685	4.0355	3.96	4.0265	15858180.0
2008-09-08 15:00:00	AMZN	Stock	4.0275	4.078	3.9935	4.0635	27644540.0
2008-09-08 16:00:00	AMZN	Stock	4.0635	4.0635	4.03	4.0635	947660.0
2008-09-08 17:00:00	AMZN	Stock	4.0635	4.0635	3.9595	3.9595	436000.0
2008-09-08 08:00:00	TLT	Stock	94.05	94.59	94.0	94.57	18700.0

> showing 50 of 40,678 rows — these rows as CSV

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