PREVIEW / stock_1hour / 2010-08-27

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-08-27.parquet
  size:    905 KB
  rows:    44,158
  symbols: 3,465

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-08-27 06:00:00	AAPL	Stock	8.6232	8.6429	8.6214	8.6429	57400.0
2010-08-27 07:00:00	AAPL	Stock	8.6046	8.6429	8.5993	8.6275	432600.0
2010-08-27 08:00:00	AAPL	Stock	8.6218	8.6729	8.5925	8.6421	3189704.0
2010-08-27 09:00:00	AAPL	Stock	8.6396	8.6646	8.5071	8.5111	69597360.0
2010-08-27 10:00:00	AAPL	Stock	8.5132	8.5996	8.4129	8.5589	186797212.0
2010-08-27 11:00:00	AAPL	Stock	8.5589	8.6264	8.5568	8.5861	69985972.0
2010-08-27 12:00:00	AAPL	Stock	8.5854	8.6161	8.5771	8.5896	38268244.0
2010-08-27 13:00:00	AAPL	Stock	8.5904	8.6239	8.5757	8.6214	52158120.0
2010-08-27 14:00:00	AAPL	Stock	8.6214	8.6307	8.5907	8.6114	43780072.0
2010-08-27 15:00:00	AAPL	Stock	8.6102	8.6321	8.5921	8.6282	68878852.0
2010-08-27 16:00:00	AAPL	Stock	8.6286	8.6375	8.5751	8.6375	10763256.0
2010-08-27 17:00:00	AAPL	Stock	8.6357	8.6607	8.6293	8.6546	1608208.0
2010-08-27 18:00:00	AAPL	Stock	8.6536	8.6536	8.6293	8.6475	159992.0
2010-08-27 19:00:00	AAPL	Stock	8.6482	8.6589	8.6482	8.6564	121716.0
2010-08-27 20:00:00	AAPL	Stock	8.5946	8.5946	8.5946	8.5946	8400.0
2010-08-27 08:00:00	MSFT	Stock	23.85	24.18	23.85	23.99	33700.0
2010-08-27 09:00:00	MSFT	Stock	23.99	24.02	23.73	23.76	5554756.0
2010-08-27 10:00:00	MSFT	Stock	23.76	23.86	23.51	23.53	17972441.0
2010-08-27 11:00:00	MSFT	Stock	23.535	23.77	23.53	23.65	8649951.0
2010-08-27 12:00:00	MSFT	Stock	23.65	23.78	23.59	23.635	5303455.0
2010-08-27 13:00:00	MSFT	Stock	23.635	23.85	23.63	23.83	3757947.0
2010-08-27 14:00:00	MSFT	Stock	23.82	23.97	23.74	23.861	6554472.0
2010-08-27 15:00:00	MSFT	Stock	23.86	23.955	23.82	23.93	7386775.0
2010-08-27 16:00:00	MSFT	Stock	23.92	23.98	23.75	23.95	5204182.0
2010-08-27 17:00:00	MSFT	Stock	23.95	23.95	23.93	23.94	117223.0
2010-08-27 18:00:00	MSFT	Stock	23.93	23.98	23.93	23.98	28814.0
2010-08-27 19:00:00	MSFT	Stock	23.98	23.98	23.95	23.95	1400.0
2010-08-27 20:00:00	MSFT	Stock	23.64	23.64	23.64	23.64	1800.0
2010-08-27 08:00:00	NVDA	Stock	0.2488	0.2495	0.2475	0.2475	176000.0
2010-08-27 09:00:00	NVDA	Stock	0.2482	0.2495	0.244	0.2445	75479480.0
2010-08-27 10:00:00	NVDA	Stock	0.2447	0.2545	0.2402	0.2513	353667560.0
2010-08-27 11:00:00	NVDA	Stock	0.2513	0.255	0.2509	0.2538	185420800.0
2010-08-27 12:00:00	NVDA	Stock	0.2538	0.255	0.2518	0.2518	114782040.0
2010-08-27 13:00:00	NVDA	Stock	0.2518	0.2533	0.2507	0.2525	80743560.0
2010-08-27 14:00:00	NVDA	Stock	0.2525	0.2535	0.2513	0.2528	87855640.0
2010-08-27 15:00:00	NVDA	Stock	0.2529	0.2535	0.252	0.2527	149777960.0
2010-08-27 16:00:00	NVDA	Stock	0.2527	0.2533	0.245	0.2525	11431560.0
2010-08-27 17:00:00	NVDA	Stock	0.2527	0.253	0.2503	0.253	776320.0
2010-08-27 18:00:00	NVDA	Stock	0.253	0.253	0.253	0.253	172000.0
2010-08-27 19:00:00	NVDA	Stock	0.253	0.2533	0.253	0.2533	100000.0
2010-08-27 07:00:00	AMZN	Stock	6.2005	6.2005	6.2	6.2	4000.0
2010-08-27 08:00:00	AMZN	Stock	6.243	6.28	6.243	6.28	62000.0
2010-08-27 09:00:00	AMZN	Stock	6.2755	6.286	6.1425	6.15	11910680.0
2010-08-27 10:00:00	AMZN	Stock	6.154	6.232	6.1125	6.2095	25276520.0
2010-08-27 11:00:00	AMZN	Stock	6.2095	6.2995	6.205	6.2695	15835780.0
2010-08-27 12:00:00	AMZN	Stock	6.27	6.279	6.2345	6.2425	6731080.0
2010-08-27 13:00:00	AMZN	Stock	6.243	6.3089	6.2395	6.307	10126840.0
2010-08-27 14:00:00	AMZN	Stock	6.307	6.32	6.277	6.3055	9008160.0
2010-08-27 15:00:00	AMZN	Stock	6.3078	6.332	6.294	6.332	17820620.0
2010-08-27 16:00:00	AMZN	Stock	6.332	6.332	6.2492	6.327	3806300.0

> showing 50 of 44,158 rows — these rows as CSV

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