PREVIEW / stock_1hour / 2009-05-27

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-05-27.parquet
  size:    840 KB
  rows:    41,172
  symbols: 3,348

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-05-27 05:00:00	AAPL	Stock	4.7236	4.7236	4.7236	4.7236	2800.0
2009-05-27 07:00:00	AAPL	Stock	4.7186	4.7186	4.6804	4.6893	530600.0
2009-05-27 08:00:00	AAPL	Stock	4.6929	4.7029	4.6782	4.6904	2003456.0
2009-05-27 09:00:00	AAPL	Stock	4.69	4.7561	4.6754	4.7375	111121948.0
2009-05-27 10:00:00	AAPL	Stock	4.7375	4.8207	4.7232	4.8171	150163328.0
2009-05-27 11:00:00	AAPL	Stock	4.8171	4.8173	4.7864	4.8011	67421676.0
2009-05-27 12:00:00	AAPL	Stock	4.8014	4.8143	4.7929	4.7982	53962916.0
2009-05-27 13:00:00	AAPL	Stock	4.7982	4.8054	4.7429	4.7561	70141848.0
2009-05-27 14:00:00	AAPL	Stock	4.7561	4.7779	4.7389	4.7611	68633992.0
2009-05-27 15:00:00	AAPL	Stock	4.7614	4.7764	4.7296	4.7486	103825792.0
2009-05-27 16:00:00	AAPL	Stock	4.7507	4.7764	4.7429	4.7539	14976948.0
2009-05-27 17:00:00	AAPL	Stock	4.7514	4.7618	4.7496	4.7611	374360.0
2009-05-27 18:00:00	AAPL	Stock	4.7571	4.7571	4.7429	4.7429	344008.0
2009-05-27 19:00:00	AAPL	Stock	4.7429	4.7482	4.7375	4.7464	239512.0
2009-05-27 08:00:00	MSFT	Stock	20.34	20.34	20.3	20.3	2421.0
2009-05-27 09:00:00	MSFT	Stock	20.27	20.55	20.24	20.46	3130715.0
2009-05-27 10:00:00	MSFT	Stock	20.46	20.59	20.31	20.582	6013417.0
2009-05-27 11:00:00	MSFT	Stock	20.58	20.6	20.44	20.469	4402240.0
2009-05-27 12:00:00	MSFT	Stock	20.47	20.57	20.41	20.442	4382874.0
2009-05-27 13:00:00	MSFT	Stock	20.45	20.51	20.21	20.3	4246684.0
2009-05-27 14:00:00	MSFT	Stock	20.3	20.46	20.09	20.28	6090692.0
2009-05-27 15:00:00	MSFT	Stock	20.29	20.37	20.07	20.11	10104913.0
2009-05-27 16:00:00	MSFT	Stock	20.1	20.512	20.07	20.512	3918750.0
2009-05-27 17:00:00	MSFT	Stock	20.23	20.525	20.18	20.18	2540.0
2009-05-27 18:00:00	MSFT	Stock	20.18	20.21	20.18	20.21	3770.0
2009-05-27 19:00:00	MSFT	Stock	20.19	20.22	20.18	20.22	1785.0
2009-05-27 08:00:00	NVDA	Stock	0.2588	0.2588	0.255	0.255	80000.0
2009-05-27 09:00:00	NVDA	Stock	0.2575	0.2621	0.255	0.2612	78778560.0
2009-05-27 10:00:00	NVDA	Stock	0.2612	0.265	0.2585	0.2623	194115000.0
2009-05-27 11:00:00	NVDA	Stock	0.262	0.2645	0.2604	0.2638	109656000.0
2009-05-27 12:00:00	NVDA	Stock	0.2638	0.2663	0.2634	0.2635	83587600.0
2009-05-27 13:00:00	NVDA	Stock	0.2635	0.267	0.2603	0.2623	92015360.0
2009-05-27 14:00:00	NVDA	Stock	0.2623	0.265	0.2608	0.2625	89680320.0
2009-05-27 15:00:00	NVDA	Stock	0.2625	0.2638	0.2588	0.2595	147726840.0
2009-05-27 16:00:00	NVDA	Stock	0.2595	0.2626	0.2588	0.2592	15097280.0
2009-05-27 17:00:00	NVDA	Stock	0.2592	0.2592	0.2565	0.2565	206680.0
2009-05-27 18:00:00	NVDA	Stock	0.2583	0.2583	0.2583	0.2583	8000.0
2009-05-27 19:00:00	NVDA	Stock	0.2585	0.2588	0.2585	0.2588	60000.0
2009-05-27 07:00:00	AMZN	Stock	3.96	3.96	3.96	3.96	2000.0
2009-05-27 08:00:00	AMZN	Stock	3.95	3.95	3.925	3.935	59480.0
2009-05-27 09:00:00	AMZN	Stock	3.9275	3.95	3.86	3.925	14141020.0
2009-05-27 10:00:00	AMZN	Stock	3.927	3.964	3.914	3.9628	18008180.0
2009-05-27 11:00:00	AMZN	Stock	3.9608	3.964	3.9335	3.9535	11636380.0
2009-05-27 12:00:00	AMZN	Stock	3.954	3.975	3.92	3.9255	13819960.0
2009-05-27 13:00:00	AMZN	Stock	3.925	3.938	3.862	3.878	12734900.0
2009-05-27 14:00:00	AMZN	Stock	3.8778	3.893	3.855	3.8705	12909300.0
2009-05-27 15:00:00	AMZN	Stock	3.871	3.8835	3.8375	3.853	23750780.0
2009-05-27 16:00:00	AMZN	Stock	3.855	3.9059	3.8486	3.854	1513920.0
2009-05-27 17:00:00	AMZN	Stock	3.854	3.8665	3.851	3.8665	30920.0
2009-05-27 18:00:00	AMZN	Stock	3.865	3.867	3.865	3.867	18000.0

> showing 50 of 41,172 rows — these rows as CSV

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