PREVIEW / stock_1hour / 2012-09-19

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-09-19.parquet
  size:    940 KB
  rows:    44,378
  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-19 04:00:00	AAPL	Stock	25.1429	25.1429	25.0957	25.1057	99316.0
2012-09-19 05:00:00	AAPL	Stock	25.0714	25.0989	25.0714	25.0911	28700.0
2012-09-19 06:00:00	AAPL	Stock	25.0982	25.0982	25.0857	25.0857	14224.0
2012-09-19 07:00:00	AAPL	Stock	25.0929	25.0929	25.0286	25.0286	422240.0
2012-09-19 08:00:00	AAPL	Stock	25.0343	25.0714	24.9929	25.0532	2485560.0
2012-09-19 09:00:00	AAPL	Stock	25.0532	25.125	24.9846	25.0644	62443052.0
2012-09-19 10:00:00	AAPL	Stock	25.0714	25.0961	25.0039	25.0482	56697732.0
2012-09-19 11:00:00	AAPL	Stock	25.0481	25.0671	24.9911	25.0329	35470456.0
2012-09-19 12:00:00	AAPL	Stock	25.035	25.0857	25.0282	25.0518	26033056.0
2012-09-19 13:00:00	AAPL	Stock	25.0563	25.0666	25.0357	25.0661	16783144.0
2012-09-19 14:00:00	AAPL	Stock	25.0654	25.1171	25.0639	25.1149	32744796.0
2012-09-19 15:00:00	AAPL	Stock	25.113	25.1425	25.0621	25.0776	58527140.0
2012-09-19 16:00:00	AAPL	Stock	25.075	25.1267	25.0464	25.0536	24167556.0
2012-09-19 17:00:00	AAPL	Stock	25.0572	25.075	25.0411	25.0443	450128.0
2012-09-19 18:00:00	AAPL	Stock	25.0464	25.0532	25.0393	25.0457	171612.0
2012-09-19 19:00:00	AAPL	Stock	25.0457	25.0604	25.0457	25.06	269080.0
2012-09-19 07:00:00	MSFT	Stock	31.15	31.19	31.1	31.1	3475.0
2012-09-19 08:00:00	MSFT	Stock	31.15	31.15	31.03	31.07	75968.0
2012-09-19 09:00:00	MSFT	Stock	31.08	31.18	31.04	31.1	4753964.0
2012-09-19 10:00:00	MSFT	Stock	31.09	31.18	31.08	31.12	7100508.0
2012-09-19 11:00:00	MSFT	Stock	31.12	31.19	31.1	31.14	5722285.0
2012-09-19 12:00:00	MSFT	Stock	31.13	31.18	31.105	31.146	3057741.0
2012-09-19 13:00:00	MSFT	Stock	31.145	31.16	31.1	31.13	2390075.0
2012-09-19 14:00:00	MSFT	Stock	31.13	31.16	31.12	31.13	3203928.0
2012-09-19 15:00:00	MSFT	Stock	31.138	31.14	31.04	31.06	12922439.0
2012-09-19 16:00:00	MSFT	Stock	31.06	31.17	30.97	31.052	7062751.0
2012-09-19 17:00:00	MSFT	Stock	31.03	31.03	31.01	31.01	5377.0
2012-09-19 18:00:00	MSFT	Stock	31.0	31.0	30.95	31.0	6635.0
2012-09-19 19:00:00	MSFT	Stock	30.99	31.03	30.99	31.03	4100.0
2012-09-19 08:00:00	NVDA	Stock	0.3388	0.3388	0.3388	0.3388	4000.0
2012-09-19 09:00:00	NVDA	Stock	0.3388	0.3426	0.3355	0.3425	38380040.0
2012-09-19 10:00:00	NVDA	Stock	0.3428	0.3451	0.3398	0.3425	91336600.0
2012-09-19 11:00:00	NVDA	Stock	0.3422	0.3475	0.3418	0.3461	79566160.0
2012-09-19 12:00:00	NVDA	Stock	0.346	0.3468	0.3448	0.3464	53111240.0
2012-09-19 13:00:00	NVDA	Stock	0.3462	0.3465	0.3433	0.344	24006840.0
2012-09-19 14:00:00	NVDA	Stock	0.3439	0.3448	0.3433	0.344	35271080.0
2012-09-19 15:00:00	NVDA	Stock	0.3438	0.344	0.3425	0.343	48635280.0
2012-09-19 16:00:00	NVDA	Stock	0.3428	0.3435	0.339	0.3433	8632280.0
2012-09-19 17:00:00	NVDA	Stock	0.3447	0.3447	0.3447	0.3447	68876000.0
2012-09-19 19:00:00	NVDA	Stock	0.3422	0.3422	0.3422	0.3422	40000.0
2012-09-19 04:00:00	AMZN	Stock	13.0	13.0	12.99	12.99	20000.0
2012-09-19 05:00:00	AMZN	Stock	12.99	12.99	12.99	12.99	2000.0
2012-09-19 07:00:00	AMZN	Stock	12.95	12.95	12.95	12.95	4000.0
2012-09-19 08:00:00	AMZN	Stock	12.9495	12.9625	12.942	12.96	80740.0
2012-09-19 09:00:00	AMZN	Stock	12.9515	13.0395	12.9265	13.0155	7550000.0
2012-09-19 10:00:00	AMZN	Stock	13.0155	13.05	12.9725	13.0208	8362200.0
2012-09-19 11:00:00	AMZN	Stock	13.0215	13.093	13.015	13.0372	7515860.0
2012-09-19 12:00:00	AMZN	Stock	13.0372	13.093	13.0325	13.0822	5210820.0
2012-09-19 13:00:00	AMZN	Stock	13.082	13.0835	13.0448	13.0565	4416340.0
2012-09-19 14:00:00	AMZN	Stock	13.0565	13.1155	13.051	13.1015	4468240.0

> showing 50 of 44,378 rows — these rows as CSV

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