PREVIEW / stock_1hour / 2007-12-12

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-12-12.parquet
  size:    828 KB
  rows:    40,750
  symbols: 3,245

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
2007-12-12 04:00:00	AAPL	Stock	6.7568	6.7704	6.7568	6.7704	22400.0
2007-12-12 05:00:00	AAPL	Stock	6.7725	6.8	6.7725	6.7929	84000.0
2007-12-12 06:00:00	AAPL	Stock	6.7929	6.8161	6.7929	6.8161	67200.0
2007-12-12 07:00:00	AAPL	Stock	6.8204	6.8557	6.7789	6.8339	1530760.0
2007-12-12 08:00:00	AAPL	Stock	6.8321	6.8411	6.8071	6.8179	10034780.0
2007-12-12 09:00:00	AAPL	Stock	6.8193	6.9457	6.8193	6.9346	197444352.0
2007-12-12 10:00:00	AAPL	Stock	6.9343	6.9441	6.8875	6.8875	157316068.0
2007-12-12 11:00:00	AAPL	Stock	6.8882	6.9207	6.875	6.8927	117640544.0
2007-12-12 12:00:00	AAPL	Stock	6.8936	6.8986	6.7339	6.7921	166682740.0
2007-12-12 13:00:00	AAPL	Stock	6.7921	6.8525	6.7657	6.8318	120214780.0
2007-12-12 14:00:00	AAPL	Stock	6.8318	6.8379	6.7639	6.78	121293200.0
2007-12-12 15:00:00	AAPL	Stock	6.7804	6.9139	6.6343	6.8271	312971204.0
2007-12-12 16:00:00	AAPL	Stock	6.8239	6.8518	6.7218	6.8304	17467716.0
2007-12-12 17:00:00	AAPL	Stock	6.8321	6.8357	6.7429	6.8354	784532.0
2007-12-12 18:00:00	AAPL	Stock	6.8321	6.8354	6.8286	6.8329	457520.0
2007-12-12 19:00:00	AAPL	Stock	6.8304	6.8304	6.8071	6.8179	1661940.0
2007-12-12 07:00:00	MSFT	Stock	34.28	34.32	34.28	34.28	4100.0
2007-12-12 08:00:00	MSFT	Stock	34.2	34.34	34.2	34.29	120408.0
2007-12-12 09:00:00	MSFT	Stock	34.3	34.9	34.1	34.845	7669841.0
2007-12-12 10:00:00	MSFT	Stock	34.845	36.39	34.68	34.81	10103790.0
2007-12-12 11:00:00	MSFT	Stock	34.81	35.0	34.77	34.77	6228499.0
2007-12-12 12:00:00	MSFT	Stock	34.77	34.82	34.46	34.51	5878251.0
2007-12-12 13:00:00	MSFT	Stock	34.51	34.75	34.4	34.73	4236738.0
2007-12-12 14:00:00	MSFT	Stock	34.73	34.76	34.57	34.625	5698044.0
2007-12-12 15:00:00	MSFT	Stock	34.62	34.63	33.93	34.47	17375977.0
2007-12-12 16:00:00	MSFT	Stock	34.48	34.65	34.1	34.48	5030246.0
2007-12-12 17:00:00	MSFT	Stock	34.48	34.627	34.1	34.47	999605.0
2007-12-12 18:00:00	MSFT	Stock	34.55	34.6	34.55	34.6	4149.0
2007-12-12 19:00:00	MSFT	Stock	34.47	34.47	34.47	34.47	3000.0
2007-12-12 08:00:00	NVDA	Stock	0.8575	0.874	0.8575	0.8712	170040.0
2007-12-12 09:00:00	NVDA	Stock	0.8712	0.9023	0.8712	0.8922	89274160.0
2007-12-12 10:00:00	NVDA	Stock	0.8928	0.902	0.8875	0.889	89735360.0
2007-12-12 11:00:00	NVDA	Stock	0.8888	0.8955	0.8822	0.895	55496400.0
2007-12-12 12:00:00	NVDA	Stock	0.895	0.899	0.889	0.89	65383840.0
2007-12-12 13:00:00	NVDA	Stock	0.8901	0.895	0.8852	0.892	44886720.0
2007-12-12 14:00:00	NVDA	Stock	0.892	0.895	0.8835	0.8838	54594560.0
2007-12-12 15:00:00	NVDA	Stock	0.8838	0.887	0.8695	0.8855	134739280.0
2007-12-12 16:00:00	NVDA	Stock	0.8868	0.895	0.8568	0.8868	78991760.0
2007-12-12 17:00:00	NVDA	Stock	0.882	0.8876	0.882	0.8876	3978840.0
2007-12-12 18:00:00	NVDA	Stock	0.885	0.885	0.8812	0.8812	356000.0
2007-12-12 19:00:00	NVDA	Stock	0.8863	0.8863	0.8863	0.8863	4000.0
2007-12-12 06:00:00	AMZN	Stock	4.545	4.545	4.545	4.545	2400.0
2007-12-12 08:00:00	AMZN	Stock	4.5925	4.6	4.5875	4.59	185800.0
2007-12-12 09:00:00	AMZN	Stock	4.598	4.66	4.598	4.6425	18589600.0
2007-12-12 10:00:00	AMZN	Stock	4.642	4.6875	4.6215	4.6345	21093300.0
2007-12-12 11:00:00	AMZN	Stock	4.6336	4.6775	4.6336	4.662	11325200.0
2007-12-12 12:00:00	AMZN	Stock	4.6625	4.6635	4.574	4.599	14852080.0
2007-12-12 13:00:00	AMZN	Stock	4.5985	4.609	4.564	4.5845	16147460.0
2007-12-12 14:00:00	AMZN	Stock	4.5855	4.599	4.55	4.5568	11901820.0
2007-12-12 15:00:00	AMZN	Stock	4.5555	4.565	4.466	4.5645	40398540.0

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

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