PREVIEW / stock_1hour / 2011-07-01

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-07-01.parquet
  size:    950 KB
  rows:    45,402
  symbols: 3,511

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-07-01 07:00:00	AAPL	Stock	11.975	12.0357	11.975	11.9821	155540.0
2011-07-01 08:00:00	AAPL	Stock	11.9882	11.9882	11.9646	11.9857	640948.0
2011-07-01 09:00:00	AAPL	Stock	11.9821	12.0039	11.9357	11.9911	39539808.0
2011-07-01 10:00:00	AAPL	Stock	11.9925	12.0611	11.9889	12.0307	70477120.0
2011-07-01 11:00:00	AAPL	Stock	12.0294	12.1582	12.0279	12.1336	81212908.0
2011-07-01 12:00:00	AAPL	Stock	12.1336	12.185	12.127	12.17	42856744.0
2011-07-01 13:00:00	AAPL	Stock	12.1693	12.2657	12.1664	12.2518	52589264.0
2011-07-01 14:00:00	AAPL	Stock	12.2511	12.2564	12.2014	12.2539	54215644.0
2011-07-01 15:00:00	AAPL	Stock	12.2554	12.2679	12.2161	12.2643	78797516.0
2011-07-01 16:00:00	AAPL	Stock	12.2582	12.2679	12.1071	12.2303	11473924.0
2011-07-01 17:00:00	AAPL	Stock	12.2471	12.2496	12.2321	12.2496	221704.0
2011-07-01 18:00:00	AAPL	Stock	12.2593	12.2593	12.2414	12.2471	694344.0
2011-07-01 19:00:00	AAPL	Stock	12.25	12.2536	12.2482	12.2518	74200.0
2011-07-01 08:00:00	MSFT	Stock	25.91	26.03	25.91	26.0	66342.0
2011-07-01 09:00:00	MSFT	Stock	25.93	25.96	25.84	25.94	3006566.0
2011-07-01 10:00:00	MSFT	Stock	25.95	26.12	25.95	26.055	11413615.0
2011-07-01 11:00:00	MSFT	Stock	26.05	26.105	26.01	26.075	5727067.0
2011-07-01 12:00:00	MSFT	Stock	26.075	26.1	26.05	26.07	2702054.0
2011-07-01 13:00:00	MSFT	Stock	26.071	26.15	26.05	26.135	4112229.0
2011-07-01 14:00:00	MSFT	Stock	26.13	26.17	26.06	26.11	5072785.0
2011-07-01 15:00:00	MSFT	Stock	26.11	26.13	26.01	26.06	11692424.0
2011-07-01 16:00:00	MSFT	Stock	26.065	26.08	25.95	25.99	5852059.0
2011-07-01 18:00:00	MSFT	Stock	26.02	26.02	25.97	25.97	4300.0
2011-07-01 19:00:00	MSFT	Stock	25.96	26.12	25.96	26.11	8483.0
2011-07-01 07:00:00	NVDA	Stock	0.3988	0.3988	0.3988	0.3988	4000.0
2011-07-01 08:00:00	NVDA	Stock	0.3984	0.3984	0.3984	0.3984	468000.0
2011-07-01 09:00:00	NVDA	Stock	0.3985	0.4	0.3905	0.3953	61585080.0
2011-07-01 10:00:00	NVDA	Stock	0.3955	0.4043	0.3953	0.4003	138463920.0
2011-07-01 11:00:00	NVDA	Stock	0.4003	0.402	0.3995	0.4013	72433840.0
2011-07-01 12:00:00	NVDA	Stock	0.4013	0.4028	0.4	0.4018	40067400.0
2011-07-01 13:00:00	NVDA	Stock	0.4018	0.4028	0.4013	0.402	39494200.0
2011-07-01 14:00:00	NVDA	Stock	0.402	0.405	0.402	0.4048	59487760.0
2011-07-01 15:00:00	NVDA	Stock	0.4048	0.4053	0.4025	0.4038	111965760.0
2011-07-01 16:00:00	NVDA	Stock	0.4038	0.4038	0.4009	0.4035	15273920.0
2011-07-01 17:00:00	NVDA	Stock	0.4038	0.4038	0.4038	0.4038	6400.0
2011-07-01 18:00:00	NVDA	Stock	0.4048	0.4048	0.4048	0.4048	32000.0
2011-07-01 08:00:00	AMZN	Stock	10.2245	10.265	10.191	10.25	308400.0
2011-07-01 09:00:00	AMZN	Stock	10.2495	10.278	10.1805	10.2475	7047520.0
2011-07-01 10:00:00	AMZN	Stock	10.2485	10.3785	10.2455	10.3245	20477240.0
2011-07-01 11:00:00	AMZN	Stock	10.325	10.362	10.3195	10.3485	8745260.0
2011-07-01 12:00:00	AMZN	Stock	10.35	10.37	10.342	10.3565	5420820.0
2011-07-01 13:00:00	AMZN	Stock	10.3535	10.4329	10.353	10.4315	8123660.0
2011-07-01 14:00:00	AMZN	Stock	10.432	10.5085	10.418	10.507	11742060.0
2011-07-01 15:00:00	AMZN	Stock	10.508	10.5135	10.443	10.4745	14918700.0
2011-07-01 16:00:00	AMZN	Stock	10.4745	10.486	10.3807	10.4433	711260.0
2011-07-01 17:00:00	AMZN	Stock	10.4725	10.4755	10.4685	10.4685	30980.0
2011-07-01 18:00:00	AMZN	Stock	10.4745	10.4825	10.4745	10.4825	56000.0
2011-07-01 19:00:00	AMZN	Stock	10.4775	10.485	10.475	10.485	77000.0
2011-07-01 09:00:00	TSLA	Stock	1.938	1.9633	1.92	1.9593	1993755.0
2011-07-01 10:00:00	TSLA	Stock	1.96	1.9733	1.936	1.9553	3517815.0

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

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