PREVIEW / stock_1hour / 2011-04-19

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-04-19.parquet
  size:    927 KB
  rows:    43,739
  symbols: 3,519

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-04-19 04:00:00	AAPL	Stock	11.8639	11.9239	11.8639	11.9239	75600.0
2011-04-19 05:00:00	AAPL	Stock	11.9489	11.9579	11.9286	11.9286	30800.0
2011-04-19 06:00:00	AAPL	Stock	11.9286	11.9425	11.9279	11.9286	44184.0
2011-04-19 07:00:00	AAPL	Stock	11.9193	11.9275	11.9	11.9189	575820.0
2011-04-19 08:00:00	AAPL	Stock	11.9175	11.9393	11.8946	11.9071	3192560.0
2011-04-19 09:00:00	AAPL	Stock	11.9107	11.9529	11.8661	11.9179	77529368.0
2011-04-19 10:00:00	AAPL	Stock	11.9193	11.9354	11.8804	11.9036	56971712.0
2011-04-19 11:00:00	AAPL	Stock	11.9036	11.9354	11.8839	11.9136	36238832.0
2011-04-19 12:00:00	AAPL	Stock	11.9133	11.9171	11.892	11.9057	19953360.0
2011-04-19 13:00:00	AAPL	Stock	11.9075	11.9668	11.9025	11.9525	34392260.0
2011-04-19 14:00:00	AAPL	Stock	11.9539	11.9671	11.92	11.9579	66668028.0
2011-04-19 15:00:00	AAPL	Stock	11.9583	12.0707	11.9571	12.0671	111470576.0
2011-04-19 16:00:00	AAPL	Stock	12.0664	12.1364	11.9521	12.1132	8693244.0
2011-04-19 17:00:00	AAPL	Stock	12.1079	12.1232	11.8593	12.1232	740040.0
2011-04-19 18:00:00	AAPL	Stock	12.1229	12.1286	12.1157	12.1232	275744.0
2011-04-19 19:00:00	AAPL	Stock	12.1214	12.1339	12.1161	12.1339	384776.0
2011-04-19 04:00:00	MSFT	Stock	25.08	25.08	25.08	25.08	200.0
2011-04-19 06:00:00	MSFT	Stock	25.17	25.18	25.17	25.18	200.0
2011-04-19 07:00:00	MSFT	Stock	25.19	25.19	25.19	25.19	700.0
2011-04-19 08:00:00	MSFT	Stock	25.17	25.17	25.12	25.12	18250.0
2011-04-19 09:00:00	MSFT	Stock	25.12	25.16	24.97	24.99	4502271.0
2011-04-19 10:00:00	MSFT	Stock	25.0	25.026	24.87	24.98	7224699.0
2011-04-19 11:00:00	MSFT	Stock	24.985	25.01	24.95	25.0	4081138.0
2011-04-19 12:00:00	MSFT	Stock	24.992	25.01	24.96	24.99	3911959.0
2011-04-19 13:00:00	MSFT	Stock	24.993	25.15	24.99	25.1	4335821.0
2011-04-19 14:00:00	MSFT	Stock	25.105	25.13	25.04	25.07	3859483.0
2011-04-19 15:00:00	MSFT	Stock	25.08	25.169	25.06	25.14	8773976.0
2011-04-19 16:00:00	MSFT	Stock	25.14	25.52	25.031	25.45	1387520.0
2011-04-19 17:00:00	MSFT	Stock	25.45	25.47	25.092	25.45	58379.0
2011-04-19 18:00:00	MSFT	Stock	25.47	25.5	25.45	25.47	21431.0
2011-04-19 19:00:00	MSFT	Stock	25.47	25.49	25.42	25.45	8443.0
2011-04-19 08:00:00	NVDA	Stock	0.4548	0.4548	0.4545	0.4545	35280.0
2011-04-19 09:00:00	NVDA	Stock	0.4545	0.455	0.445	0.4452	82951640.0
2011-04-19 10:00:00	NVDA	Stock	0.445	0.4461	0.4402	0.4408	136221240.0
2011-04-19 11:00:00	NVDA	Stock	0.4405	0.4418	0.4382	0.4388	84843000.0
2011-04-19 12:00:00	NVDA	Stock	0.4388	0.4445	0.4385	0.4445	81930560.0
2011-04-19 13:00:00	NVDA	Stock	0.4445	0.449	0.4445	0.4479	76442720.0
2011-04-19 14:00:00	NVDA	Stock	0.448	0.4513	0.446	0.4482	56937000.0
2011-04-19 15:00:00	NVDA	Stock	0.448	0.4512	0.4468	0.4505	103581880.0
2011-04-19 16:00:00	NVDA	Stock	0.4502	0.4575	0.445	0.4562	13151120.0
2011-04-19 17:00:00	NVDA	Stock	0.4562	0.4588	0.4401	0.4555	2025440.0
2011-04-19 18:00:00	NVDA	Stock	0.4562	0.458	0.4562	0.458	354000.0
2011-04-19 19:00:00	NVDA	Stock	0.457	0.457	0.4548	0.4548	172000.0
2011-04-19 07:00:00	AMZN	Stock	8.9665	8.9665	8.95	8.95	28000.0
2011-04-19 08:00:00	AMZN	Stock	8.925	8.9375	8.9245	8.9365	33100.0
2011-04-19 09:00:00	AMZN	Stock	8.933	8.9735	8.9	8.9265	7735940.0
2011-04-19 10:00:00	AMZN	Stock	8.9245	8.9655	8.877	8.8921	8893780.0
2011-04-19 11:00:00	AMZN	Stock	8.89	8.9015	8.83	8.866	7653180.0
2011-04-19 12:00:00	AMZN	Stock	8.8655	8.9245	8.859	8.907	5483460.0
2011-04-19 13:00:00	AMZN	Stock	8.907	8.943	8.899	8.9315	3978520.0

> showing 50 of 43,739 rows — these rows as CSV

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