PREVIEW / stock_1hour / 2009-10-02

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-10-02.parquet
  size:    887 KB
  rows:    42,642
  symbols: 3,385

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
2009-10-02 04:00:00	AAPL	Stock	6.535	6.535	6.535	6.535	2800.0
2009-10-02 05:00:00	AAPL	Stock	6.5107	6.5146	6.5107	6.5125	167720.0
2009-10-02 06:00:00	AAPL	Stock	6.5114	6.5268	6.5114	6.5179	145600.0
2009-10-02 07:00:00	AAPL	Stock	6.5304	6.5325	6.5	6.5268	1102444.0
2009-10-02 08:00:00	AAPL	Stock	6.5232	6.5261	6.4421	6.4479	13643532.0
2009-10-02 09:00:00	AAPL	Stock	6.4429	6.5625	6.4429	6.5402	111740048.0
2009-10-02 10:00:00	AAPL	Stock	6.5404	6.625	6.5321	6.6036	132907684.0
2009-10-02 11:00:00	AAPL	Stock	6.6032	6.6125	6.5879	6.6004	56178836.0
2009-10-02 12:00:00	AAPL	Stock	6.5996	6.6386	6.5971	6.6157	58206876.0
2009-10-02 13:00:00	AAPL	Stock	6.6146	6.625	6.6054	6.6161	33378408.0
2009-10-02 14:00:00	AAPL	Stock	6.6161	6.6375	6.6043	6.6329	41128864.0
2009-10-02 15:00:00	AAPL	Stock	6.6339	6.6407	6.6021	6.6036	72710960.0
2009-10-02 16:00:00	AAPL	Stock	6.6036	6.622	6.5904	6.6143	29189580.0
2009-10-02 17:00:00	AAPL	Stock	6.6161	6.6225	6.6146	6.6214	122220.0
2009-10-02 18:00:00	AAPL	Stock	6.6036	6.6179	6.6036	6.6132	600628.0
2009-10-02 19:00:00	AAPL	Stock	6.6114	6.6139	6.6071	6.6139	93268.0
2009-10-02 08:00:00	MSFT	Stock	24.89	24.89	24.55	24.57	60537.0
2009-10-02 09:00:00	MSFT	Stock	24.56	24.88	24.38	24.71	8739420.0
2009-10-02 10:00:00	MSFT	Stock	24.71	24.88	24.65	24.76	8225044.0
2009-10-02 11:00:00	MSFT	Stock	24.76	24.862	24.71	24.85	6283905.0
2009-10-02 12:00:00	MSFT	Stock	24.86	24.92	24.79	24.88	4550374.0
2009-10-02 13:00:00	MSFT	Stock	24.876	24.95	24.86	24.92	3469531.0
2009-10-02 14:00:00	MSFT	Stock	24.92	25.07	24.85	25.02	4812613.0
2009-10-02 15:00:00	MSFT	Stock	25.02	25.09	24.92	24.95	11416760.0
2009-10-02 16:00:00	MSFT	Stock	24.95	25.06	24.856	25.0	1849972.0
2009-10-02 17:00:00	MSFT	Stock	25.05	25.05	25.04	25.04	2970.0
2009-10-02 18:00:00	MSFT	Stock	24.96	25.04	24.96	25.04	9978.0
2009-10-02 19:00:00	MSFT	Stock	25.05	25.09	25.05	25.09	530.0
2009-10-02 04:00:00	NVDA	Stock	0.3575	0.3575	0.3575	0.3575	12000.0
2009-10-02 08:00:00	NVDA	Stock	0.3493	0.3558	0.343	0.3442	1286080.0
2009-10-02 09:00:00	NVDA	Stock	0.3442	0.3513	0.3435	0.3502	97639440.0
2009-10-02 10:00:00	NVDA	Stock	0.3502	0.3538	0.3458	0.3462	124566200.0
2009-10-02 11:00:00	NVDA	Stock	0.3462	0.3535	0.3435	0.3438	80547640.0
2009-10-02 12:00:00	NVDA	Stock	0.3435	0.3488	0.3435	0.3473	57387320.0
2009-10-02 13:00:00	NVDA	Stock	0.3473	0.349	0.3468	0.3478	43376200.0
2009-10-02 14:00:00	NVDA	Stock	0.3478	0.3482	0.346	0.347	50759800.0
2009-10-02 15:00:00	NVDA	Stock	0.347	0.3486	0.3455	0.3462	114925760.0
2009-10-02 16:00:00	NVDA	Stock	0.3462	0.3495	0.346	0.3495	14222280.0
2009-10-02 17:00:00	NVDA	Stock	0.3495	0.3495	0.3465	0.3465	40000.0
2009-10-02 08:00:00	AMZN	Stock	4.5325	4.55	4.4935	4.4995	189200.0
2009-10-02 09:00:00	AMZN	Stock	4.4905	4.557	4.487	4.503	15683440.0
2009-10-02 10:00:00	AMZN	Stock	4.503	4.553	4.5	4.5085	18332660.0
2009-10-02 11:00:00	AMZN	Stock	4.5095	4.527	4.5075	4.5109	11128720.0
2009-10-02 12:00:00	AMZN	Stock	4.5125	4.5385	4.5095	4.5135	8702800.0
2009-10-02 13:00:00	AMZN	Stock	4.514	4.542	4.5115	4.517	8415720.0
2009-10-02 14:00:00	AMZN	Stock	4.515	4.522	4.504	4.5125	14570620.0
2009-10-02 15:00:00	AMZN	Stock	4.513	4.5185	4.479	4.4945	19408560.0
2009-10-02 16:00:00	AMZN	Stock	4.493	4.5164	4.49	4.493	656500.0
2009-10-02 17:00:00	AMZN	Stock	4.4925	4.4935	4.4895	4.492	32640.0
2009-10-02 18:00:00	AMZN	Stock	4.4925	4.4925	4.4925	4.4925	98720.0

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

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