PREVIEW / stock_1hour / 2014-04-28

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-04-28.parquet
  size:    1.0 MB
  rows:    48,426
  symbols: 3,543

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-04-28 04:00:00	AAPL	Stock	20.4286	20.4793	20.4286	20.4786	27440.0
2014-04-28 05:00:00	AAPL	Stock	20.475	20.475	20.4218	20.4339	149184.0
2014-04-28 06:00:00	AAPL	Stock	20.4339	20.4339	20.4339	20.4339	2800.0
2014-04-28 07:00:00	AAPL	Stock	20.4636	20.4786	20.4554	20.4725	493052.0
2014-04-28 08:00:00	AAPL	Stock	20.4679	20.4746	20.4061	20.4536	1748852.0
2014-04-28 09:00:00	AAPL	Stock	20.4536	20.8214	20.4311	20.8021	89081580.0
2014-04-28 10:00:00	AAPL	Stock	20.8068	21.0811	20.7839	21.0271	115098144.0
2014-04-28 11:00:00	AAPL	Stock	21.0279	21.1768	20.9089	20.9382	94391360.0
2014-04-28 12:00:00	AAPL	Stock	20.9439	21.0711	20.8857	21.0496	38764824.0
2014-04-28 13:00:00	AAPL	Stock	21.0454	21.0454	20.8075	20.8807	41221348.0
2014-04-28 14:00:00	AAPL	Stock	20.8818	21.0314	20.8143	21.0043	36563436.0
2014-04-28 15:00:00	AAPL	Stock	21.0045	21.2768	20.9871	21.2168	102933992.0
2014-04-28 16:00:00	AAPL	Stock	21.2245	21.2311	20.9364	21.2107	22177596.0
2014-04-28 17:00:00	AAPL	Stock	21.2061	21.2311	21.2007	21.2311	499436.0
2014-04-28 18:00:00	AAPL	Stock	21.2254	21.25	21.2175	21.2232	588000.0
2014-04-28 19:00:00	AAPL	Stock	21.2314	21.2496	21.2214	21.2346	250908.0
2014-04-28 07:00:00	MSFT	Stock	39.98	40.18	39.98	40.11	6184.0
2014-04-28 08:00:00	MSFT	Stock	40.08	40.14	40.03	40.03	11454.0
2014-04-28 09:00:00	MSFT	Stock	40.02	40.83	40.0	40.83	8757474.0
2014-04-28 10:00:00	MSFT	Stock	40.83	41.29	40.74	41.055	9857996.0
2014-04-28 11:00:00	MSFT	Stock	41.05	41.07	40.76	40.81	6480960.0
2014-04-28 12:00:00	MSFT	Stock	40.8	40.9	40.62	40.67	4397485.0
2014-04-28 13:00:00	MSFT	Stock	40.68	40.71	40.48	40.595	5649188.0
2014-04-28 14:00:00	MSFT	Stock	40.59	40.8	40.54	40.65	3961818.0
2014-04-28 15:00:00	MSFT	Stock	40.65	40.99	40.64	40.86	7879906.0
2014-04-28 16:00:00	MSFT	Stock	40.87	41.046	40.779	40.95	1426639.0
2014-04-28 17:00:00	MSFT	Stock	40.93	40.94	40.875	40.9	26075.0
2014-04-28 18:00:00	MSFT	Stock	40.9	40.95	40.9	40.95	4174.0
2014-04-28 19:00:00	MSFT	Stock	40.95	40.97	40.95	40.95	6550.0
2014-04-28 07:00:00	NVDA	Stock	0.4695	0.4695	0.469	0.469	14000.0
2014-04-28 09:00:00	NVDA	Stock	0.472	0.4745	0.4678	0.4725	28385800.0
2014-04-28 10:00:00	NVDA	Stock	0.4725	0.4739	0.4684	0.4685	39340400.0
2014-04-28 11:00:00	NVDA	Stock	0.4685	0.4699	0.4625	0.4645	31150400.0
2014-04-28 12:00:00	NVDA	Stock	0.4645	0.4658	0.4638	0.4645	17885120.0
2014-04-28 13:00:00	NVDA	Stock	0.4643	0.4643	0.4605	0.4635	24006640.0
2014-04-28 14:00:00	NVDA	Stock	0.4636	0.4662	0.4625	0.4652	20054240.0
2014-04-28 15:00:00	NVDA	Stock	0.4652	0.4695	0.4648	0.4662	49412640.0
2014-04-28 16:00:00	NVDA	Stock	0.4662	0.4676	0.4662	0.4662	9680000.0
2014-04-28 17:00:00	NVDA	Stock	0.4664	0.4664	0.4663	0.4663	51880.0
2014-04-28 04:00:00	AMZN	Stock	15.2495	15.25	15.2495	15.25	4000.0
2014-04-28 05:00:00	AMZN	Stock	15.314	15.314	15.3	15.3	7000.0
2014-04-28 06:00:00	AMZN	Stock	15.3025	15.3025	15.241	15.2505	34660.0
2014-04-28 07:00:00	AMZN	Stock	15.25	15.25	15.2005	15.205	165640.0
2014-04-28 08:00:00	AMZN	Stock	15.2045	15.2425	15.052	15.078	894480.0
2014-04-28 09:00:00	AMZN	Stock	15.08	15.2385	14.4	14.6108	81756760.0
2014-04-28 10:00:00	AMZN	Stock	14.61	14.8875	14.5305	14.766	40084760.0
2014-04-28 11:00:00	AMZN	Stock	14.7685	14.875	14.5	14.5285	31127460.0
2014-04-28 12:00:00	AMZN	Stock	14.527	14.6175	14.425	14.458	22791780.0
2014-04-28 13:00:00	AMZN	Stock	14.4605	14.64	14.4125	14.5955	28258940.0
2014-04-28 14:00:00	AMZN	Stock	14.597	14.765	14.55	14.692	19385800.0

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

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