PREVIEW / stock_1hour / 2010-09-07

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-09-07.parquet
  size:    915 KB
  rows:    44,932
  symbols: 3,466

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-07 04:00:00	AAPL	Stock	9.1782	9.1782	9.1271	9.1714	93800.0
2010-09-07 05:00:00	AAPL	Stock	9.1286	9.1571	9.1286	9.1571	11200.0
2010-09-07 06:00:00	AAPL	Stock	9.1446	9.1661	9.1268	9.1661	159880.0
2010-09-07 07:00:00	AAPL	Stock	9.1714	9.1961	9.1607	9.1929	313768.0
2010-09-07 08:00:00	AAPL	Stock	9.1918	9.2107	9.1721	9.1814	2008104.0
2010-09-07 09:00:00	AAPL	Stock	9.1821	9.2689	9.1518	9.2082	77737604.0
2010-09-07 10:00:00	AAPL	Stock	9.2103	9.2571	9.1875	9.2543	70613844.0
2010-09-07 11:00:00	AAPL	Stock	9.2532	9.2582	9.2282	9.2504	39111268.0
2010-09-07 12:00:00	AAPL	Stock	9.2504	9.2585	9.2143	9.2268	34843788.0
2010-09-07 13:00:00	AAPL	Stock	9.2275	9.25	9.2225	9.2486	28302540.0
2010-09-07 14:00:00	AAPL	Stock	9.2489	9.2571	9.2154	9.2214	29810536.0
2010-09-07 15:00:00	AAPL	Stock	9.2218	9.2271	9.1986	9.2125	51377060.0
2010-09-07 16:00:00	AAPL	Stock	9.2075	9.237	9.1578	9.2093	6430592.0
2010-09-07 17:00:00	AAPL	Stock	9.2071	9.2136	9.2071	9.2136	388360.0
2010-09-07 18:00:00	AAPL	Stock	9.2121	9.2121	9.2071	9.2071	114604.0
2010-09-07 19:00:00	AAPL	Stock	9.2089	9.2196	9.2075	9.2193	160832.0
2010-09-07 07:00:00	MSFT	Stock	24.15	24.22	24.15	24.21	1050.0
2010-09-07 08:00:00	MSFT	Stock	24.2	24.21	24.14	24.18	18203.0
2010-09-07 09:00:00	MSFT	Stock	24.16	24.3	24.07	24.22	4686506.0
2010-09-07 10:00:00	MSFT	Stock	24.22	24.24	24.05	24.082	9103587.0
2010-09-07 11:00:00	MSFT	Stock	24.09	24.11	23.95	23.98	6691410.0
2010-09-07 12:00:00	MSFT	Stock	23.98	24.08	23.95	23.991	6152836.0
2010-09-07 13:00:00	MSFT	Stock	24.0	24.01	23.94	23.98	4866976.0
2010-09-07 14:00:00	MSFT	Stock	23.985	24.04	23.93	23.94	5473533.0
2010-09-07 15:00:00	MSFT	Stock	23.94	24.02	23.92	23.96	11504604.0
2010-09-07 16:00:00	MSFT	Stock	23.96	24.22	23.942	24.0	2029044.0
2010-09-07 17:00:00	MSFT	Stock	24.072	24.072	23.96	23.99	47864.0
2010-09-07 18:00:00	MSFT	Stock	24.0	24.01	23.96	23.98	42476.0
2010-09-07 19:00:00	MSFT	Stock	24.0	24.0	23.98	23.98	1300.0
2010-09-07 07:00:00	NVDA	Stock	0.2475	0.2475	0.2475	0.2475	4000.0
2010-09-07 08:00:00	NVDA	Stock	0.245	0.245	0.2422	0.2425	404480.0
2010-09-07 09:00:00	NVDA	Stock	0.246	0.2555	0.2458	0.2505	178909560.0
2010-09-07 10:00:00	NVDA	Stock	0.2507	0.2531	0.2505	0.2514	178936040.0
2010-09-07 11:00:00	NVDA	Stock	0.2514	0.2518	0.248	0.2488	137083680.0
2010-09-07 12:00:00	NVDA	Stock	0.2488	0.249	0.2478	0.2481	58732240.0
2010-09-07 13:00:00	NVDA	Stock	0.2481	0.2503	0.2468	0.2498	119086640.0
2010-09-07 14:00:00	NVDA	Stock	0.2499	0.2503	0.249	0.2493	69376440.0
2010-09-07 15:00:00	NVDA	Stock	0.2494	0.25	0.2488	0.2495	134790920.0
2010-09-07 16:00:00	NVDA	Stock	0.2495	0.2513	0.249	0.2509	10890640.0
2010-09-07 17:00:00	NVDA	Stock	0.248	0.25	0.248	0.25	1968080.0
2010-09-07 18:00:00	NVDA	Stock	0.25	0.2513	0.25	0.2513	268000.0
2010-09-07 19:00:00	NVDA	Stock	0.2513	0.2513	0.2498	0.2503	236000.0
2010-09-07 04:00:00	AMZN	Stock	6.9	6.9	6.9	6.9	6000.0
2010-09-07 07:00:00	AMZN	Stock	6.9	6.9	6.9	6.9	12000.0
2010-09-07 08:00:00	AMZN	Stock	6.9	6.9	6.8665	6.8725	104920.0
2010-09-07 09:00:00	AMZN	Stock	6.8855	6.93	6.85	6.8675	14942960.0
2010-09-07 10:00:00	AMZN	Stock	6.867	6.9035	6.8445	6.8842	18355420.0
2010-09-07 11:00:00	AMZN	Stock	6.885	6.897	6.8575	6.8945	7000140.0
2010-09-07 12:00:00	AMZN	Stock	6.8945	6.9	6.866	6.882	4467620.0
2010-09-07 13:00:00	AMZN	Stock	6.8825	6.9015	6.8735	6.8935	5793020.0

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

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