PREVIEW / stock_1hour / 2010-08-26

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-08-26.parquet
  size:    903 KB
  rows:    44,357
  symbols: 3,467

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-26 04:00:00	AAPL	Stock	8.7096	8.75	8.7096	8.75	9100.0
2010-08-26 05:00:00	AAPL	Stock	8.7143	8.7143	8.7143	8.7143	2800.0
2010-08-26 06:00:00	AAPL	Stock	8.7339	8.7371	8.7143	8.7143	47600.0
2010-08-26 07:00:00	AAPL	Stock	8.7286	8.7286	8.6943	8.6975	332500.0
2010-08-26 08:00:00	AAPL	Stock	8.7018	8.7564	8.6625	8.7532	5880448.0
2010-08-26 09:00:00	AAPL	Stock	8.7507	8.7679	8.7007	8.7375	77245196.0
2010-08-26 10:00:00	AAPL	Stock	8.7357	8.7768	8.7286	8.7411	85113112.0
2010-08-26 11:00:00	AAPL	Stock	8.7427	8.7457	8.6582	8.6893	69395956.0
2010-08-26 12:00:00	AAPL	Stock	8.6875	8.7071	8.6657	8.6846	29422680.0
2010-08-26 13:00:00	AAPL	Stock	8.6841	8.6911	8.6475	8.648	33145000.0
2010-08-26 14:00:00	AAPL	Stock	8.6475	8.6578	8.5943	8.6011	62453720.0
2010-08-26 15:00:00	AAPL	Stock	8.6014	8.6339	8.5814	8.5818	74504472.0
2010-08-26 16:00:00	AAPL	Stock	8.5814	8.7601	8.5757	8.5875	20944364.0
2010-08-26 17:00:00	AAPL	Stock	8.5875	8.5893	8.5679	8.5686	1062124.0
2010-08-26 18:00:00	AAPL	Stock	8.5682	8.5814	8.5357	8.5671	557872.0
2010-08-26 19:00:00	AAPL	Stock	8.5696	8.5732	8.5661	8.5732	239484.0
2010-08-26 07:00:00	MSFT	Stock	24.21	24.21	24.21	24.21	500.0
2010-08-26 08:00:00	MSFT	Stock	24.17	24.27	24.0	24.23	49000.0
2010-08-26 09:00:00	MSFT	Stock	24.21	24.22	24.03	24.14	4283992.0
2010-08-26 10:00:00	MSFT	Stock	24.14	24.19	24.05	24.07	5310048.0
2010-08-26 11:00:00	MSFT	Stock	24.08	24.09	23.92	24.02	7140138.0
2010-08-26 12:00:00	MSFT	Stock	24.022	24.04	23.91	23.955	3594733.0
2010-08-26 13:00:00	MSFT	Stock	23.96	23.97	23.9	23.92	4439605.0
2010-08-26 14:00:00	MSFT	Stock	23.92	23.94	23.79	23.795	6574377.0
2010-08-26 15:00:00	MSFT	Stock	23.795	23.99	23.79	23.81	9686981.0
2010-08-26 16:00:00	MSFT	Stock	23.83	23.98	23.76	23.77	7010521.0
2010-08-26 17:00:00	MSFT	Stock	23.77	24.0	23.76	23.78	34510.0
2010-08-26 18:00:00	MSFT	Stock	23.84	23.84	23.82	23.82	14979.0
2010-08-26 19:00:00	MSFT	Stock	23.78	23.78	23.78	23.78	355.0
2010-08-26 07:00:00	NVDA	Stock	0.248	0.248	0.248	0.248	4000.0
2010-08-26 08:00:00	NVDA	Stock	0.25	0.2525	0.25	0.2525	387960.0
2010-08-26 09:00:00	NVDA	Stock	0.252	0.253	0.2488	0.25	94874920.0
2010-08-26 10:00:00	NVDA	Stock	0.25	0.254	0.249	0.253	149085480.0
2010-08-26 11:00:00	NVDA	Stock	0.253	0.2533	0.2488	0.2503	78545480.0
2010-08-26 12:00:00	NVDA	Stock	0.2503	0.2503	0.2468	0.2478	45947520.0
2010-08-26 13:00:00	NVDA	Stock	0.2478	0.2482	0.2468	0.2478	59898600.0
2010-08-26 14:00:00	NVDA	Stock	0.2479	0.2482	0.245	0.2453	75510640.0
2010-08-26 15:00:00	NVDA	Stock	0.2453	0.2473	0.245	0.245	127364560.0
2010-08-26 16:00:00	NVDA	Stock	0.2448	0.2491	0.2435	0.245	6465280.0
2010-08-26 17:00:00	NVDA	Stock	0.2445	0.245	0.2442	0.2445	296720.0
2010-08-26 18:00:00	NVDA	Stock	0.2445	0.2445	0.2445	0.2445	18000.0
2010-08-26 19:00:00	NVDA	Stock	0.2445	0.2445	0.244	0.244	348560.0
2010-08-26 08:00:00	AMZN	Stock	6.305	6.3735	6.3045	6.357	121280.0
2010-08-26 09:00:00	AMZN	Stock	6.363	6.3795	6.3135	6.345	14365980.0
2010-08-26 10:00:00	AMZN	Stock	6.343	6.356	6.2915	6.3015	16242700.0
2010-08-26 11:00:00	AMZN	Stock	6.3015	6.3375	6.275	6.323	13929300.0
2010-08-26 12:00:00	AMZN	Stock	6.3215	6.3225	6.2825	6.2985	7559120.0
2010-08-26 13:00:00	AMZN	Stock	6.2995	6.3095	6.276	6.278	5821440.0
2010-08-26 14:00:00	AMZN	Stock	6.277	6.282	6.241	6.2505	11907260.0
2010-08-26 15:00:00	AMZN	Stock	6.2495	6.285	6.243	6.243	19023040.0

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

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