PREVIEW / stock_1hour / 2014-07-10

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-07-10.parquet
  size:    1.0 MB
  rows:    49,835
  symbols: 3,577

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-07-10 04:00:00	AAPL	Stock	23.845	23.845	23.7	23.7	15392.0
2014-07-10 05:00:00	AAPL	Stock	23.715	23.7225	23.6075	23.6175	67864.0
2014-07-10 06:00:00	AAPL	Stock	23.5825	23.6	23.4375	23.4925	170212.0
2014-07-10 07:00:00	AAPL	Stock	23.4925	23.5225	23.45	23.4875	443272.0
2014-07-10 08:00:00	AAPL	Stock	23.49	23.5225	23.4375	23.45	1790096.0
2014-07-10 09:00:00	AAPL	Stock	23.45	23.5975	23.38	23.55	33815272.0
2014-07-10 10:00:00	AAPL	Stock	23.5475	23.685	23.515	23.63	25220948.0
2014-07-10 11:00:00	AAPL	Stock	23.63	23.6675	23.5975	23.6475	12611276.0
2014-07-10 12:00:00	AAPL	Stock	23.645	23.735	23.625	23.72	11301512.0
2014-07-10 13:00:00	AAPL	Stock	23.72	23.8725	23.7125	23.815	16030012.0
2014-07-10 14:00:00	AAPL	Stock	23.8155	23.8875	23.775	23.7762	14246028.0
2014-07-10 15:00:00	AAPL	Stock	23.775	23.795	23.735	23.7575	19718844.0
2014-07-10 16:00:00	AAPL	Stock	23.7575	23.7998	23.6375	23.7375	5190112.0
2014-07-10 17:00:00	AAPL	Stock	23.73	23.76	23.715	23.72	99296.0
2014-07-10 18:00:00	AAPL	Stock	23.72	23.7275	23.7075	23.7225	101928.0
2014-07-10 19:00:00	AAPL	Stock	23.7225	23.7425	23.7125	23.72	58680.0
2014-07-10 05:00:00	MSFT	Stock	41.49	41.5	41.49	41.5	700.0
2014-07-10 06:00:00	MSFT	Stock	41.45	41.45	41.45	41.45	100.0
2014-07-10 07:00:00	MSFT	Stock	41.3	41.31	41.28	41.28	500.0
2014-07-10 08:00:00	MSFT	Stock	41.3	41.45	41.27	41.36	29997.0
2014-07-10 09:00:00	MSFT	Stock	41.35	41.61	41.05	41.34	4264095.0
2014-07-10 10:00:00	MSFT	Stock	41.35	41.76	41.34	41.75	2859177.0
2014-07-10 11:00:00	MSFT	Stock	41.755	41.855	41.65	41.735	2476535.0
2014-07-10 12:00:00	MSFT	Stock	41.735	41.89	41.71	41.81	1474917.0
2014-07-10 13:00:00	MSFT	Stock	41.81	42.0	41.8	41.91	1855130.0
2014-07-10 14:00:00	MSFT	Stock	41.9	41.97	41.796	41.796	2006676.0
2014-07-10 15:00:00	MSFT	Stock	41.79	41.85	41.67	41.68	4876530.0
2014-07-10 16:00:00	MSFT	Stock	41.685	41.877	41.64	41.64	1238366.0
2014-07-10 17:00:00	MSFT	Stock	41.7	41.71	41.7	41.71	2330.0
2014-07-10 18:00:00	MSFT	Stock	41.71	41.71	41.71	41.71	200.0
2014-07-10 19:00:00	MSFT	Stock	41.71	41.71	41.66	41.71	1989.0
2014-07-10 09:00:00	NVDA	Stock	0.4688	0.4715	0.465	0.47	41669800.0
2014-07-10 10:00:00	NVDA	Stock	0.47	0.4723	0.4698	0.4708	53167760.0
2014-07-10 11:00:00	NVDA	Stock	0.471	0.4735	0.4708	0.4735	33016480.0
2014-07-10 12:00:00	NVDA	Stock	0.4734	0.4768	0.4732	0.4746	28892960.0
2014-07-10 13:00:00	NVDA	Stock	0.4748	0.4772	0.4742	0.4758	14415400.0
2014-07-10 14:00:00	NVDA	Stock	0.4758	0.4763	0.4745	0.4747	35252680.0
2014-07-10 15:00:00	NVDA	Stock	0.4746	0.4758	0.4741	0.4751	51485360.0
2014-07-10 16:00:00	NVDA	Stock	0.4751	0.4753	0.4726	0.4753	1825880.0
2014-07-10 18:00:00	NVDA	Stock	0.4772	0.4772	0.4772	0.4772	10000.0
2014-07-10 05:00:00	AMZN	Stock	16.4015	16.403	16.3715	16.3715	20000.0
2014-07-10 06:00:00	AMZN	Stock	16.326	16.3515	16.3	16.3	30580.0
2014-07-10 07:00:00	AMZN	Stock	16.292	16.3	16.25	16.25	29380.0
2014-07-10 08:00:00	AMZN	Stock	16.25	16.2515	16.2	16.2335	106440.0
2014-07-10 09:00:00	AMZN	Stock	16.236	16.2665	16.1325	16.1945	10186740.0
2014-07-10 10:00:00	AMZN	Stock	16.19	16.365	16.1765	16.364	8971360.0
2014-07-10 11:00:00	AMZN	Stock	16.3635	16.4345	16.3315	16.4235	6332920.0
2014-07-10 12:00:00	AMZN	Stock	16.4145	16.499	16.4075	16.482	5802460.0
2014-07-10 13:00:00	AMZN	Stock	16.483	16.4955	16.3715	16.3836	4804560.0
2014-07-10 14:00:00	AMZN	Stock	16.3952	16.4195	16.3335	16.352	3964920.0

> showing 50 of 49,835 rows — these rows as CSV

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