PREVIEW / stock_1hour / 2014-01-07

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-01-07.parquet
  size:    1.0 MB
  rows:    48,076
  symbols: 3,530

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-07 04:00:00	AAPL	Stock	19.4446	19.4643	19.4446	19.4643	16100.0
2014-01-07 05:00:00	AAPL	Stock	19.4764	19.4839	19.4436	19.4436	63336.0
2014-01-07 06:00:00	AAPL	Stock	19.4957	19.4964	19.4618	19.4732	50400.0
2014-01-07 07:00:00	AAPL	Stock	19.475	19.4964	19.4721	19.4846	203644.0
2014-01-07 08:00:00	AAPL	Stock	19.4925	19.4992	19.4554	19.4643	1866312.0
2014-01-07 09:00:00	AAPL	Stock	19.4646	19.4661	19.2825	19.3671	55797812.0
2014-01-07 10:00:00	AAPL	Stock	19.3714	19.4986	19.3671	19.3997	49140168.0
2014-01-07 11:00:00	AAPL	Stock	19.405	19.4171	19.3107	19.32	23093280.0
2014-01-07 12:00:00	AAPL	Stock	19.3168	19.3464	19.285	19.3204	17986052.0
2014-01-07 13:00:00	AAPL	Stock	19.3219	19.3354	19.2543	19.2723	22461992.0
2014-01-07 14:00:00	AAPL	Stock	19.2754	19.3029	19.2116	19.2961	35906808.0
2014-01-07 15:00:00	AAPL	Stock	19.2964	19.3407	19.2704	19.2868	38915324.0
2014-01-07 16:00:00	AAPL	Stock	19.2904	19.336	19.2607	19.2732	15220576.0
2014-01-07 17:00:00	AAPL	Stock	19.2739	19.2904	19.2686	19.2696	1288672.0
2014-01-07 18:00:00	AAPL	Stock	19.2696	19.2904	19.2286	19.2321	175224.0
2014-01-07 19:00:00	AAPL	Stock	19.2343	19.25	19.2339	19.2364	146972.0
2014-01-07 05:00:00	MSFT	Stock	36.32	36.49	36.32	36.43	2000.0
2014-01-07 06:00:00	MSFT	Stock	36.48	36.6	36.48	36.58	4456.0
2014-01-07 07:00:00	MSFT	Stock	36.58	36.6	36.46	36.49	10425.0
2014-01-07 08:00:00	MSFT	Stock	36.49	36.5	36.34	36.37	26295.0
2014-01-07 09:00:00	MSFT	Stock	36.37	36.4	36.21	36.34	5292541.0
2014-01-07 10:00:00	MSFT	Stock	36.345	36.47	36.31	36.37	5549975.0
2014-01-07 11:00:00	MSFT	Stock	36.37	36.39	36.28	36.303	3197675.0
2014-01-07 12:00:00	MSFT	Stock	36.305	36.39	36.26	36.385	3173239.0
2014-01-07 13:00:00	MSFT	Stock	36.388	36.4	36.35	36.35	2408609.0
2014-01-07 14:00:00	MSFT	Stock	36.35	36.415	36.29	36.38	3193631.0
2014-01-07 15:00:00	MSFT	Stock	36.39	36.49	36.33	36.4	6624074.0
2014-01-07 16:00:00	MSFT	Stock	36.41	36.453	36.32	36.37	4188133.0
2014-01-07 17:00:00	MSFT	Stock	36.34	36.41	35.41	36.0	397074.0
2014-01-07 18:00:00	MSFT	Stock	36.0	36.04	35.98	36.02	12732.0
2014-01-07 19:00:00	MSFT	Stock	36.03	36.03	35.91	35.94	19065.0
2014-01-07 06:00:00	NVDA	Stock	0.3995	0.405	0.3995	0.405	52000.0
2014-01-07 07:00:00	NVDA	Stock	0.4022	0.4022	0.4	0.4	56960.0
2014-01-07 08:00:00	NVDA	Stock	0.4	0.4	0.3998	0.4	277000.0
2014-01-07 09:00:00	NVDA	Stock	0.3998	0.4015	0.3981	0.4001	46183640.0
2014-01-07 10:00:00	NVDA	Stock	0.4003	0.4045	0.3999	0.4038	55695040.0
2014-01-07 11:00:00	NVDA	Stock	0.4037	0.405	0.4032	0.4041	40152320.0
2014-01-07 12:00:00	NVDA	Stock	0.404	0.4045	0.4028	0.4032	23273720.0
2014-01-07 13:00:00	NVDA	Stock	0.4032	0.4038	0.402	0.402	20093680.0
2014-01-07 14:00:00	NVDA	Stock	0.402	0.4038	0.4016	0.4032	28484000.0
2014-01-07 15:00:00	NVDA	Stock	0.4032	0.404	0.4028	0.4032	73507840.0
2014-01-07 16:00:00	NVDA	Stock	0.4035	0.4039	0.4028	0.4038	2011200.0
2014-01-07 17:00:00	NVDA	Stock	0.4035	0.4035	0.4035	0.4035	142080.0
2014-01-07 04:00:00	AMZN	Stock	19.78	19.78	19.78	19.78	2000.0
2014-01-07 08:00:00	AMZN	Stock	19.7565	19.825	19.7565	19.825	82640.0
2014-01-07 09:00:00	AMZN	Stock	19.8035	19.85	19.7145	19.811	5362760.0
2014-01-07 10:00:00	AMZN	Stock	19.8295	19.918	19.745	19.901	6874540.0
2014-01-07 11:00:00	AMZN	Stock	19.905	19.9225	19.83	19.8635	3324300.0
2014-01-07 12:00:00	AMZN	Stock	19.864	19.923	19.829	19.898	3036760.0
2014-01-07 13:00:00	AMZN	Stock	19.893	19.9065	19.8285	19.8499	2553760.0

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

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