PREVIEW / stock_1hour / 2015-06-12

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-06-12.parquet
  size:    1.0 MB
  rows:    48,455
  symbols: 3,486

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
2015-06-12 04:00:00	AAPL	Stock	32.1875	32.1975	32.0375	32.0375	5972.0
2015-06-12 05:00:00	AAPL	Stock	32.0725	32.12	32.0725	32.12	5108.0
2015-06-12 06:00:00	AAPL	Stock	32.135	32.185	32.1025	32.1225	15504.0
2015-06-12 07:00:00	AAPL	Stock	32.1075	32.1075	32.05	32.075	96816.0
2015-06-12 08:00:00	AAPL	Stock	32.09	32.125	32.0525	32.0675	407380.0
2015-06-12 09:00:00	AAPL	Stock	32.0725	32.0825	31.925	31.98	21344840.0
2015-06-12 10:00:00	AAPL	Stock	31.9825	32.0825	31.8575	31.866	25236976.0
2015-06-12 11:00:00	AAPL	Stock	31.86	32.01	31.8475	31.9025	15730728.0
2015-06-12 12:00:00	AAPL	Stock	31.9025	31.9175	31.8575	31.8925	9640008.0
2015-06-12 13:00:00	AAPL	Stock	31.8925	31.9475	31.8775	31.9175	10716652.0
2015-06-12 14:00:00	AAPL	Stock	31.9175	31.92	31.82	31.8225	11328948.0
2015-06-12 15:00:00	AAPL	Stock	31.8225	31.925	31.7775	31.79	29120656.0
2015-06-12 16:00:00	AAPL	Stock	31.79	31.8125	31.7875	31.805	14981128.0
2015-06-12 17:00:00	AAPL	Stock	31.8	31.805	31.795	31.8	92884.0
2015-06-12 18:00:00	AAPL	Stock	31.8	31.8	31.7925	31.795	53120.0
2015-06-12 19:00:00	AAPL	Stock	31.7975	31.8075	31.7925	31.8075	147400.0
2015-06-12 07:00:00	MSFT	Stock	46.55	46.55	46.24	46.24	6755.0
2015-06-12 08:00:00	MSFT	Stock	46.54	46.54	46.19	46.19	7338.0
2015-06-12 09:00:00	MSFT	Stock	46.2	46.38	46.08	46.27	4075510.0
2015-06-12 10:00:00	MSFT	Stock	46.27	46.47	46.06	46.1	4472589.0
2015-06-12 11:00:00	MSFT	Stock	46.09	46.25	45.94	45.96	2841808.0
2015-06-12 12:00:00	MSFT	Stock	45.96	46.04	45.9	45.96	1544703.0
2015-06-12 13:00:00	MSFT	Stock	45.95	46.08	45.93	46.05	1646874.0
2015-06-12 14:00:00	MSFT	Stock	46.06	46.076	45.92	45.93	1402861.0
2015-06-12 15:00:00	MSFT	Stock	45.93	46.11	45.915	45.97	3187839.0
2015-06-12 16:00:00	MSFT	Stock	45.97	46.02	45.97	45.99	3255131.0
2015-06-12 17:00:00	MSFT	Stock	45.99	46.05	45.99	46.05	1100.0
2015-06-12 19:00:00	MSFT	Stock	46.003	46.003	46.003	46.003	219.0
2015-06-12 08:00:00	NVDA	Stock	0.5412	0.5412	0.5412	0.5412	26000.0
2015-06-12 09:00:00	NVDA	Stock	0.539	0.5422	0.5365	0.5385	32700760.0
2015-06-12 10:00:00	NVDA	Stock	0.5385	0.5392	0.5332	0.5348	33722920.0
2015-06-12 11:00:00	NVDA	Stock	0.5348	0.537	0.5327	0.5355	41776360.0
2015-06-12 12:00:00	NVDA	Stock	0.5354	0.5358	0.5315	0.532	28266000.0
2015-06-12 13:00:00	NVDA	Stock	0.5322	0.533	0.5298	0.5315	32286560.0
2015-06-12 14:00:00	NVDA	Stock	0.5315	0.5318	0.529	0.5293	20571200.0
2015-06-12 15:00:00	NVDA	Stock	0.5291	0.5295	0.5265	0.5275	79197480.0
2015-06-12 16:00:00	NVDA	Stock	0.5278	0.53	0.5278	0.53	44414680.0
2015-06-12 08:00:00	AMZN	Stock	21.5522	21.5665	21.55	21.55	52520.0
2015-06-12 09:00:00	AMZN	Stock	21.5535	21.6015	21.51	21.59	6291820.0
2015-06-12 10:00:00	AMZN	Stock	21.5773	21.618	21.413	21.498	6060920.0
2015-06-12 11:00:00	AMZN	Stock	21.4982	21.5098	21.4385	21.4865	3215700.0
2015-06-12 12:00:00	AMZN	Stock	21.481	21.5125	21.4695	21.4795	1726740.0
2015-06-12 13:00:00	AMZN	Stock	21.48	21.531	21.453	21.51	2813300.0
2015-06-12 14:00:00	AMZN	Stock	21.515	21.5175	21.444	21.455	3647740.0
2015-06-12 15:00:00	AMZN	Stock	21.454	21.5345	21.445	21.496	7379700.0
2015-06-12 16:00:00	AMZN	Stock	21.496	21.512	21.4875	21.496	140580.0
2015-06-12 19:00:00	AMZN	Stock	21.5025	21.5025	21.5025	21.5025	2000.0
2015-06-12 08:00:00	GOOGL	Stock	27.375	27.375	27.375	27.375	2000.0
2015-06-12 09:00:00	GOOGL	Stock	27.3575	27.4425	27.3315	27.3775	2827120.0
2015-06-12 10:00:00	GOOGL	Stock	27.3775	27.4255	27.2945	27.3134	2179980.0

> showing 50 of 48,455 rows — these rows as CSV

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