PREVIEW / stock_1hour / 2010-09-02

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-09-02.parquet
  size:    905 KB
  rows:    44,558
  symbols: 3,455

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-02 04:00:00	AAPL	Stock	8.9729	8.9729	8.9729	8.9729	5600.0
2010-09-02 07:00:00	AAPL	Stock	8.9643	8.9875	8.9418	8.9554	237300.0
2010-09-02 08:00:00	AAPL	Stock	8.9504	9.0246	8.9468	9.0071	5399352.0
2010-09-02 09:00:00	AAPL	Stock	9.0054	9.0054	8.9054	8.9279	75507236.0
2010-09-02 10:00:00	AAPL	Stock	8.9286	8.9546	8.8775	8.9393	95299092.0
2010-09-02 11:00:00	AAPL	Stock	8.9386	8.9471	8.9129	8.935	35603232.0
2010-09-02 12:00:00	AAPL	Stock	8.9336	8.9529	8.9225	8.9325	37358748.0
2010-09-02 13:00:00	AAPL	Stock	8.9325	8.9454	8.925	8.9446	21791000.0
2010-09-02 14:00:00	AAPL	Stock	8.9446	8.9718	8.9418	8.965	51030140.0
2010-09-02 15:00:00	AAPL	Stock	8.9646	9.0061	8.9582	9.0061	80407488.0
2010-09-02 16:00:00	AAPL	Stock	9.0014	9.0075	8.9433	9.0054	7916328.0
2010-09-02 17:00:00	AAPL	Stock	9.0054	9.0079	9.0036	9.0071	1439368.0
2010-09-02 18:00:00	AAPL	Stock	9.0064	9.0168	9.0061	9.0168	425936.0
2010-09-02 19:00:00	AAPL	Stock	9.0143	9.0168	9.0	9.0057	391580.0
2010-09-02 07:00:00	MSFT	Stock	23.88	23.9	23.88	23.9	1100.0
2010-09-02 08:00:00	MSFT	Stock	23.91	23.99	23.91	23.99	9951.0
2010-09-02 09:00:00	MSFT	Stock	23.99	23.99	23.71	23.88	5453381.0
2010-09-02 10:00:00	MSFT	Stock	23.88	23.95	23.805	23.901	6278086.0
2010-09-02 11:00:00	MSFT	Stock	23.91	23.94	23.86	23.89	5361763.0
2010-09-02 12:00:00	MSFT	Stock	23.895	23.9	23.84	23.864	5322856.0
2010-09-02 13:00:00	MSFT	Stock	23.86	23.92	23.84	23.895	4605197.0
2010-09-02 14:00:00	MSFT	Stock	23.895	23.94	23.88	23.905	5751623.0
2010-09-02 15:00:00	MSFT	Stock	23.91	23.93	23.89	23.92	13176565.0
2010-09-02 16:00:00	MSFT	Stock	23.94	23.95	23.87	23.91	2076385.0
2010-09-02 17:00:00	MSFT	Stock	23.94	23.95	23.93	23.94	116783.0
2010-09-02 18:00:00	MSFT	Stock	23.97	23.97	23.93	23.93	43752.0
2010-09-02 19:00:00	MSFT	Stock	23.92	23.94	23.9	23.9	4756.0
2010-09-02 08:00:00	NVDA	Stock	0.2348	0.2348	0.2345	0.2348	36000.0
2010-09-02 09:00:00	NVDA	Stock	0.236	0.2372	0.2335	0.2355	60338840.0
2010-09-02 10:00:00	NVDA	Stock	0.2358	0.2368	0.2349	0.2368	88542800.0
2010-09-02 11:00:00	NVDA	Stock	0.2368	0.2382	0.2362	0.2372	103289000.0
2010-09-02 12:00:00	NVDA	Stock	0.2375	0.2383	0.2372	0.2372	65787960.0
2010-09-02 13:00:00	NVDA	Stock	0.2372	0.2385	0.2368	0.238	48702360.0
2010-09-02 14:00:00	NVDA	Stock	0.2382	0.239	0.2378	0.2385	52826800.0
2010-09-02 15:00:00	NVDA	Stock	0.2385	0.24	0.2382	0.2395	158605000.0
2010-09-02 16:00:00	NVDA	Stock	0.2392	0.2396	0.2355	0.2395	17160480.0
2010-09-02 17:00:00	NVDA	Stock	0.2392	0.24	0.2392	0.2392	862840.0
2010-09-02 18:00:00	NVDA	Stock	0.2388	0.2388	0.2388	0.2388	28000.0
2010-09-02 07:00:00	AMZN	Stock	6.654	6.6835	6.631	6.6835	8000.0
2010-09-02 08:00:00	AMZN	Stock	6.6255	6.6255	6.6	6.6125	90500.0
2010-09-02 09:00:00	AMZN	Stock	6.6125	6.6885	6.6	6.6765	16967020.0
2010-09-02 10:00:00	AMZN	Stock	6.6795	6.74	6.661	6.7235	21320800.0
2010-09-02 11:00:00	AMZN	Stock	6.725	6.747	6.6905	6.703	12431920.0
2010-09-02 12:00:00	AMZN	Stock	6.7019	6.7085	6.679	6.6915	7442220.0
2010-09-02 13:00:00	AMZN	Stock	6.691	6.702	6.681	6.7005	4985480.0
2010-09-02 14:00:00	AMZN	Stock	6.7005	6.7445	6.698	6.7393	12337060.0
2010-09-02 15:00:00	AMZN	Stock	6.738	6.7605	6.723	6.76	28353500.0
2010-09-02 16:00:00	AMZN	Stock	6.76	6.7609	6.7028	6.757	3422440.0
2010-09-02 17:00:00	AMZN	Stock	6.755	6.7605	6.753	6.753	225880.0
2010-09-02 18:00:00	AMZN	Stock	6.7605	6.7605	6.738	6.738	218020.0

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

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