PREVIEW / stock_1hour / 2014-03-24

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-03-24.parquet
  size:    1.0 MB
  rows:    48,425
  symbols: 3,552

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-03-24 04:00:00	AAPL	Stock	19.1425	19.3711	19.1425	19.2964	442736.0
2014-03-24 05:00:00	AAPL	Stock	19.3036	19.3036	19.1786	19.2282	494116.0
2014-03-24 06:00:00	AAPL	Stock	19.2279	19.2279	19.1804	19.2125	98560.0
2014-03-24 07:00:00	AAPL	Stock	19.215	19.3179	19.2093	19.2893	1084776.0
2014-03-24 08:00:00	AAPL	Stock	19.2871	19.3152	19.2057	19.2432	2981720.0
2014-03-24 09:00:00	AAPL	Stock	19.2357	19.3036	19.1839	19.2525	67126724.0
2014-03-24 10:00:00	AAPL	Stock	19.2531	19.285	19.1196	19.1814	51641884.0
2014-03-24 11:00:00	AAPL	Stock	19.1814	19.2068	19.1214	19.1532	29595272.0
2014-03-24 12:00:00	AAPL	Stock	19.15	19.1975	19.1093	19.1611	18916044.0
2014-03-24 13:00:00	AAPL	Stock	19.1679	19.2568	19.1582	19.2486	20631744.0
2014-03-24 14:00:00	AAPL	Stock	19.2468	19.2957	19.2321	19.2625	24258332.0
2014-03-24 15:00:00	AAPL	Stock	19.2629	19.292	19.1989	19.2554	34902196.0
2014-03-24 16:00:00	AAPL	Stock	19.2536	19.2679	19.1615	19.265	46432176.0
2014-03-24 17:00:00	AAPL	Stock	19.2607	19.28	19.2536	19.2679	602028.0
2014-03-24 18:00:00	AAPL	Stock	19.2536	19.2704	19.2536	19.2625	309260.0
2014-03-24 19:00:00	AAPL	Stock	19.2643	19.2657	19.2429	19.2461	242480.0
2014-03-24 06:00:00	MSFT	Stock	40.27	40.27	40.27	40.27	500.0
2014-03-24 07:00:00	MSFT	Stock	40.28	40.35	40.28	40.35	1120.0
2014-03-24 08:00:00	MSFT	Stock	40.28	40.47	40.08	40.46	47153.0
2014-03-24 09:00:00	MSFT	Stock	40.46	40.62	40.21	40.26	5089448.0
2014-03-24 10:00:00	MSFT	Stock	40.265	40.31	39.93	40.041	7321809.0
2014-03-24 11:00:00	MSFT	Stock	40.045	40.13	39.86	40.05	8115705.0
2014-03-24 12:00:00	MSFT	Stock	40.05	40.15	39.99	40.04	3556887.0
2014-03-24 13:00:00	MSFT	Stock	40.05	40.51	40.0	40.5	4493204.0
2014-03-24 14:00:00	MSFT	Stock	40.5	40.64	40.45	40.62	4151578.0
2014-03-24 15:00:00	MSFT	Stock	40.611	40.64	40.46	40.49	6798092.0
2014-03-24 16:00:00	MSFT	Stock	40.51	40.517	40.023	40.49	5034563.0
2014-03-24 17:00:00	MSFT	Stock	40.49	40.49	40.45	40.49	2900.0
2014-03-24 18:00:00	MSFT	Stock	40.45	40.49	40.45	40.49	21224.0
2014-03-24 19:00:00	MSFT	Stock	40.53	40.53	40.47	40.5	4650.0
2014-03-24 08:00:00	NVDA	Stock	0.4635	0.4635	0.4635	0.4635	36800.0
2014-03-24 09:00:00	NVDA	Stock	0.464	0.467	0.4628	0.465	37058840.0
2014-03-24 10:00:00	NVDA	Stock	0.465	0.4675	0.4612	0.4618	65305120.0
2014-03-24 11:00:00	NVDA	Stock	0.4618	0.4618	0.4575	0.4585	30456120.0
2014-03-24 12:00:00	NVDA	Stock	0.4585	0.459	0.4545	0.455	26673960.0
2014-03-24 13:00:00	NVDA	Stock	0.4551	0.4589	0.455	0.4589	22317000.0
2014-03-24 14:00:00	NVDA	Stock	0.4588	0.461	0.4581	0.4601	22935960.0
2014-03-24 15:00:00	NVDA	Stock	0.4601	0.4625	0.4593	0.4615	71752960.0
2014-03-24 16:00:00	NVDA	Stock	0.4612	0.462	0.4612	0.4612	5081160.0
2014-03-24 04:00:00	AMZN	Stock	18.1	18.107	18.1	18.107	4000.0
2014-03-24 05:00:00	AMZN	Stock	18.1175	18.1175	18.07	18.07	4000.0
2014-03-24 07:00:00	AMZN	Stock	18.05	18.0695	18.05	18.0695	8000.0
2014-03-24 08:00:00	AMZN	Stock	18.07	18.07	18.0	18.0585	58160.0
2014-03-24 09:00:00	AMZN	Stock	18.0585	18.075	17.7155	17.8055	11308300.0
2014-03-24 10:00:00	AMZN	Stock	17.8085	17.8085	17.43	17.53	19934600.0
2014-03-24 11:00:00	AMZN	Stock	17.5285	17.5795	17.4335	17.542	12024360.0
2014-03-24 12:00:00	AMZN	Stock	17.536	17.5826	17.43	17.4425	8327400.0
2014-03-24 13:00:00	AMZN	Stock	17.4475	17.624	17.4475	17.605	5601920.0
2014-03-24 14:00:00	AMZN	Stock	17.598	17.665	17.515	17.6255	6137740.0
2014-03-24 15:00:00	AMZN	Stock	17.625	17.7345	17.555	17.593	13115400.0

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

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