PREVIEW / stock_1hour / 2011-05-13

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-05-13.parquet
  size:    955 KB
  rows:    45,649
  symbols: 3,566

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
2011-05-13 04:00:00	AAPL	Stock	12.3929	12.3929	12.375	12.375	8400.0
2011-05-13 05:00:00	AAPL	Stock	12.3607	12.3643	12.3607	12.3643	59640.0
2011-05-13 06:00:00	AAPL	Stock	12.3657	12.3896	12.3657	12.3896	11200.0
2011-05-13 07:00:00	AAPL	Stock	12.3764	12.3861	12.3693	12.375	108248.0
2011-05-13 08:00:00	AAPL	Stock	12.3818	12.3825	12.3429	12.3429	1222508.0
2011-05-13 09:00:00	AAPL	Stock	12.3511	12.3661	12.2811	12.2868	39280220.0
2011-05-13 10:00:00	AAPL	Stock	12.2843	12.3275	12.2754	12.2946	38845072.0
2011-05-13 11:00:00	AAPL	Stock	12.2925	12.2936	12.225	12.253	64161972.0
2011-05-13 12:00:00	AAPL	Stock	12.2521	12.265	12.2232	12.2421	35240968.0
2011-05-13 13:00:00	AAPL	Stock	12.2425	12.2732	12.2332	12.2489	22646848.0
2011-05-13 14:00:00	AAPL	Stock	12.2488	12.2725	12.2339	12.2414	26629204.0
2011-05-13 15:00:00	AAPL	Stock	12.2414	12.2536	12.1554	12.16	86487912.0
2011-05-13 16:00:00	AAPL	Stock	12.1607	12.2566	12.1489	12.1607	10136896.0
2011-05-13 17:00:00	AAPL	Stock	12.1589	12.1614	12.15	12.1554	376460.0
2011-05-13 18:00:00	AAPL	Stock	12.1564	12.1639	12.1546	12.1639	213332.0
2011-05-13 19:00:00	AAPL	Stock	12.1643	12.1643	12.1561	12.1607	110992.0
2011-05-13 04:00:00	MSFT	Stock	25.38	25.38	25.38	25.38	200.0
2011-05-13 06:00:00	MSFT	Stock	25.35	25.35	25.35	25.35	100.0
2011-05-13 07:00:00	MSFT	Stock	25.37	25.39	25.34	25.39	2800.0
2011-05-13 08:00:00	MSFT	Stock	25.34	25.36	25.28	25.34	27778.0
2011-05-13 09:00:00	MSFT	Stock	25.33	25.38	25.12	25.13	4542014.0
2011-05-13 10:00:00	MSFT	Stock	25.12	25.24	25.05	25.185	10862175.0
2011-05-13 11:00:00	MSFT	Stock	25.185	25.21	25.01	25.025	11654428.0
2011-05-13 12:00:00	MSFT	Stock	25.03	25.05	24.95	24.99	9996233.0
2011-05-13 13:00:00	MSFT	Stock	24.99	25.05	24.98	25.05	4695627.0
2011-05-13 14:00:00	MSFT	Stock	25.05	25.09	25.02	25.09	8532211.0
2011-05-13 15:00:00	MSFT	Stock	25.09	25.11	25.0	25.02	12761727.0
2011-05-13 16:00:00	MSFT	Stock	25.03	25.32	24.98	25.0	2794336.0
2011-05-13 17:00:00	MSFT	Stock	25.0	25.03	24.99	25.02	110300.0
2011-05-13 18:00:00	MSFT	Stock	25.03	25.03	25.0	25.03	33454.0
2011-05-13 19:00:00	MSFT	Stock	25.04	25.05	25.0	25.02	5558.0
2011-05-13 04:00:00	NVDA	Stock	0.4985	0.4985	0.4985	0.4985	8000.0
2011-05-13 06:00:00	NVDA	Stock	0.4988	0.5	0.4985	0.5	100000.0
2011-05-13 07:00:00	NVDA	Stock	0.4952	0.4963	0.4822	0.485	3754800.0
2011-05-13 08:00:00	NVDA	Stock	0.4838	0.485	0.4725	0.4778	37507400.0
2011-05-13 09:00:00	NVDA	Stock	0.4778	0.4835	0.4668	0.4755	581431760.0
2011-05-13 10:00:00	NVDA	Stock	0.4758	0.479	0.4698	0.4723	456685400.0
2011-05-13 11:00:00	NVDA	Stock	0.4723	0.4725	0.4633	0.4655	270864040.0
2011-05-13 12:00:00	NVDA	Stock	0.4652	0.4702	0.4628	0.464	185534680.0
2011-05-13 13:00:00	NVDA	Stock	0.464	0.4673	0.4612	0.467	123145160.0
2011-05-13 14:00:00	NVDA	Stock	0.467	0.469	0.4635	0.4638	92791280.0
2011-05-13 15:00:00	NVDA	Stock	0.4636	0.4658	0.453	0.4565	247985600.0
2011-05-13 16:00:00	NVDA	Stock	0.4562	0.4688	0.455	0.4562	10754960.0
2011-05-13 17:00:00	NVDA	Stock	0.4562	0.4565	0.455	0.455	809920.0
2011-05-13 18:00:00	NVDA	Stock	0.4545	0.456	0.454	0.4558	431440.0
2011-05-13 19:00:00	NVDA	Stock	0.4558	0.4562	0.455	0.4552	133600.0
2011-05-13 07:00:00	AMZN	Stock	10.307	10.307	10.307	10.307	4000.0
2011-05-13 08:00:00	AMZN	Stock	10.3195	10.32	10.255	10.269	234600.0
2011-05-13 09:00:00	AMZN	Stock	10.274	10.3195	10.2251	10.2745	12606640.0
2011-05-13 10:00:00	AMZN	Stock	10.2805	10.3135	10.254	10.256	11582780.0

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

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