PREVIEW / stock_1hour / 2013-09-27

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-09-27.parquet
  size:    999 KB
  rows:    46,561
  symbols: 3,523

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-09-27 04:00:00	AAPL	Stock	17.3846	17.3846	17.3846	17.3846	2800.0
2013-09-27 05:00:00	AAPL	Stock	17.3714	17.3807	17.3643	17.3807	14000.0
2013-09-27 06:00:00	AAPL	Stock	17.3393	17.3489	17.3221	17.3393	30800.0
2013-09-27 07:00:00	AAPL	Stock	17.3375	17.3679	17.2932	17.3275	412468.0
2013-09-27 08:00:00	AAPL	Stock	17.3279	17.3786	17.2714	17.3075	1621620.0
2013-09-27 09:00:00	AAPL	Stock	17.3139	17.365	17.1955	17.2339	42650300.0
2013-09-27 10:00:00	AAPL	Stock	17.2339	17.2943	17.2111	17.2396	35957684.0
2013-09-27 11:00:00	AAPL	Stock	17.2396	17.2532	17.2129	17.2171	18675412.0
2013-09-27 12:00:00	AAPL	Stock	17.2168	17.2643	17.2129	17.2475	16307900.0
2013-09-27 13:00:00	AAPL	Stock	17.2471	17.2618	17.2229	17.2293	13476232.0
2013-09-27 14:00:00	AAPL	Stock	17.2311	17.2311	17.1839	17.1865	21930076.0
2013-09-27 15:00:00	AAPL	Stock	17.1843	17.2407	17.1686	17.24	43466220.0
2013-09-27 16:00:00	AAPL	Stock	17.2379	17.2539	17.2224	17.2446	13507788.0
2013-09-27 17:00:00	AAPL	Stock	17.2429	17.2489	17.2411	17.2464	645092.0
2013-09-27 18:00:00	AAPL	Stock	17.2411	17.2479	17.2404	17.2464	165984.0
2013-09-27 19:00:00	AAPL	Stock	17.2432	17.25	17.2425	17.2464	174720.0
2013-09-27 05:00:00	MSFT	Stock	32.93	32.93	32.86	32.86	400.0
2013-09-27 06:00:00	MSFT	Stock	32.86	32.93	32.86	32.93	2200.0
2013-09-27 07:00:00	MSFT	Stock	32.92	32.93	32.92	32.93	1900.0
2013-09-27 08:00:00	MSFT	Stock	32.93	33.04	32.92	32.95	25489.0
2013-09-27 09:00:00	MSFT	Stock	32.92	33.25	32.77	33.12	8009352.0
2013-09-27 10:00:00	MSFT	Stock	33.12	33.65	33.08	33.59	11739227.0
2013-09-27 11:00:00	MSFT	Stock	33.583	33.73	33.46	33.715	8380438.0
2013-09-27 12:00:00	MSFT	Stock	33.71	33.75	33.64	33.66	5257000.0
2013-09-27 13:00:00	MSFT	Stock	33.655	33.68	33.44	33.45	4317864.0
2013-09-27 14:00:00	MSFT	Stock	33.44	33.45	33.28	33.4	3298283.0
2013-09-27 15:00:00	MSFT	Stock	33.4	33.405	33.22	33.29	8574144.0
2013-09-27 16:00:00	MSFT	Stock	33.29	33.469	33.06	33.29	2327219.0
2013-09-27 17:00:00	MSFT	Stock	32.77	33.68	32.77	33.28	13990.0
2013-09-27 18:00:00	MSFT	Stock	33.29	33.3	33.29	33.3	12741.0
2013-09-27 19:00:00	MSFT	Stock	33.3	33.32	33.3	33.3	2037.0
2013-09-27 08:00:00	NVDA	Stock	0.3913	0.3913	0.3873	0.3873	38000.0
2013-09-27 09:00:00	NVDA	Stock	0.3898	0.392	0.3882	0.391	19760640.0
2013-09-27 10:00:00	NVDA	Stock	0.391	0.3913	0.3895	0.3901	24444960.0
2013-09-27 11:00:00	NVDA	Stock	0.3901	0.3905	0.3895	0.3899	20931160.0
2013-09-27 12:00:00	NVDA	Stock	0.3898	0.39	0.3891	0.3895	8381200.0
2013-09-27 13:00:00	NVDA	Stock	0.3895	0.3898	0.389	0.389	13285160.0
2013-09-27 14:00:00	NVDA	Stock	0.389	0.3895	0.3873	0.3885	22911200.0
2013-09-27 15:00:00	NVDA	Stock	0.3888	0.39	0.3885	0.3893	31307880.0
2013-09-27 16:00:00	NVDA	Stock	0.3895	0.3902	0.389	0.3898	2003280.0
2013-09-27 17:00:00	NVDA	Stock	0.3895	0.3895	0.3895	0.3895	30760.0
2013-09-27 18:00:00	NVDA	Stock	0.3915	0.3915	0.3915	0.3915	12000.0
2013-09-27 04:00:00	AMZN	Stock	15.87	15.87	15.87	15.87	2000.0
2013-09-27 05:00:00	AMZN	Stock	15.8725	15.8725	15.865	15.865	4000.0
2013-09-27 07:00:00	AMZN	Stock	15.84	15.84	15.84	15.84	2000.0
2013-09-27 08:00:00	AMZN	Stock	15.85	15.85	15.82	15.835	42000.0
2013-09-27 09:00:00	AMZN	Stock	15.83	15.8605	15.6675	15.687	8540160.0
2013-09-27 10:00:00	AMZN	Stock	15.693	15.823	15.675	15.751	5921020.0
2013-09-27 11:00:00	AMZN	Stock	15.75	15.77	15.702	15.7577	3119260.0
2013-09-27 12:00:00	AMZN	Stock	15.75	15.758	15.7262	15.7365	1131640.0

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

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