PREVIEW / stock_1hour / 2014-06-23

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-06-23.parquet
  size:    1.0 MB
  rows:    48,555
  symbols: 3,593

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
2014-06-23 04:00:00	AAPL	Stock	22.625	22.9	22.625	22.6725	123280.0
2014-06-23 05:00:00	AAPL	Stock	22.6625	22.755	22.6625	22.755	111704.0
2014-06-23 06:00:00	AAPL	Stock	22.7725	22.785	22.7375	22.75	127088.0
2014-06-23 07:00:00	AAPL	Stock	22.76	22.8375	22.76	22.8375	208520.0
2014-06-23 08:00:00	AAPL	Stock	22.8325	22.865	22.7625	22.84	919224.0
2014-06-23 09:00:00	AAPL	Stock	22.8375	22.905	22.6575	22.665	28446256.0
2014-06-23 10:00:00	AAPL	Stock	22.6675	22.785	22.65	22.677	29069644.0
2014-06-23 11:00:00	AAPL	Stock	22.6775	22.7425	22.6725	22.7375	15794540.0
2014-06-23 12:00:00	AAPL	Stock	22.7398	22.8	22.7275	22.7695	14349004.0
2014-06-23 13:00:00	AAPL	Stock	22.77	22.7725	22.6775	22.6875	10009432.0
2014-06-23 14:00:00	AAPL	Stock	22.687	22.74	22.6812	22.7087	10996872.0
2014-06-23 15:00:00	AAPL	Stock	22.7075	22.72	22.675	22.7035	21564840.0
2014-06-23 16:00:00	AAPL	Stock	22.7075	22.7345	22.6875	22.6875	27077284.0
2014-06-23 17:00:00	AAPL	Stock	22.703	22.703	22.6875	22.695	52368.0
2014-06-23 18:00:00	AAPL	Stock	22.695	22.7075	22.68	22.68	205456.0
2014-06-23 19:00:00	AAPL	Stock	22.6775	22.6925	22.67	22.67	83140.0
2014-06-23 05:00:00	MSFT	Stock	41.55	41.55	41.55	41.55	100.0
2014-06-23 07:00:00	MSFT	Stock	41.6	41.67	41.6	41.6	550.0
2014-06-23 08:00:00	MSFT	Stock	41.64	41.65	41.64	41.65	700.0
2014-06-23 09:00:00	MSFT	Stock	41.63	42.0	41.63	41.98	3174379.0
2014-06-23 10:00:00	MSFT	Stock	41.99	41.99	41.8	41.817	2674571.0
2014-06-23 11:00:00	MSFT	Stock	41.81	41.825	41.69	41.71	1741180.0
2014-06-23 12:00:00	MSFT	Stock	41.71	41.82	41.71	41.795	1211788.0
2014-06-23 13:00:00	MSFT	Stock	41.79	41.88	41.69	41.865	1516353.0
2014-06-23 14:00:00	MSFT	Stock	41.867	41.9	41.84	41.895	1411546.0
2014-06-23 15:00:00	MSFT	Stock	41.895	42.0	41.85	41.98	4572350.0
2014-06-23 16:00:00	MSFT	Stock	41.99	42.0	41.765	41.848	1250323.0
2014-06-23 17:00:00	MSFT	Stock	41.982	42.0	41.98	41.98	707.0
2014-06-23 18:00:00	MSFT	Stock	41.99	41.99	41.91	41.91	8306.0
2014-06-23 19:00:00	MSFT	Stock	41.95	41.97	41.95	41.95	3359.0
2014-06-23 04:00:00	NVDA	Stock	0.4675	0.4675	0.4675	0.4675	20000.0
2014-06-23 05:00:00	NVDA	Stock	0.4652	0.4652	0.465	0.465	36000.0
2014-06-23 08:00:00	NVDA	Stock	0.466	0.466	0.464	0.464	68000.0
2014-06-23 09:00:00	NVDA	Stock	0.4662	0.468	0.4625	0.4635	67567560.0
2014-06-23 10:00:00	NVDA	Stock	0.4635	0.4646	0.4615	0.4638	69205360.0
2014-06-23 11:00:00	NVDA	Stock	0.4635	0.465	0.4625	0.465	47424000.0
2014-06-23 12:00:00	NVDA	Stock	0.465	0.4678	0.4648	0.4678	44195280.0
2014-06-23 13:00:00	NVDA	Stock	0.4678	0.4678	0.4662	0.4662	31042000.0
2014-06-23 14:00:00	NVDA	Stock	0.4664	0.4665	0.4643	0.4645	48884240.0
2014-06-23 15:00:00	NVDA	Stock	0.4646	0.4678	0.4643	0.4678	89723600.0
2014-06-23 16:00:00	NVDA	Stock	0.4678	0.4678	0.4665	0.4678	1181520.0
2014-06-23 17:00:00	NVDA	Stock	0.4662	0.4675	0.4662	0.4675	12000.0
2014-06-23 07:00:00	AMZN	Stock	16.25	16.25	16.25	16.25	2000.0
2014-06-23 08:00:00	AMZN	Stock	16.24	16.25	16.148	16.1495	45100.0
2014-06-23 09:00:00	AMZN	Stock	16.1375	16.2595	16.1115	16.1613	7166300.0
2014-06-23 10:00:00	AMZN	Stock	16.1605	16.1875	16.0705	16.144	10194620.0
2014-06-23 11:00:00	AMZN	Stock	16.1375	16.236	16.132	16.1735	4667720.0
2014-06-23 12:00:00	AMZN	Stock	16.177	16.3175	16.173	16.2875	5499660.0
2014-06-23 13:00:00	AMZN	Stock	16.289	16.302	16.244	16.2925	3636640.0
2014-06-23 14:00:00	AMZN	Stock	16.292	16.3695	16.2695	16.3668	5123520.0

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

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