PREVIEW / stock_1hour / 2012-09-27

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-09-27.parquet
  size:    948 KB
  rows:    45,359
  symbols: 3,472

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
2012-09-27 04:00:00	AAPL	Stock	23.8554	23.8571	23.8464	23.8464	62104.0
2012-09-27 05:00:00	AAPL	Stock	23.85	23.85	23.8143	23.8214	130144.0
2012-09-27 06:00:00	AAPL	Stock	23.8214	23.8489	23.7254	23.7321	534044.0
2012-09-27 07:00:00	AAPL	Stock	23.7264	23.8375	23.6786	23.7786	1580264.0
2012-09-27 08:00:00	AAPL	Stock	23.7782	23.8679	23.7493	23.7679	3750236.0
2012-09-27 09:00:00	AAPL	Stock	23.7611	23.7954	23.5839	23.6918	100877840.0
2012-09-27 10:00:00	AAPL	Stock	23.6832	24.0089	23.6607	23.9361	117972176.0
2012-09-27 11:00:00	AAPL	Stock	23.9362	24.1393	23.9018	24.1311	70431536.0
2012-09-27 12:00:00	AAPL	Stock	24.1307	24.2807	24.1286	24.2275	98893032.0
2012-09-27 13:00:00	AAPL	Stock	24.2289	24.2964	24.1811	24.2096	46206076.0
2012-09-27 14:00:00	AAPL	Stock	24.2132	24.3632	24.2021	24.2498	53903528.0
2012-09-27 15:00:00	AAPL	Stock	24.2511	24.3396	24.2175	24.3364	79351356.0
2012-09-27 16:00:00	AAPL	Stock	24.3364	24.3725	23.6961	24.3714	6899788.0
2012-09-27 17:00:00	AAPL	Stock	24.3732	24.3886	24.3361	24.3875	1218280.0
2012-09-27 18:00:00	AAPL	Stock	24.3804	24.3961	24.3693	24.3807	387772.0
2012-09-27 19:00:00	AAPL	Stock	24.3857	24.4196	24.3754	24.4161	439572.0
2012-09-27 07:00:00	MSFT	Stock	30.26	30.26	30.18	30.19	3691.0
2012-09-27 08:00:00	MSFT	Stock	30.18	30.33	30.15	30.23	30684.0
2012-09-27 09:00:00	MSFT	Stock	30.23	30.4	29.97	30.02	6932606.0
2012-09-27 10:00:00	MSFT	Stock	30.02	30.07	29.89	30.005	9301191.0
2012-09-27 11:00:00	MSFT	Stock	30.0	30.05	29.95	30.05	5062410.0
2012-09-27 12:00:00	MSFT	Stock	30.05	30.29	30.03	30.155	6507114.0
2012-09-27 13:00:00	MSFT	Stock	30.16	30.35	30.12	30.285	3190076.0
2012-09-27 14:00:00	MSFT	Stock	30.28	30.34	30.24	30.26	3351063.0
2012-09-27 15:00:00	MSFT	Stock	30.26	30.3	30.15	30.19	8055722.0
2012-09-27 16:00:00	MSFT	Stock	30.2	30.288	30.0	30.16	1934451.0
2012-09-27 17:00:00	MSFT	Stock	30.2	30.2	30.2	30.2	132169.0
2012-09-27 18:00:00	MSFT	Stock	30.17	30.17	30.17	30.17	400.0
2012-09-27 19:00:00	MSFT	Stock	30.2	30.21	30.2	30.21	700.0
2012-09-27 06:00:00	NVDA	Stock	0.331	0.331	0.331	0.331	40000.0
2012-09-27 08:00:00	NVDA	Stock	0.3325	0.3325	0.3325	0.3325	50000.0
2012-09-27 09:00:00	NVDA	Stock	0.3328	0.333	0.3275	0.3298	58890200.0
2012-09-27 10:00:00	NVDA	Stock	0.3295	0.3313	0.3278	0.3288	122321040.0
2012-09-27 11:00:00	NVDA	Stock	0.329	0.33	0.328	0.33	56253120.0
2012-09-27 12:00:00	NVDA	Stock	0.3298	0.332	0.3295	0.33	65371440.0
2012-09-27 13:00:00	NVDA	Stock	0.3303	0.3308	0.3293	0.3301	73683640.0
2012-09-27 14:00:00	NVDA	Stock	0.3303	0.332	0.33	0.3318	74285840.0
2012-09-27 15:00:00	NVDA	Stock	0.3318	0.3325	0.3308	0.3318	91218640.0
2012-09-27 16:00:00	NVDA	Stock	0.3315	0.3322	0.3303	0.3322	12969160.0
2012-09-27 17:00:00	NVDA	Stock	0.3315	0.3315	0.3288	0.3288	449400.0
2012-09-27 19:00:00	NVDA	Stock	0.3325	0.3325	0.3325	0.3325	4000.0
2012-09-27 08:00:00	AMZN	Stock	12.5505	12.575	12.545	12.565	223220.0
2012-09-27 09:00:00	AMZN	Stock	12.565	12.7055	12.5255	12.6625	10801120.0
2012-09-27 10:00:00	AMZN	Stock	12.651	12.7785	12.635	12.7135	13699260.0
2012-09-27 11:00:00	AMZN	Stock	12.7145	12.742	12.6705	12.7406	7758300.0
2012-09-27 12:00:00	AMZN	Stock	12.7395	12.7915	12.727	12.784	5491160.0
2012-09-27 13:00:00	AMZN	Stock	12.7845	12.8545	12.778	12.8245	7803080.0
2012-09-27 14:00:00	AMZN	Stock	12.827	12.856	12.8075	12.816	6095620.0
2012-09-27 15:00:00	AMZN	Stock	12.817	12.87	12.801	12.832	12789320.0
2012-09-27 16:00:00	AMZN	Stock	12.8355	12.8415	12.7154	12.8295	2635800.0

> showing 50 of 45,359 rows — these rows as CSV

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