PREVIEW / stock_1hour / 2012-04-25

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-04-25.parquet
  size:    947 KB
  rows:    45,049
  symbols: 3,537

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-04-25 04:00:00	AAPL	Stock	21.5643	21.8796	21.5643	21.8686	1511916.0
2012-04-25 05:00:00	AAPL	Stock	21.8686	21.8746	21.8468	21.8746	352184.0
2012-04-25 06:00:00	AAPL	Stock	21.8661	22.0	21.8446	21.8571	1841812.0
2012-04-25 07:00:00	AAPL	Stock	21.8486	21.8911	21.7189	21.8304	7079296.0
2012-04-25 08:00:00	AAPL	Stock	21.8325	22.0793	21.7589	21.845	35125636.0
2012-04-25 09:00:00	AAPL	Stock	21.8554	22.0714	21.6543	22.0471	309194732.0
2012-04-25 10:00:00	AAPL	Stock	22.045	22.0661	21.6964	21.8031	185984120.0
2012-04-25 11:00:00	AAPL	Stock	21.8011	21.8664	21.7693	21.8096	67987668.0
2012-04-25 12:00:00	AAPL	Stock	21.8116	21.8193	21.6571	21.7589	82024712.0
2012-04-25 13:00:00	AAPL	Stock	21.7589	21.8571	21.6989	21.7857	60178552.0
2012-04-25 14:00:00	AAPL	Stock	21.7857	21.8246	21.7357	21.7818	45355716.0
2012-04-25 15:00:00	AAPL	Stock	21.7836	21.84	21.7521	21.78	80249344.0
2012-04-25 16:00:00	AAPL	Stock	21.78	22.0232	21.7761	21.8036	16058868.0
2012-04-25 17:00:00	AAPL	Stock	21.8061	21.8393	21.8043	21.8271	1273944.0
2012-04-25 18:00:00	AAPL	Stock	21.8282	21.8282	21.8125	21.8214	463316.0
2012-04-25 19:00:00	AAPL	Stock	21.8243	21.8454	21.8075	21.8114	704312.0
2012-04-25 05:00:00	MSFT	Stock	31.96	32.05	31.96	32.05	1300.0
2012-04-25 06:00:00	MSFT	Stock	32.1	32.2	32.1	32.11	5600.0
2012-04-25 07:00:00	MSFT	Stock	32.15	32.15	32.05	32.05	10200.0
2012-04-25 08:00:00	MSFT	Stock	32.05	32.05	31.91	31.92	61730.0
2012-04-25 09:00:00	MSFT	Stock	31.92	32.18	31.87	32.135	8029810.0
2012-04-25 10:00:00	MSFT	Stock	32.14	32.18	32.065	32.11	7415792.0
2012-04-25 11:00:00	MSFT	Stock	32.11	32.18	32.08	32.145	5310046.0
2012-04-25 12:00:00	MSFT	Stock	32.145	32.27	32.14	32.245	5447511.0
2012-04-25 13:00:00	MSFT	Stock	32.245	32.32	32.18	32.205	5494782.0
2012-04-25 14:00:00	MSFT	Stock	32.2	32.24	32.09	32.212	6738301.0
2012-04-25 15:00:00	MSFT	Stock	32.215	32.3	32.18	32.2	13872820.0
2012-04-25 16:00:00	MSFT	Stock	32.2	32.274	31.939	32.2	8657664.0
2012-04-25 17:00:00	MSFT	Stock	32.18	32.18	32.18	32.18	200.0
2012-04-25 18:00:00	MSFT	Stock	32.22	32.22	32.22	32.22	100.0
2012-04-25 19:00:00	MSFT	Stock	32.22	32.22	32.21	32.21	1400.0
2012-04-25 08:00:00	NVDA	Stock	0.3263	0.3263	0.325	0.3263	386280.0
2012-04-25 09:00:00	NVDA	Stock	0.326	0.3295	0.325	0.3283	75762280.0
2012-04-25 10:00:00	NVDA	Stock	0.3284	0.3285	0.3255	0.3259	97083200.0
2012-04-25 11:00:00	NVDA	Stock	0.3259	0.3263	0.32	0.3203	96218480.0
2012-04-25 12:00:00	NVDA	Stock	0.3201	0.3218	0.3193	0.3218	95797800.0
2012-04-25 13:00:00	NVDA	Stock	0.3218	0.3258	0.321	0.3258	76006320.0
2012-04-25 14:00:00	NVDA	Stock	0.3255	0.3283	0.3253	0.3265	116750960.0
2012-04-25 15:00:00	NVDA	Stock	0.3265	0.328	0.3263	0.3268	145439360.0
2012-04-25 16:00:00	NVDA	Stock	0.3268	0.3283	0.3203	0.3268	22351320.0
2012-04-25 17:00:00	NVDA	Stock	0.3268	0.3268	0.3265	0.3265	36000.0
2012-04-25 18:00:00	NVDA	Stock	0.3263	0.3263	0.3263	0.3263	20000.0
2012-04-25 19:00:00	NVDA	Stock	0.327	0.327	0.327	0.327	44000.0
2012-04-25 07:00:00	AMZN	Stock	9.6325	9.675	9.625	9.625	67020.0
2012-04-25 08:00:00	AMZN	Stock	9.6175	9.661	9.59	9.5995	164580.0
2012-04-25 09:00:00	AMZN	Stock	9.599	9.7195	9.5275	9.685	13133060.0
2012-04-25 10:00:00	AMZN	Stock	9.685	9.74	9.6606	9.662	13643340.0
2012-04-25 11:00:00	AMZN	Stock	9.665	9.7055	9.6385	9.6985	8927260.0
2012-04-25 12:00:00	AMZN	Stock	9.701	9.712	9.6635	9.6905	5415320.0
2012-04-25 13:00:00	AMZN	Stock	9.6885	9.692	9.66	9.6715	6616020.0

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

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