PREVIEW / stock_1hour / 2010-09-08

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-09-08.parquet
  size:    882 KB
  rows:    42,185
  symbols: 3,468

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
2010-09-08 04:00:00	AAPL	Stock	9.1968	9.1968	9.1679	9.1679	5600.0
2010-09-08 05:00:00	AAPL	Stock	9.1679	9.1679	9.1679	9.1679	22400.0
2010-09-08 06:00:00	AAPL	Stock	9.2286	9.2286	9.2143	9.2143	18480.0
2010-09-08 07:00:00	AAPL	Stock	9.2221	9.3043	9.2221	9.2875	429240.0
2010-09-08 08:00:00	AAPL	Stock	9.2896	9.3075	9.2546	9.2661	4414592.0
2010-09-08 09:00:00	AAPL	Stock	9.2707	9.3411	9.2536	9.3411	90553400.0
2010-09-08 10:00:00	AAPL	Stock	9.3407	9.3679	9.3293	9.3529	96878600.0
2010-09-08 11:00:00	AAPL	Stock	9.3522	9.3946	9.3521	9.3854	57644216.0
2010-09-08 12:00:00	AAPL	Stock	9.3861	9.4425	9.385	9.4311	60899804.0
2010-09-08 13:00:00	AAPL	Stock	9.4311	9.4332	9.375	9.3879	52520496.0
2010-09-08 14:00:00	AAPL	Stock	9.3882	9.4282	9.3657	9.4129	59066224.0
2010-09-08 15:00:00	AAPL	Stock	9.4118	9.4325	9.3704	9.3896	86915892.0
2010-09-08 16:00:00	AAPL	Stock	9.39	9.4051	9.3009	9.3896	14127904.0
2010-09-08 17:00:00	AAPL	Stock	9.39	9.4	9.3893	9.3982	403620.0
2010-09-08 18:00:00	AAPL	Stock	9.3982	9.4079	9.2479	9.3996	774928.0
2010-09-08 19:00:00	AAPL	Stock	9.3993	9.4104	9.3971	9.4043	120400.0
2010-09-08 07:00:00	MSFT	Stock	24.04	24.04	24.0	24.0	631.0
2010-09-08 08:00:00	MSFT	Stock	24.0	24.05	24.0	24.0	10003.0
2010-09-08 09:00:00	MSFT	Stock	24.0	24.1	24.0	24.06	4714118.0
2010-09-08 10:00:00	MSFT	Stock	24.06	24.2	24.04	24.138	7396508.0
2010-09-08 11:00:00	MSFT	Stock	24.13	24.17	23.96	24.01	7734001.0
2010-09-08 12:00:00	MSFT	Stock	24.01	24.02	23.96	24.0	7922959.0
2010-09-08 13:00:00	MSFT	Stock	24.0	24.0	23.8	23.81	9665176.0
2010-09-08 14:00:00	MSFT	Stock	23.815	23.94	23.74	23.9	11894768.0
2010-09-08 15:00:00	MSFT	Stock	23.903	24.01	23.89	23.92	12566616.0
2010-09-08 16:00:00	MSFT	Stock	23.92	24.051	23.757	23.757	2434502.0
2010-09-08 17:00:00	MSFT	Stock	23.98	23.98	23.93	23.96	1800.0
2010-09-08 18:00:00	MSFT	Stock	23.96	24.04	23.93	23.95	185400.0
2010-09-08 19:00:00	MSFT	Stock	23.95	24.0	23.93	24.0	2885.0
2010-09-08 08:00:00	NVDA	Stock	0.252	0.252	0.2503	0.2507	439160.0
2010-09-08 09:00:00	NVDA	Stock	0.2507	0.2507	0.2478	0.2478	110912440.0
2010-09-08 10:00:00	NVDA	Stock	0.2478	0.25	0.2475	0.2488	121894720.0
2010-09-08 11:00:00	NVDA	Stock	0.2488	0.253	0.2488	0.2527	196254520.0
2010-09-08 12:00:00	NVDA	Stock	0.2527	0.257	0.2523	0.2541	165322760.0
2010-09-08 13:00:00	NVDA	Stock	0.2543	0.2575	0.2535	0.2555	173729560.0
2010-09-08 14:00:00	NVDA	Stock	0.2553	0.2572	0.2538	0.257	118774880.0
2010-09-08 15:00:00	NVDA	Stock	0.2572	0.2598	0.2572	0.258	305778640.0
2010-09-08 16:00:00	NVDA	Stock	0.258	0.2598	0.2542	0.2588	29578120.0
2010-09-08 17:00:00	NVDA	Stock	0.2583	0.2583	0.2583	0.2583	49240.0
2010-09-08 18:00:00	NVDA	Stock	0.2583	0.2598	0.258	0.2595	486000.0
2010-09-08 19:00:00	NVDA	Stock	0.2595	0.2598	0.2592	0.2595	299680.0
2010-09-08 08:00:00	AMZN	Stock	6.8875	6.895	6.8735	6.8735	38400.0
2010-09-08 09:00:00	AMZN	Stock	6.875	6.92	6.8225	6.866	16172280.0
2010-09-08 10:00:00	AMZN	Stock	6.866	6.9095	6.835	6.871	20560180.0
2010-09-08 11:00:00	AMZN	Stock	6.871	6.9195	6.867	6.9075	13977600.0
2010-09-08 12:00:00	AMZN	Stock	6.9045	6.972	6.9045	6.96	12965360.0
2010-09-08 13:00:00	AMZN	Stock	6.962	6.985	6.9335	6.95	12586160.0
2010-09-08 14:00:00	AMZN	Stock	6.9495	6.961	6.9295	6.942	11174820.0
2010-09-08 15:00:00	AMZN	Stock	6.9425	6.969	6.92	6.9565	23604000.0
2010-09-08 16:00:00	AMZN	Stock	6.9505	6.96	6.916	6.9525	1015500.0

> showing 50 of 42,185 rows — these rows as CSV

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