PREVIEW / stock_1hour / 2012-03-20

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-03-20.parquet
  size:    952 KB
  rows:    45,241
  symbols: 3,541

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-03-20 04:00:00	AAPL	Stock	21.6225	21.6286	21.5696	21.5925	247156.0
2012-03-20 05:00:00	AAPL	Stock	21.5893	21.5964	21.5107	21.5179	188776.0
2012-03-20 06:00:00	AAPL	Stock	21.5057	21.5057	21.3786	21.3929	264292.0
2012-03-20 07:00:00	AAPL	Stock	21.4107	21.4857	21.3682	21.3682	1871828.0
2012-03-20 08:00:00	AAPL	Stock	21.375	21.4554	21.3071	21.3686	7974652.0
2012-03-20 09:00:00	AAPL	Stock	21.3671	21.4246	20.7857	21.2207	129243100.0
2012-03-20 10:00:00	AAPL	Stock	21.2204	21.3464	21.1243	21.2904	123047736.0
2012-03-20 11:00:00	AAPL	Stock	21.2886	21.3268	21.2357	21.3054	77743680.0
2012-03-20 12:00:00	AAPL	Stock	21.3015	21.3839	21.2786	21.3629	49732872.0
2012-03-20 13:00:00	AAPL	Stock	21.3629	21.5571	21.3571	21.5175	107863840.0
2012-03-20 14:00:00	AAPL	Stock	21.5179	21.5536	21.4464	21.5196	100782360.0
2012-03-20 15:00:00	AAPL	Stock	21.5193	21.675	21.5179	21.6414	157632552.0
2012-03-20 16:00:00	AAPL	Stock	21.6414	21.6489	21.4173	21.6161	23152500.0
2012-03-20 17:00:00	AAPL	Stock	21.6132	21.6464	21.321	21.6429	3095988.0
2012-03-20 18:00:00	AAPL	Stock	21.6425	21.6425	21.6186	21.6207	509544.0
2012-03-20 19:00:00	AAPL	Stock	21.6207	21.625	21.5725	21.6071	1158052.0
2012-03-20 07:00:00	MSFT	Stock	32.05	32.07	32.05	32.05	5300.0
2012-03-20 08:00:00	MSFT	Stock	32.04	32.13	32.04	32.09	34193.0
2012-03-20 09:00:00	MSFT	Stock	32.07	32.17	31.79	31.89	6049055.0
2012-03-20 10:00:00	MSFT	Stock	31.895	31.97	31.82	31.85	6572880.0
2012-03-20 11:00:00	MSFT	Stock	31.85	32.12	31.8	31.875	5875197.0
2012-03-20 12:00:00	MSFT	Stock	31.872	31.91	31.74	31.82	4146789.0
2012-03-20 13:00:00	MSFT	Stock	31.82	31.88	31.76	31.81	4886448.0
2012-03-20 14:00:00	MSFT	Stock	31.81	31.92	31.8	31.865	3679221.0
2012-03-20 15:00:00	MSFT	Stock	31.87	31.99	31.86	31.99	7621802.0
2012-03-20 16:00:00	MSFT	Stock	31.99	32.07	31.812	32.02	2078241.0
2012-03-20 17:00:00	MSFT	Stock	32.2	32.2	31.93	31.93	13513.0
2012-03-20 18:00:00	MSFT	Stock	31.94	31.95	31.93	31.93	23282.0
2012-03-20 19:00:00	MSFT	Stock	31.93	31.95	31.92	31.94	3740.0
2012-03-20 08:00:00	NVDA	Stock	0.365	0.366	0.362	0.362	251600.0
2012-03-20 09:00:00	NVDA	Stock	0.3628	0.364	0.357	0.3585	56260760.0
2012-03-20 10:00:00	NVDA	Stock	0.3585	0.3605	0.3568	0.3602	71081440.0
2012-03-20 11:00:00	NVDA	Stock	0.3605	0.3612	0.3582	0.3585	51927400.0
2012-03-20 12:00:00	NVDA	Stock	0.3585	0.3592	0.3571	0.3575	55248880.0
2012-03-20 13:00:00	NVDA	Stock	0.3572	0.3585	0.3568	0.3572	55526520.0
2012-03-20 14:00:00	NVDA	Stock	0.3572	0.3592	0.3568	0.3592	47068720.0
2012-03-20 15:00:00	NVDA	Stock	0.3592	0.3605	0.3592	0.36	89208320.0
2012-03-20 16:00:00	NVDA	Stock	0.36	0.3608	0.359	0.3598	17063880.0
2012-03-20 17:00:00	NVDA	Stock	0.366	0.366	0.3592	0.36	5394400.0
2012-03-20 18:00:00	NVDA	Stock	0.3608	0.3608	0.3608	0.3608	4120.0
2012-03-20 19:00:00	NVDA	Stock	0.3608	0.3608	0.36	0.36	31880.0
2012-03-20 05:00:00	AMZN	Stock	9.225	9.225	9.1865	9.1865	8000.0
2012-03-20 06:00:00	AMZN	Stock	9.194	9.194	9.194	9.194	4000.0
2012-03-20 08:00:00	AMZN	Stock	9.209	9.227	9.195	9.2215	129680.0
2012-03-20 09:00:00	AMZN	Stock	9.2065	9.2575	9.144	9.166	10369800.0
2012-03-20 10:00:00	AMZN	Stock	9.1695	9.2405	9.156	9.228	11314040.0
2012-03-20 11:00:00	AMZN	Stock	9.2295	9.285	9.214	9.2831	10312140.0
2012-03-20 12:00:00	AMZN	Stock	9.283	9.5	9.2705	9.4765	32935260.0
2012-03-20 13:00:00	AMZN	Stock	9.4755	9.645	9.4625	9.6445	34313640.0
2012-03-20 14:00:00	AMZN	Stock	9.6439	9.716	9.635	9.7009	43948300.0

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

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