PREVIEW / stock_1hour / 2011-06-15

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-06-15.parquet
  size:    953 KB
  rows:    45,349
  symbols: 3,558

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-06-15 04:00:00	AAPL	Stock	11.875	11.875	11.8432	11.8439	8400.0
2011-06-15 05:00:00	AAPL	Stock	11.8036	11.8036	11.7896	11.7911	39200.0
2011-06-15 06:00:00	AAPL	Stock	11.8121	11.8157	11.795	11.8089	29820.0
2011-06-15 07:00:00	AAPL	Stock	11.8057	11.8354	11.8057	11.8254	193648.0
2011-06-15 08:00:00	AAPL	Stock	11.8254	11.8379	11.7632	11.7754	1767136.0
2011-06-15 09:00:00	AAPL	Stock	11.7696	11.7857	11.7293	11.7546	48230028.0
2011-06-15 10:00:00	AAPL	Stock	11.7539	11.7964	11.7386	11.7464	45799040.0
2011-06-15 11:00:00	AAPL	Stock	11.7459	11.7564	11.6793	11.6929	53112052.0
2011-06-15 12:00:00	AAPL	Stock	11.6944	11.6982	11.6361	11.6525	48034196.0
2011-06-15 13:00:00	AAPL	Stock	11.6536	11.6864	11.6429	11.66	35446404.0
2011-06-15 14:00:00	AAPL	Stock	11.66	11.6843	11.6382	11.6457	40588604.0
2011-06-15 15:00:00	AAPL	Stock	11.6436	11.6786	11.6029	11.6711	98224980.0
2011-06-15 16:00:00	AAPL	Stock	11.6604	11.7453	11.6362	11.6779	9780148.0
2011-06-15 17:00:00	AAPL	Stock	11.6775	11.7727	11.6575	11.6746	430528.0
2011-06-15 18:00:00	AAPL	Stock	11.675	11.6839	11.6696	11.6786	3390772.0
2011-06-15 19:00:00	AAPL	Stock	11.6821	11.6821	11.6711	11.6804	125888.0
2011-06-15 05:00:00	MSFT	Stock	24.06	24.06	24.06	24.06	500.0
2011-06-15 07:00:00	MSFT	Stock	24.11	24.11	24.11	24.11	100.0
2011-06-15 08:00:00	MSFT	Stock	24.1	24.15	24.01	24.04	16190.0
2011-06-15 09:00:00	MSFT	Stock	24.02	24.04	23.89	23.92	4672873.0
2011-06-15 10:00:00	MSFT	Stock	23.92	23.97	23.88	23.88	5246719.0
2011-06-15 11:00:00	MSFT	Stock	23.89	23.94	23.74	23.8	5840526.0
2011-06-15 12:00:00	MSFT	Stock	23.8	23.85	23.7	23.76	6288666.0
2011-06-15 13:00:00	MSFT	Stock	23.76	23.78	23.7	23.755	4215734.0
2011-06-15 14:00:00	MSFT	Stock	23.755	23.82	23.69	23.71	6047577.0
2011-06-15 15:00:00	MSFT	Stock	23.71	23.78	23.67	23.76	13105768.0
2011-06-15 16:00:00	MSFT	Stock	23.75	23.922	23.732	23.76	2893825.0
2011-06-15 17:00:00	MSFT	Stock	23.945	23.945	23.75	23.79	53602.0
2011-06-15 18:00:00	MSFT	Stock	23.74	23.77	23.73	23.73	122561.0
2011-06-15 19:00:00	MSFT	Stock	23.73	23.77	23.73	23.74	7080.0
2011-06-15 08:00:00	NVDA	Stock	0.4275	0.4275	0.4232	0.4235	489840.0
2011-06-15 09:00:00	NVDA	Stock	0.4235	0.4235	0.4105	0.4188	130489920.0
2011-06-15 10:00:00	NVDA	Stock	0.4188	0.4253	0.4158	0.4158	142603640.0
2011-06-15 11:00:00	NVDA	Stock	0.4155	0.417	0.4118	0.4154	142835640.0
2011-06-15 12:00:00	NVDA	Stock	0.4154	0.418	0.4135	0.4158	58190760.0
2011-06-15 13:00:00	NVDA	Stock	0.4158	0.4175	0.4128	0.4133	71997360.0
2011-06-15 14:00:00	NVDA	Stock	0.4131	0.4185	0.4128	0.418	142357000.0
2011-06-15 15:00:00	NVDA	Stock	0.418	0.4205	0.4165	0.4195	215522520.0
2011-06-15 16:00:00	NVDA	Stock	0.4198	0.4208	0.4168	0.4185	7704360.0
2011-06-15 17:00:00	NVDA	Stock	0.4138	0.4225	0.4138	0.4213	1582760.0
2011-06-15 18:00:00	NVDA	Stock	0.4195	0.4213	0.4195	0.4208	84000.0
2011-06-15 19:00:00	NVDA	Stock	0.4208	0.4208	0.4208	0.4208	4000.0
2011-06-15 07:00:00	AMZN	Stock	9.498	9.498	9.498	9.498	2000.0
2011-06-15 08:00:00	AMZN	Stock	9.4645	9.4805	9.414	9.415	229060.0
2011-06-15 09:00:00	AMZN	Stock	9.4185	9.588	9.375	9.585	16523360.0
2011-06-15 10:00:00	AMZN	Stock	9.5755	9.6225	9.5405	9.592	19278600.0
2011-06-15 11:00:00	AMZN	Stock	9.5885	9.603	9.4755	9.496	14182920.0
2011-06-15 12:00:00	AMZN	Stock	9.502	9.5445	9.4155	9.418	15450300.0
2011-06-15 13:00:00	AMZN	Stock	9.421	9.469	9.403	9.4275	10108540.0
2011-06-15 14:00:00	AMZN	Stock	9.425	9.4415	9.3295	9.33	16459900.0

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

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