PREVIEW / stock_1hour / 2008-07-29

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-07-29.parquet
  size:    822 KB
  rows:    40,023
  symbols: 3,325

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-07-29 07:00:00	AAPL	Stock	5.5357	5.5471	5.5186	5.5471	131180.0
2008-07-29 08:00:00	AAPL	Stock	5.5357	5.5607	5.535	5.5536	3231592.0
2008-07-29 09:00:00	AAPL	Stock	5.555	5.5996	5.4875	5.5736	103763128.0
2008-07-29 10:00:00	AAPL	Stock	5.5736	5.6946	5.5725	5.6675	168657580.0
2008-07-29 11:00:00	AAPL	Stock	5.6682	5.6829	5.6393	5.6539	68671260.0
2008-07-29 12:00:00	AAPL	Stock	5.6546	5.6764	5.6268	5.6429	71258600.0
2008-07-29 13:00:00	AAPL	Stock	5.6425	5.675	5.6307	5.6618	47507180.0
2008-07-29 14:00:00	AAPL	Stock	5.662	5.6625	5.6107	5.6146	75162892.0
2008-07-29 15:00:00	AAPL	Stock	5.6147	5.6421	5.5893	5.6071	114582076.0
2008-07-29 16:00:00	AAPL	Stock	5.6066	5.6355	5.6064	5.6125	22765512.0
2008-07-29 17:00:00	AAPL	Stock	5.6107	5.6125	5.6071	5.61	114744.0
2008-07-29 18:00:00	AAPL	Stock	5.6107	5.6143	5.6089	5.6125	257124.0
2008-07-29 19:00:00	AAPL	Stock	5.6139	5.6143	5.6071	5.6071	93968.0
2008-07-29 20:00:00	AAPL	Stock	5.6379	5.6379	5.6379	5.6379	34384.0
2008-07-29 07:00:00	MSFT	Stock	25.65	25.65	25.64	25.64	745.0
2008-07-29 08:00:00	MSFT	Stock	25.56	25.65	25.56	25.65	41641.0
2008-07-29 09:00:00	MSFT	Stock	25.67	25.87	25.4	25.86	5621707.0
2008-07-29 10:00:00	MSFT	Stock	25.86	26.11	25.85	26.03	10702193.0
2008-07-29 11:00:00	MSFT	Stock	26.03	26.19	26.0	26.1	8034503.0
2008-07-29 12:00:00	MSFT	Stock	26.1	26.18	26.0	26.05	7903811.0
2008-07-29 13:00:00	MSFT	Stock	26.04	26.14	25.94	26.11	6425667.0
2008-07-29 14:00:00	MSFT	Stock	26.11	26.13	25.94	26.0	6787468.0
2008-07-29 15:00:00	MSFT	Stock	25.998	26.15	25.99	26.1	10935568.0
2008-07-29 16:00:00	MSFT	Stock	26.11	26.12	26.0	26.07	8585793.0
2008-07-29 17:00:00	MSFT	Stock	26.07	26.07	26.07	26.07	200.0
2008-07-29 18:00:00	MSFT	Stock	26.07	26.11	26.06	26.11	37652.0
2008-07-29 19:00:00	MSFT	Stock	26.07	26.07	26.05	26.06	3100.0
2008-07-29 20:00:00	MSFT	Stock	25.97	25.97	25.97	25.97	1329.0
2008-07-29 07:00:00	NVDA	Stock	0.2875	0.2875	0.2875	0.2875	40000.0
2008-07-29 08:00:00	NVDA	Stock	0.29	0.2912	0.29	0.2912	8000.0
2008-07-29 09:00:00	NVDA	Stock	0.2902	0.291	0.2855	0.2866	75118960.0
2008-07-29 10:00:00	NVDA	Stock	0.2868	0.2975	0.2865	0.2965	105009440.0
2008-07-29 11:00:00	NVDA	Stock	0.2965	0.2985	0.2938	0.2978	75788440.0
2008-07-29 12:00:00	NVDA	Stock	0.2978	0.2985	0.295	0.2985	81266080.0
2008-07-29 13:00:00	NVDA	Stock	0.2985	0.2985	0.294	0.296	131136480.0
2008-07-29 14:00:00	NVDA	Stock	0.296	0.2973	0.293	0.2942	77082680.0
2008-07-29 15:00:00	NVDA	Stock	0.2945	0.2945	0.2902	0.291	182480680.0
2008-07-29 16:00:00	NVDA	Stock	0.2912	0.2967	0.29	0.2912	26867960.0
2008-07-29 17:00:00	NVDA	Stock	0.2912	0.2912	0.29	0.2912	28000.0
2008-07-29 18:00:00	NVDA	Stock	0.2912	0.2918	0.2912	0.2918	62400.0
2008-07-29 19:00:00	NVDA	Stock	0.2918	0.2918	0.2912	0.2912	127600.0
2008-07-29 08:00:00	AMZN	Stock	3.817	3.85	3.817	3.8495	34000.0
2008-07-29 09:00:00	AMZN	Stock	3.8475	3.932	3.808	3.9	20384620.0
2008-07-29 10:00:00	AMZN	Stock	3.9	3.94	3.8945	3.904	24813980.0
2008-07-29 11:00:00	AMZN	Stock	3.903	3.935	3.881	3.909	13222440.0
2008-07-29 12:00:00	AMZN	Stock	3.9065	3.911	3.8515	3.8535	13752720.0
2008-07-29 13:00:00	AMZN	Stock	3.854	3.9035	3.845	3.901	12224040.0
2008-07-29 14:00:00	AMZN	Stock	3.899	3.901	3.863	3.8855	14462640.0
2008-07-29 15:00:00	AMZN	Stock	3.8865	3.924	3.8685	3.9105	28973680.0
2008-07-29 16:00:00	AMZN	Stock	3.9105	3.9225	3.8944	3.9105	6498540.0

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

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