PREVIEW / stock_1hour / 2014-10-02

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-10-02.parquet
  size:    1.0 MB
  rows:    48,405
  symbols: 3,578

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-10-02 04:00:00	AAPL	Stock	24.825	24.825	24.7	24.7275	7304.0
2014-10-02 05:00:00	AAPL	Stock	24.7375	24.795	24.7375	24.795	12088.0
2014-10-02 06:00:00	AAPL	Stock	24.7925	24.8775	24.7925	24.8625	20012.0
2014-10-02 07:00:00	AAPL	Stock	24.85	24.925	24.84	24.9	184256.0
2014-10-02 08:00:00	AAPL	Stock	24.8975	24.9425	24.8425	24.8975	850396.0
2014-10-02 09:00:00	AAPL	Stock	24.89	24.94	24.7725	24.8225	22169700.0
2014-10-02 10:00:00	AAPL	Stock	24.82	24.84	24.6525	24.6625	29755756.0
2014-10-02 11:00:00	AAPL	Stock	24.6632	24.695	24.51	24.6275	31310480.0
2014-10-02 12:00:00	AAPL	Stock	24.6275	24.8625	24.62	24.8475	18582992.0
2014-10-02 13:00:00	AAPL	Stock	24.8475	24.9075	24.79	24.8925	20365824.0
2014-10-02 14:00:00	AAPL	Stock	24.8925	24.9975	24.8875	24.98	21145484.0
2014-10-02 15:00:00	AAPL	Stock	24.9803	25.055	24.92	24.9725	31486552.0
2014-10-02 16:00:00	AAPL	Stock	24.975	25.0042	24.6375	24.775	5275024.0
2014-10-02 17:00:00	AAPL	Stock	24.78	24.9975	24.75	24.78	627796.0
2014-10-02 18:00:00	AAPL	Stock	24.785	24.975	24.78	24.785	279520.0
2014-10-02 19:00:00	AAPL	Stock	24.7925	24.8375	24.7875	24.81	182244.0
2014-10-02 04:00:00	MSFT	Stock	45.81	45.81	45.78	45.78	245.0
2014-10-02 06:00:00	MSFT	Stock	45.9	45.9	45.9	45.9	600.0
2014-10-02 07:00:00	MSFT	Stock	45.9	46.18	45.9	46.06	2900.0
2014-10-02 08:00:00	MSFT	Stock	46.08	46.16	45.9	45.99	5054.0
2014-10-02 09:00:00	MSFT	Stock	45.9	46.1	45.82	45.98	2903760.0
2014-10-02 10:00:00	MSFT	Stock	45.985	46.0	45.713	45.76	3783980.0
2014-10-02 11:00:00	MSFT	Stock	45.76	45.9	45.64	45.815	3168629.0
2014-10-02 12:00:00	MSFT	Stock	45.82	45.905	45.73	45.875	2655708.0
2014-10-02 13:00:00	MSFT	Stock	45.88	45.96	45.8	45.823	2883563.0
2014-10-02 14:00:00	MSFT	Stock	45.825	45.98	45.81	45.97	2557361.0
2014-10-02 15:00:00	MSFT	Stock	45.974	45.98	45.74	45.75	5385315.0
2014-10-02 16:00:00	MSFT	Stock	45.76	45.9	45.64	45.9	930653.0
2014-10-02 17:00:00	MSFT	Stock	45.71	45.76	45.69	45.69	2988.0
2014-10-02 18:00:00	MSFT	Stock	45.71	45.71	45.71	45.71	100.0
2014-10-02 19:00:00	MSFT	Stock	45.7	45.7	45.7	45.7	100.0
2014-10-02 04:00:00	NVDA	Stock	0.4555	0.4555	0.4555	0.4555	4000.0
2014-10-02 09:00:00	NVDA	Stock	0.4552	0.456	0.4505	0.4511	28818120.0
2014-10-02 10:00:00	NVDA	Stock	0.451	0.4518	0.4479	0.448	36527400.0
2014-10-02 11:00:00	NVDA	Stock	0.4482	0.4492	0.4442	0.4472	21129120.0
2014-10-02 12:00:00	NVDA	Stock	0.4472	0.452	0.4472	0.4518	21069480.0
2014-10-02 13:00:00	NVDA	Stock	0.4516	0.4558	0.451	0.4554	36375160.0
2014-10-02 14:00:00	NVDA	Stock	0.4555	0.4582	0.455	0.4575	58228400.0
2014-10-02 15:00:00	NVDA	Stock	0.4572	0.4575	0.4545	0.4548	65961440.0
2014-10-02 16:00:00	NVDA	Stock	0.4548	0.4554	0.4546	0.4548	13507840.0
2014-10-02 07:00:00	AMZN	Stock	15.86	15.8915	15.86	15.8915	22000.0
2014-10-02 08:00:00	AMZN	Stock	15.863	15.8855	15.833	15.835	96560.0
2014-10-02 09:00:00	AMZN	Stock	15.8225	15.846	15.6795	15.6816	10432380.0
2014-10-02 10:00:00	AMZN	Stock	15.68	15.795	15.64	15.6415	15077720.0
2014-10-02 11:00:00	AMZN	Stock	15.6464	15.7122	15.61	15.6401	7673920.0
2014-10-02 12:00:00	AMZN	Stock	15.6423	15.7725	15.5655	15.7685	7496340.0
2014-10-02 13:00:00	AMZN	Stock	15.7665	15.8595	15.736	15.8095	7895360.0
2014-10-02 14:00:00	AMZN	Stock	15.806	15.9075	15.789	15.8815	6894340.0
2014-10-02 15:00:00	AMZN	Stock	15.8838	15.9265	15.8365	15.92	8765900.0
2014-10-02 16:00:00	AMZN	Stock	15.9205	15.9275	15.6951	15.901	1240360.0

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

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