PREVIEW / stock_1hour / 2014-01-10

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-01-10.parquet
  size:    1.0 MB
  rows:    48,044
  symbols: 3,521

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-01-10 04:00:00	AAPL	Stock	19.1957	19.2054	19.175	19.2054	29120.0
2014-01-10 05:00:00	AAPL	Stock	19.25	19.2579	19.2464	19.2464	14000.0
2014-01-10 06:00:00	AAPL	Stock	19.25	19.2575	19.2407	19.2407	46900.0
2014-01-10 07:00:00	AAPL	Stock	19.2532	19.3739	19.2364	19.3679	861980.0
2014-01-10 08:00:00	AAPL	Stock	19.3625	19.3625	19.1796	19.2746	3155768.0
2014-01-10 09:00:00	AAPL	Stock	19.2821	19.3143	19.0679	19.1075	55859020.0
2014-01-10 10:00:00	AAPL	Stock	19.1075	19.1107	18.9857	19.0815	53106956.0
2014-01-10 11:00:00	AAPL	Stock	19.08	19.0882	18.9761	19.0071	28285460.0
2014-01-10 12:00:00	AAPL	Stock	19.0089	19.0289	18.9754	18.9764	15570716.0
2014-01-10 13:00:00	AAPL	Stock	18.9764	19.0157	18.9682	18.9921	14232092.0
2014-01-10 14:00:00	AAPL	Stock	18.9918	19.0336	18.9864	19.025	19447232.0
2014-01-10 15:00:00	AAPL	Stock	19.0246	19.0614	19.0143	19.0329	42746676.0
2014-01-10 16:00:00	AAPL	Stock	19.0329	19.1596	19.0179	19.0196	15588944.0
2014-01-10 17:00:00	AAPL	Stock	19.0179	19.0336	19.0179	19.0336	147924.0
2014-01-10 18:00:00	AAPL	Stock	19.0314	19.0429	19.0271	19.0404	96768.0
2014-01-10 19:00:00	AAPL	Stock	19.0404	19.0432	19.0339	19.0414	48440.0
2014-01-10 04:00:00	MSFT	Stock	35.81	35.9	35.81	35.9	1838.0
2014-01-10 05:00:00	MSFT	Stock	35.9	35.9	35.9	35.9	200.0
2014-01-10 06:00:00	MSFT	Stock	35.85	36.02	35.85	35.94	9211.0
2014-01-10 07:00:00	MSFT	Stock	35.94	35.99	35.83	35.86	31904.0
2014-01-10 08:00:00	MSFT	Stock	35.85	35.93	35.75	35.9	778947.0
2014-01-10 09:00:00	MSFT	Stock	35.92	36.05	35.82	35.95	6929361.0
2014-01-10 10:00:00	MSFT	Stock	35.95	36.11	35.88	36.093	8711431.0
2014-01-10 11:00:00	MSFT	Stock	36.1	36.15	35.9	35.93	5928360.0
2014-01-10 12:00:00	MSFT	Stock	35.935	36.1	35.83	35.83	3026003.0
2014-01-10 13:00:00	MSFT	Stock	35.83	35.966	35.75	35.855	3135714.0
2014-01-10 14:00:00	MSFT	Stock	35.855	35.95	35.83	35.88	2088844.0
2014-01-10 15:00:00	MSFT	Stock	35.87	36.065	35.87	36.04	5783430.0
2014-01-10 16:00:00	MSFT	Stock	36.04	36.06	35.53	36.04	2790704.0
2014-01-10 17:00:00	MSFT	Stock	36.03	36.06	36.03	36.06	12135.0
2014-01-10 18:00:00	MSFT	Stock	36.04	36.04	36.04	36.04	7000.0
2014-01-10 19:00:00	MSFT	Stock	36.04	36.05	36.04	36.05	2540.0
2014-01-10 09:00:00	NVDA	Stock	0.3948	0.3978	0.393	0.3933	20567760.0
2014-01-10 10:00:00	NVDA	Stock	0.3935	0.3942	0.3908	0.3928	39815840.0
2014-01-10 11:00:00	NVDA	Stock	0.3928	0.3935	0.3913	0.3913	21337880.0
2014-01-10 12:00:00	NVDA	Stock	0.3914	0.3914	0.3898	0.3898	18223080.0
2014-01-10 13:00:00	NVDA	Stock	0.3899	0.393	0.3898	0.392	18113880.0
2014-01-10 14:00:00	NVDA	Stock	0.3919	0.3935	0.3919	0.3929	16516920.0
2014-01-10 15:00:00	NVDA	Stock	0.3928	0.394	0.3926	0.3933	41368160.0
2014-01-10 16:00:00	NVDA	Stock	0.3933	0.3972	0.3928	0.3933	37991800.0
2014-01-10 17:00:00	NVDA	Stock	0.3933	0.3933	0.3933	0.3933	28360.0
2014-01-10 07:00:00	AMZN	Stock	20.15	20.1845	20.15	20.1845	6000.0
2014-01-10 08:00:00	AMZN	Stock	20.157	20.1915	20.073	20.1	294620.0
2014-01-10 09:00:00	AMZN	Stock	20.0755	20.1882	19.9145	19.966	9513880.0
2014-01-10 10:00:00	AMZN	Stock	19.9645	20.0	19.8542	19.9425	8149780.0
2014-01-10 11:00:00	AMZN	Stock	19.945	19.9465	19.785	19.801	5785920.0
2014-01-10 12:00:00	AMZN	Stock	19.7955	19.86	19.777	19.7915	2637940.0
2014-01-10 13:00:00	AMZN	Stock	19.7995	19.838	19.768	19.771	3236160.0
2014-01-10 14:00:00	AMZN	Stock	19.772	19.805	19.69	19.731	6590640.0
2014-01-10 15:00:00	AMZN	Stock	19.733	19.884	19.7265	19.877	10241840.0

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

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