PREVIEW / stock_1hour / 2010-08-17

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-08-17.parquet
  size:    911 KB
  rows:    44,624
  symbols: 3,472

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-17 05:00:00	AAPL	Stock	8.9261	8.9261	8.9261	8.9261	5684.0
2010-08-17 07:00:00	AAPL	Stock	8.8964	8.9132	8.8929	8.9132	47768.0
2010-08-17 08:00:00	AAPL	Stock	8.9039	8.9407	8.8911	8.9311	2185176.0
2010-08-17 09:00:00	AAPL	Stock	8.9286	8.9739	8.9	8.9691	62375964.0
2010-08-17 10:00:00	AAPL	Stock	8.9689	8.9993	8.9471	8.9946	80634176.0
2010-08-17 11:00:00	AAPL	Stock	8.9943	9.0411	8.9921	9.0389	59993948.0
2010-08-17 12:00:00	AAPL	Stock	9.0396	9.0621	9.0286	9.0579	42639772.0
2010-08-17 13:00:00	AAPL	Stock	9.0585	9.0939	9.0557	9.0582	46631256.0
2010-08-17 14:00:00	AAPL	Stock	9.0582	9.0721	9.0321	9.0448	38912412.0
2010-08-17 15:00:00	AAPL	Stock	9.045	9.0461	8.9914	9.0043	72536856.0
2010-08-17 16:00:00	AAPL	Stock	8.9939	9.0489	8.9864	8.9946	12694304.0
2010-08-17 17:00:00	AAPL	Stock	8.9921	8.9982	8.9921	8.9964	69608.0
2010-08-17 18:00:00	AAPL	Stock	8.9989	9.0	8.9964	8.9996	220332.0
2010-08-17 19:00:00	AAPL	Stock	8.9989	9.0107	8.9971	9.0068	178332.0
2010-08-17 07:00:00	MSFT	Stock	24.68	24.68	24.65	24.68	6246.0
2010-08-17 08:00:00	MSFT	Stock	24.67	24.72	24.65	24.7	45815.0
2010-08-17 09:00:00	MSFT	Stock	24.72	24.805	24.6	24.73	7425902.0
2010-08-17 10:00:00	MSFT	Stock	24.74	24.82	24.656	24.8	7350224.0
2010-08-17 11:00:00	MSFT	Stock	24.8	24.9	24.77	24.844	7374116.0
2010-08-17 12:00:00	MSFT	Stock	24.85	24.85	24.67	24.67	5848757.0
2010-08-17 13:00:00	MSFT	Stock	24.675	24.9	24.67	24.81	4852406.0
2010-08-17 14:00:00	MSFT	Stock	24.81	24.96	24.81	24.875	5932699.0
2010-08-17 15:00:00	MSFT	Stock	24.88	24.92	24.71	24.71	10670586.0
2010-08-17 16:00:00	MSFT	Stock	24.71	24.86	24.37	24.72	2474063.0
2010-08-17 17:00:00	MSFT	Stock	24.71	24.85	24.71	24.79	78218.0
2010-08-17 18:00:00	MSFT	Stock	24.8	24.82	24.71	24.8	31896.0
2010-08-17 19:00:00	MSFT	Stock	24.8	24.81	24.76	24.76	10853.0
2010-08-17 07:00:00	NVDA	Stock	0.2312	0.2345	0.2312	0.2345	41960.0
2010-08-17 08:00:00	NVDA	Stock	0.2312	0.2312	0.225	0.2308	913440.0
2010-08-17 09:00:00	NVDA	Stock	0.2305	0.233	0.2288	0.2318	55981720.0
2010-08-17 10:00:00	NVDA	Stock	0.2318	0.2338	0.2312	0.2338	84206200.0
2010-08-17 11:00:00	NVDA	Stock	0.2338	0.2345	0.233	0.2332	47299240.0
2010-08-17 12:00:00	NVDA	Stock	0.2332	0.235	0.2322	0.2345	59786200.0
2010-08-17 13:00:00	NVDA	Stock	0.2345	0.236	0.2338	0.2348	62166200.0
2010-08-17 14:00:00	NVDA	Stock	0.2345	0.2348	0.2335	0.2342	50144720.0
2010-08-17 15:00:00	NVDA	Stock	0.2342	0.2345	0.2315	0.2315	102060640.0
2010-08-17 16:00:00	NVDA	Stock	0.2318	0.2338	0.231	0.2335	7841440.0
2010-08-17 17:00:00	NVDA	Stock	0.2315	0.2325	0.2315	0.2318	335160.0
2010-08-17 18:00:00	NVDA	Stock	0.232	0.232	0.232	0.232	11200.0
2010-08-17 19:00:00	NVDA	Stock	0.2318	0.2325	0.231	0.2315	216800.0
2010-08-17 07:00:00	AMZN	Stock	6.37	6.37	6.366	6.3665	11400.0
2010-08-17 08:00:00	AMZN	Stock	6.3725	6.3725	6.35	6.35	33140.0
2010-08-17 09:00:00	AMZN	Stock	6.3515	6.3895	6.329	6.3675	9547840.0
2010-08-17 10:00:00	AMZN	Stock	6.368	6.427	6.368	6.416	13268060.0
2010-08-17 11:00:00	AMZN	Stock	6.4175	6.489	6.4145	6.4835	20872500.0
2010-08-17 12:00:00	AMZN	Stock	6.483	6.494	6.467	6.49	9044900.0
2010-08-17 13:00:00	AMZN	Stock	6.489	6.499	6.489	6.4925	13110180.0
2010-08-17 14:00:00	AMZN	Stock	6.4925	6.495	6.4815	6.484	10665400.0
2010-08-17 15:00:00	AMZN	Stock	6.4835	6.4845	6.4355	6.444	20405120.0
2010-08-17 16:00:00	AMZN	Stock	6.444	6.4819	6.3035	6.4638	3338260.0

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

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