PREVIEW / stock_1hour / 2012-01-12

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-01-12.parquet
  size:    931 KB
  rows:    44,265
  symbols: 3,528

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
2012-01-12 05:00:00	AAPL	Stock	15.1554	15.1554	15.0957	15.0957	28840.0
2012-01-12 07:00:00	AAPL	Stock	15.1464	15.1964	15.1464	15.18	456652.0
2012-01-12 08:00:00	AAPL	Stock	15.1789	15.1839	15.0746	15.0864	1746332.0
2012-01-12 09:00:00	AAPL	Stock	15.0911	15.1143	15.0082	15.0486	36928388.0
2012-01-12 10:00:00	AAPL	Stock	15.0468	15.0696	14.9554	14.9939	57858892.0
2012-01-12 11:00:00	AAPL	Stock	14.995	15.0407	14.9886	15.0186	21174692.0
2012-01-12 12:00:00	AAPL	Stock	15.0193	15.0532	15.0104	15.0496	16403100.0
2012-01-12 13:00:00	AAPL	Stock	15.0489	15.0643	15.0264	15.0529	16455376.0
2012-01-12 14:00:00	AAPL	Stock	15.0529	15.0829	15.0379	15.0696	19682600.0
2012-01-12 15:00:00	AAPL	Stock	15.0687	15.0696	15.0361	15.0472	27672344.0
2012-01-12 16:00:00	AAPL	Stock	15.0468	15.0646	15.0332	15.0571	9629816.0
2012-01-12 17:00:00	AAPL	Stock	15.0229	15.0568	15.0229	15.05	171360.0
2012-01-12 18:00:00	AAPL	Stock	15.055	15.0554	15.0496	15.0554	38220.0
2012-01-12 19:00:00	AAPL	Stock	15.0554	15.0661	15.0554	15.0661	129332.0
2012-01-12 08:00:00	MSFT	Stock	27.95	27.95	27.7	27.7	36515.0
2012-01-12 09:00:00	MSFT	Stock	27.73	27.96	27.7	27.87	5464631.0
2012-01-12 10:00:00	MSFT	Stock	27.87	27.925	27.645	27.769	9671937.0
2012-01-12 11:00:00	MSFT	Stock	27.765	27.818	27.74	27.79	4389163.0
2012-01-12 12:00:00	MSFT	Stock	27.785	27.91	27.78	27.906	4782857.0
2012-01-12 13:00:00	MSFT	Stock	27.9	27.95	27.855	27.906	4248565.0
2012-01-12 14:00:00	MSFT	Stock	27.9	27.95	27.86	27.935	3443491.0
2012-01-12 15:00:00	MSFT	Stock	27.935	28.02	27.93	28.0	9059085.0
2012-01-12 16:00:00	MSFT	Stock	28.0	28.04	27.84	28.0	2206636.0
2012-01-12 17:00:00	MSFT	Stock	27.809	28.0	27.809	27.97	8900.0
2012-01-12 18:00:00	MSFT	Stock	27.99	28.0	27.98	28.0	4927.0
2012-01-12 19:00:00	MSFT	Stock	28.0	28.02	28.0	28.0	2815.0
2012-01-12 08:00:00	NVDA	Stock	0.3575	0.3588	0.3545	0.355	522400.0
2012-01-12 09:00:00	NVDA	Stock	0.3555	0.3558	0.3462	0.3505	99724120.0
2012-01-12 10:00:00	NVDA	Stock	0.3502	0.351	0.3448	0.3468	119339000.0
2012-01-12 11:00:00	NVDA	Stock	0.3468	0.347	0.3453	0.3458	98846880.0
2012-01-12 12:00:00	NVDA	Stock	0.346	0.3513	0.3455	0.3513	67180840.0
2012-01-12 13:00:00	NVDA	Stock	0.3511	0.354	0.351	0.3538	49034840.0
2012-01-12 14:00:00	NVDA	Stock	0.3538	0.3548	0.3518	0.3526	54242040.0
2012-01-12 15:00:00	NVDA	Stock	0.3528	0.354	0.3518	0.3522	131765240.0
2012-01-12 16:00:00	NVDA	Stock	0.352	0.3535	0.3497	0.3535	18995960.0
2012-01-12 17:00:00	NVDA	Stock	0.3522	0.3538	0.3522	0.3538	262000.0
2012-01-12 19:00:00	NVDA	Stock	0.3533	0.3535	0.3533	0.3535	20000.0
2012-01-12 07:00:00	AMZN	Stock	9.0055	9.05	9.0055	9.05	10000.0
2012-01-12 08:00:00	AMZN	Stock	9.0055	9.049	8.9445	8.959	260700.0
2012-01-12 09:00:00	AMZN	Stock	8.968	8.975	8.825	8.8635	14328280.0
2012-01-12 10:00:00	AMZN	Stock	8.862	8.8925	8.83	8.856	14036320.0
2012-01-12 11:00:00	AMZN	Stock	8.856	8.9465	8.8505	8.902	9604400.0
2012-01-12 12:00:00	AMZN	Stock	8.9025	8.91	8.875	8.8965	8747380.0
2012-01-12 13:00:00	AMZN	Stock	8.8975	8.9415	8.85	8.8824	15723500.0
2012-01-12 14:00:00	AMZN	Stock	8.8785	8.8889	8.8445	8.8615	11882580.0
2012-01-12 15:00:00	AMZN	Stock	8.863	8.87	8.7875	8.7965	24604840.0
2012-01-12 16:00:00	AMZN	Stock	8.7995	8.864	8.7948	8.8095	244300.0
2012-01-12 17:00:00	AMZN	Stock	8.809	8.822	8.801	8.801	34260.0
2012-01-12 18:00:00	AMZN	Stock	8.816	8.822	8.7965	8.81	96220.0
2012-01-12 19:00:00	AMZN	Stock	8.819	8.822	8.815	8.822	31360.0

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

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