PREVIEW / stock_1hour / 2010-05-26

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-05-26.parquet
  size:    938 KB
  rows:    44,631
  symbols: 3,468

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-05-26 04:00:00	AAPL	Stock	8.8839	8.8839	8.8571	8.8746	18200.0
2010-05-26 05:00:00	AAPL	Stock	8.8839	8.8929	8.8839	8.8929	19852.0
2010-05-26 06:00:00	AAPL	Stock	8.8839	8.8839	8.8554	8.8661	121520.0
2010-05-26 07:00:00	AAPL	Stock	8.87	8.9018	8.8675	8.8929	1183896.0
2010-05-26 08:00:00	AAPL	Stock	8.8679	8.9482	8.8679	8.9146	10012436.0
2010-05-26 09:00:00	AAPL	Stock	8.9136	8.9921	8.8946	8.9754	135079112.0
2010-05-26 10:00:00	AAPL	Stock	8.9768	9.0046	8.9514	8.9557	122946096.0
2010-05-26 11:00:00	AAPL	Stock	8.9564	8.9929	8.8714	8.9193	111692196.0
2010-05-26 12:00:00	AAPL	Stock	8.9196	8.9457	8.8929	8.9425	61357296.0
2010-05-26 13:00:00	AAPL	Stock	8.945	8.9586	8.9071	8.9354	53555628.0
2010-05-26 14:00:00	AAPL	Stock	8.9354	8.9736	8.8211	8.8693	101608612.0
2010-05-26 15:00:00	AAPL	Stock	8.8682	8.8843	8.7054	8.7182	214185216.0
2010-05-26 16:00:00	AAPL	Stock	8.7179	8.8913	8.6714	8.6964	24635044.0
2010-05-26 17:00:00	AAPL	Stock	8.6964	8.9086	8.6714	8.6782	1629544.0
2010-05-26 18:00:00	AAPL	Stock	8.675	8.7182	8.6732	8.6821	340284.0
2010-05-26 19:00:00	AAPL	Stock	8.6821	8.7082	8.6732	8.7082	446964.0
2010-05-26 20:00:00	AAPL	Stock	8.7593	8.9043	8.7593	8.9043	254800.0
2010-05-26 07:00:00	MSFT	Stock	26.34	26.34	26.24	26.29	4800.0
2010-05-26 08:00:00	MSFT	Stock	26.26	26.4	26.116	26.35	86493.0
2010-05-26 09:00:00	MSFT	Stock	26.35	26.45	26.05	26.33	11305682.0
2010-05-26 10:00:00	MSFT	Stock	26.33	26.605	26.28	26.32	12738174.0
2010-05-26 11:00:00	MSFT	Stock	26.32	26.32	25.9	26.049	12900441.0
2010-05-26 12:00:00	MSFT	Stock	26.045	26.1	25.92	26.04	9752122.0
2010-05-26 13:00:00	MSFT	Stock	26.04	26.12	26.0	26.05	7304874.0
2010-05-26 14:00:00	MSFT	Stock	26.045	26.07	25.28	25.49	21517511.0
2010-05-26 15:00:00	MSFT	Stock	25.49	25.52	24.56	25.01	89283848.0
2010-05-26 16:00:00	MSFT	Stock	25.0	26.516	24.743	25.08	7825900.0
2010-05-26 17:00:00	MSFT	Stock	25.08	25.08	24.99	25.03	144510.0
2010-05-26 18:00:00	MSFT	Stock	25.01	25.05	24.98	24.99	179940.0
2010-05-26 19:00:00	MSFT	Stock	24.99	25.02	24.94	25.02	15790.0
2010-05-26 20:00:00	MSFT	Stock	26.11	26.11	26.11	26.11	56070.0
2010-05-26 07:00:00	NVDA	Stock	0.327	0.3285	0.325	0.3278	389600.0
2010-05-26 08:00:00	NVDA	Stock	0.3285	0.3333	0.327	0.3305	12632320.0
2010-05-26 09:00:00	NVDA	Stock	0.3305	0.3362	0.3258	0.332	213709680.0
2010-05-26 10:00:00	NVDA	Stock	0.332	0.3336	0.3265	0.3278	165866080.0
2010-05-26 11:00:00	NVDA	Stock	0.3275	0.3285	0.3248	0.3285	153156160.0
2010-05-26 12:00:00	NVDA	Stock	0.3285	0.3293	0.3254	0.3275	60606400.0
2010-05-26 13:00:00	NVDA	Stock	0.3275	0.3305	0.3273	0.3291	62257000.0
2010-05-26 14:00:00	NVDA	Stock	0.329	0.3298	0.3223	0.3245	116238160.0
2010-05-26 15:00:00	NVDA	Stock	0.3243	0.3253	0.3178	0.3188	196787200.0
2010-05-26 16:00:00	NVDA	Stock	0.3188	0.3272	0.3145	0.318	3572680.0
2010-05-26 17:00:00	NVDA	Stock	0.3173	0.3225	0.3173	0.3225	229000.0
2010-05-26 18:00:00	NVDA	Stock	0.322	0.322	0.322	0.322	4000.0
2010-05-26 19:00:00	NVDA	Stock	0.322	0.322	0.322	0.322	32000.0
2010-05-26 08:00:00	AMZN	Stock	6.3	6.305	6.2319	6.2625	330980.0
2010-05-26 09:00:00	AMZN	Stock	6.268	6.2925	6.1895	6.2575	20491160.0
2010-05-26 10:00:00	AMZN	Stock	6.2545	6.2895	6.201	6.211	18792820.0
2010-05-26 11:00:00	AMZN	Stock	6.21	6.2425	6.1565	6.206	18393020.0
2010-05-26 12:00:00	AMZN	Stock	6.207	6.249	6.198	6.2435	11258180.0
2010-05-26 13:00:00	AMZN	Stock	6.245	6.2755	6.2315	6.2575	11198600.0

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

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