PREVIEW / stock_1hour / 2011-01-11

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-01-11.parquet
  size:    955 KB
  rows:    45,610
  symbols: 3,509

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
2011-01-11 04:00:00	AAPL	Stock	12.3014	12.3107	12.3014	12.3107	39200.0
2011-01-11 05:00:00	AAPL	Stock	12.3146	12.3146	12.3004	12.3139	16800.0
2011-01-11 06:00:00	AAPL	Stock	12.3036	12.3389	12.3036	12.3389	191800.0
2011-01-11 07:00:00	AAPL	Stock	12.3171	12.3389	12.2893	12.3018	777196.0
2011-01-11 08:00:00	AAPL	Stock	12.2989	12.3089	12.2743	12.3	4533928.0
2011-01-11 09:00:00	AAPL	Stock	12.2996	12.32	12.1911	12.2007	91552132.0
2011-01-11 10:00:00	AAPL	Stock	12.2004	12.2446	12.1911	12.2254	66535616.0
2011-01-11 11:00:00	AAPL	Stock	12.2236	12.2586	12.1782	12.2004	89498948.0
2011-01-11 12:00:00	AAPL	Stock	12.2002	12.2139	12.185	12.2011	29109052.0
2011-01-11 13:00:00	AAPL	Stock	12.2007	12.2025	12.1471	12.1532	44836988.0
2011-01-11 14:00:00	AAPL	Stock	12.1514	12.185	12.1239	12.1821	51892148.0
2011-01-11 15:00:00	AAPL	Stock	12.1818	12.2011	12.1696	12.2	43938076.0
2011-01-11 16:00:00	AAPL	Stock	12.2014	12.2082	12.1825	12.2061	8827532.0
2011-01-11 17:00:00	AAPL	Stock	12.2064	12.2139	12.2064	12.2068	1123920.0
2011-01-11 18:00:00	AAPL	Stock	12.2089	12.2114	12.2	12.2043	772744.0
2011-01-11 19:00:00	AAPL	Stock	12.2043	12.205	12.2004	12.2011	599928.0
2011-01-11 06:00:00	MSFT	Stock	28.3	28.3	28.3	28.3	100.0
2011-01-11 07:00:00	MSFT	Stock	28.36	28.4	28.33	28.33	2200.0
2011-01-11 08:00:00	MSFT	Stock	28.33	28.36	28.3	28.35	17674.0
2011-01-11 09:00:00	MSFT	Stock	28.33	28.4	28.05	28.07	6636537.0
2011-01-11 10:00:00	MSFT	Stock	28.062	28.19	28.06	28.15	6573342.0
2011-01-11 11:00:00	MSFT	Stock	28.15	28.2	28.11	28.11	7106023.0
2011-01-11 12:00:00	MSFT	Stock	28.11	28.18	28.11	28.18	3365771.0
2011-01-11 13:00:00	MSFT	Stock	28.18	28.21	28.07	28.12	6402799.0
2011-01-11 14:00:00	MSFT	Stock	28.12	28.24	28.08	28.21	4096629.0
2011-01-11 15:00:00	MSFT	Stock	28.21	28.25	28.11	28.11	10869446.0
2011-01-11 16:00:00	MSFT	Stock	28.12	28.23	28.08	28.08	1557921.0
2011-01-11 17:00:00	MSFT	Stock	28.16	28.16	28.08	28.08	18462.0
2011-01-11 18:00:00	MSFT	Stock	28.11	28.11	28.08	28.1	7696.0
2011-01-11 19:00:00	MSFT	Stock	28.09	28.12	28.08	28.12	1840.0
2011-01-11 04:00:00	NVDA	Stock	0.55	0.55	0.5475	0.5475	54000.0
2011-01-11 05:00:00	NVDA	Stock	0.544	0.544	0.544	0.544	37240.0
2011-01-11 06:00:00	NVDA	Stock	0.5412	0.5412	0.53	0.536	380200.0
2011-01-11 07:00:00	NVDA	Stock	0.535	0.535	0.525	0.5282	6907000.0
2011-01-11 08:00:00	NVDA	Stock	0.5287	0.5325	0.5235	0.5268	37277360.0
2011-01-11 09:00:00	NVDA	Stock	0.5272	0.5312	0.5082	0.5138	605399240.0
2011-01-11 10:00:00	NVDA	Stock	0.514	0.5173	0.4968	0.504	620209240.0
2011-01-11 11:00:00	NVDA	Stock	0.5043	0.5098	0.503	0.5066	244219680.0
2011-01-11 12:00:00	NVDA	Stock	0.5068	0.5138	0.506	0.513	175612360.0
2011-01-11 13:00:00	NVDA	Stock	0.513	0.5205	0.5108	0.5158	306105320.0
2011-01-11 14:00:00	NVDA	Stock	0.5162	0.5235	0.514	0.5165	301662840.0
2011-01-11 15:00:00	NVDA	Stock	0.5168	0.5188	0.5055	0.5075	384987880.0
2011-01-11 16:00:00	NVDA	Stock	0.5078	0.5118	0.5072	0.508	18606920.0
2011-01-11 17:00:00	NVDA	Stock	0.508	0.5082	0.5078	0.5082	163520.0
2011-01-11 18:00:00	NVDA	Stock	0.5088	0.5088	0.5078	0.5085	284200.0
2011-01-11 19:00:00	NVDA	Stock	0.5082	0.5082	0.5072	0.5075	98000.0
2011-01-11 05:00:00	AMZN	Stock	9.264	9.264	9.264	9.264	4000.0
2011-01-11 07:00:00	AMZN	Stock	9.256	9.3165	9.256	9.2795	24000.0
2011-01-11 08:00:00	AMZN	Stock	9.2795	9.2795	9.259	9.275	76920.0
2011-01-11 09:00:00	AMZN	Stock	9.2735	9.3	9.2	9.2051	8434520.0

> showing 50 of 45,610 rows — these rows as CSV

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