PREVIEW / stock_1hour / 2013-10-04

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-10-04.parquet
  size:    1004 KB
  rows:    46,424
  symbols: 3,522

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
2013-10-04 04:00:00	AAPL	Stock	17.2814	17.3214	17.2814	17.3214	38500.0
2013-10-04 05:00:00	AAPL	Stock	17.3375	17.3536	17.3282	17.3536	50260.0
2013-10-04 06:00:00	AAPL	Stock	17.3457	17.3557	17.3457	17.3557	46312.0
2013-10-04 07:00:00	AAPL	Stock	17.35	17.3618	17.2857	17.3036	235816.0
2013-10-04 08:00:00	AAPL	Stock	17.3036	17.37	17.25	17.2946	1763552.0
2013-10-04 09:00:00	AAPL	Stock	17.2921	17.3071	17.1075	17.1304	53700024.0
2013-10-04 10:00:00	AAPL	Stock	17.1307	17.2361	17.0929	17.1596	54736388.0
2013-10-04 11:00:00	AAPL	Stock	17.16	17.1742	17.1286	17.1657	19948460.0
2013-10-04 12:00:00	AAPL	Stock	17.1621	17.2061	17.1429	17.1807	20143424.0
2013-10-04 13:00:00	AAPL	Stock	17.1839	17.2	17.1611	17.1729	15852172.0
2013-10-04 14:00:00	AAPL	Stock	17.1754	17.2429	17.1661	17.2179	26678148.0
2013-10-04 15:00:00	AAPL	Stock	17.2193	17.2857	17.2114	17.2502	52552528.0
2013-10-04 16:00:00	AAPL	Stock	17.2511	17.2654	17.1952	17.2393	7692132.0
2013-10-04 17:00:00	AAPL	Stock	17.2393	17.2511	17.2154	17.2339	245784.0
2013-10-04 18:00:00	AAPL	Stock	17.2357	17.25	17.2321	17.25	62636.0
2013-10-04 19:00:00	AAPL	Stock	17.2454	17.255	17.2446	17.2529	113568.0
2013-10-04 04:00:00	MSFT	Stock	33.83	33.83	33.83	33.83	100.0
2013-10-04 06:00:00	MSFT	Stock	33.83	33.83	33.79	33.79	200.0
2013-10-04 07:00:00	MSFT	Stock	33.87	33.87	33.85	33.86	1890.0
2013-10-04 08:00:00	MSFT	Stock	33.83	33.87	33.8	33.85	209383.0
2013-10-04 09:00:00	MSFT	Stock	33.85	33.85	33.67	33.775	4048509.0
2013-10-04 10:00:00	MSFT	Stock	33.78	33.85	33.68	33.69	4986763.0
2013-10-04 11:00:00	MSFT	Stock	33.69	33.84	33.62	33.84	3197094.0
2013-10-04 12:00:00	MSFT	Stock	33.835	33.98	33.79	33.891	4315132.0
2013-10-04 13:00:00	MSFT	Stock	33.89	33.92	33.79	33.86	2542795.0
2013-10-04 14:00:00	MSFT	Stock	33.86	33.99	33.86	33.97	3065824.0
2013-10-04 15:00:00	MSFT	Stock	33.965	33.98	33.84	33.87	7153052.0
2013-10-04 16:00:00	MSFT	Stock	33.87	33.934	33.82	33.86	2163281.0
2013-10-04 17:00:00	MSFT	Stock	33.84	33.88	33.82	33.83	4301.0
2013-10-04 18:00:00	MSFT	Stock	33.83	33.907	33.82	33.82	4311.0
2013-10-04 19:00:00	MSFT	Stock	33.83	33.88	33.83	33.85	15301.0
2013-10-04 08:00:00	NVDA	Stock	0.3845	0.3845	0.3845	0.3845	517720.0
2013-10-04 09:00:00	NVDA	Stock	0.3835	0.39	0.383	0.3882	45499920.0
2013-10-04 10:00:00	NVDA	Stock	0.3882	0.3899	0.3878	0.3896	24819240.0
2013-10-04 11:00:00	NVDA	Stock	0.3896	0.3915	0.389	0.3905	38940720.0
2013-10-04 12:00:00	NVDA	Stock	0.3905	0.3915	0.3898	0.3909	19389360.0
2013-10-04 13:00:00	NVDA	Stock	0.3909	0.3918	0.3904	0.3915	22430800.0
2013-10-04 14:00:00	NVDA	Stock	0.3915	0.393	0.3908	0.3909	32474680.0
2013-10-04 15:00:00	NVDA	Stock	0.391	0.391	0.3893	0.3898	51302040.0
2013-10-04 16:00:00	NVDA	Stock	0.3898	0.391	0.3895	0.391	2267360.0
2013-10-04 17:00:00	NVDA	Stock	0.3878	0.3878	0.3878	0.3878	62000.0
2013-10-04 18:00:00	NVDA	Stock	0.3878	0.3878	0.3878	0.3878	336000.0
2013-10-04 19:00:00	NVDA	Stock	0.3873	0.3888	0.3873	0.3888	158000.0
2013-10-04 08:00:00	AMZN	Stock	15.75	15.7825	15.7	15.7825	280800.0
2013-10-04 09:00:00	AMZN	Stock	15.786	15.82	15.631	15.7265	7170300.0
2013-10-04 10:00:00	AMZN	Stock	15.719	15.834	15.687	15.8065	5939400.0
2013-10-04 11:00:00	AMZN	Stock	15.8005	15.8075	15.75	15.767	2314020.0
2013-10-04 12:00:00	AMZN	Stock	15.767	15.9	15.761	15.89	4502960.0
2013-10-04 13:00:00	AMZN	Stock	15.8885	15.93	15.8775	15.8918	2942960.0
2013-10-04 14:00:00	AMZN	Stock	15.8935	15.95	15.8775	15.9305	2899800.0

> showing 50 of 46,424 rows — these rows as CSV

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