PREVIEW / stock_1hour / 2012-04-02

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-04-02.parquet
  size:    964 KB
  rows:    45,286
  symbols: 3,533

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-04-02 04:00:00	AAPL	Stock	21.5	21.6071	21.5	21.5393	114240.0
2012-04-02 05:00:00	AAPL	Stock	21.5393	21.5393	21.49	21.5071	89880.0
2012-04-02 06:00:00	AAPL	Stock	21.5143	21.5143	21.5	21.5	33600.0
2012-04-02 07:00:00	AAPL	Stock	21.5107	21.5143	21.3661	21.3786	795312.0
2012-04-02 08:00:00	AAPL	Stock	21.3911	21.5093	21.3125	21.4907	5778248.0
2012-04-02 09:00:00	AAPL	Stock	21.4907	21.7604	21.4096	21.6796	119203448.0
2012-04-02 10:00:00	AAPL	Stock	21.6793	21.8482	21.6779	21.8064	117691812.0
2012-04-02 11:00:00	AAPL	Stock	21.8064	21.9429	21.8026	21.9196	78217608.0
2012-04-02 12:00:00	AAPL	Stock	21.9196	21.9786	21.9107	21.9679	59518284.0
2012-04-02 13:00:00	AAPL	Stock	21.9668	22.0029	21.9396	22.0004	37627016.0
2012-04-02 14:00:00	AAPL	Stock	21.9981	22.0232	21.9571	22.0011	47015220.0
2012-04-02 15:00:00	AAPL	Stock	22.0032	22.0989	21.9825	22.0957	110274080.0
2012-04-02 16:00:00	AAPL	Stock	22.0893	22.1036	21.4096	22.0871	6370952.0
2012-04-02 17:00:00	AAPL	Stock	22.0861	22.0925	22.0779	22.0875	383740.0
2012-04-02 18:00:00	AAPL	Stock	22.0875	22.1089	22.0839	22.1025	1092476.0
2012-04-02 19:00:00	AAPL	Stock	22.1014	22.1382	22.1014	22.1075	765856.0
2012-04-02 04:00:00	MSFT	Stock	32.26	32.26	32.26	32.26	4000.0
2012-04-02 07:00:00	MSFT	Stock	32.15	32.23	32.15	32.23	1400.0
2012-04-02 08:00:00	MSFT	Stock	32.33	32.33	32.16	32.25	13713.0
2012-04-02 09:00:00	MSFT	Stock	32.24	32.24	31.95	31.989	4527910.0
2012-04-02 10:00:00	MSFT	Stock	31.98	32.215	31.97	32.171	5656209.0
2012-04-02 11:00:00	MSFT	Stock	32.17	32.4	32.145	32.385	3916746.0
2012-04-02 12:00:00	MSFT	Stock	32.385	32.46	32.37	32.42	2915382.0
2012-04-02 13:00:00	MSFT	Stock	32.41	32.45	32.34	32.42	2602837.0
2012-04-02 14:00:00	MSFT	Stock	32.42	32.45	32.34	32.38	3237455.0
2012-04-02 15:00:00	MSFT	Stock	32.38	32.39	32.26	32.28	8259148.0
2012-04-02 16:00:00	MSFT	Stock	32.28	32.379	32.25	32.29	3502329.0
2012-04-02 17:00:00	MSFT	Stock	32.28	32.29	32.18	32.18	5609.0
2012-04-02 18:00:00	MSFT	Stock	32.2	32.26	32.2	32.26	2397.0
2012-04-02 19:00:00	MSFT	Stock	32.28	32.28	32.28	32.28	200.0
2012-04-02 08:00:00	NVDA	Stock	0.3848	0.3848	0.3838	0.3848	50000.0
2012-04-02 09:00:00	NVDA	Stock	0.3855	0.3855	0.3778	0.379	39646520.0
2012-04-02 10:00:00	NVDA	Stock	0.3788	0.3825	0.3785	0.3825	56743600.0
2012-04-02 11:00:00	NVDA	Stock	0.3824	0.3862	0.3822	0.386	49573680.0
2012-04-02 12:00:00	NVDA	Stock	0.3861	0.3873	0.385	0.3858	35985320.0
2012-04-02 13:00:00	NVDA	Stock	0.3856	0.3858	0.3835	0.384	40189000.0
2012-04-02 14:00:00	NVDA	Stock	0.3838	0.3862	0.3833	0.3845	85780400.0
2012-04-02 15:00:00	NVDA	Stock	0.3848	0.3848	0.3818	0.383	85809280.0
2012-04-02 16:00:00	NVDA	Stock	0.383	0.3848	0.3825	0.3833	1140040.0
2012-04-02 17:00:00	NVDA	Stock	0.3865	0.3865	0.3848	0.3862	48000.0
2012-04-02 18:00:00	NVDA	Stock	0.3848	0.3848	0.3848	0.3848	12000.0
2012-04-02 19:00:00	NVDA	Stock	0.3848	0.3848	0.3848	0.3848	440000.0
2012-04-02 04:00:00	AMZN	Stock	10.0015	10.0335	10.0	10.0335	8000.0
2012-04-02 05:00:00	AMZN	Stock	9.8575	9.8575	9.8505	9.8525	14500.0
2012-04-02 06:00:00	AMZN	Stock	9.8535	9.8535	9.8495	9.8495	22000.0
2012-04-02 07:00:00	AMZN	Stock	9.8745	9.95	9.8745	9.8995	131240.0
2012-04-02 08:00:00	AMZN	Stock	9.9	10.1255	9.8805	9.89	847540.0
2012-04-02 09:00:00	AMZN	Stock	9.894	10.1255	9.85	9.906	25106800.0
2012-04-02 10:00:00	AMZN	Stock	9.91	9.9795	9.873	9.8939	24799800.0
2012-04-02 11:00:00	AMZN	Stock	9.8905	9.95	9.85	9.937	18818500.0

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

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