PREVIEW / stock_1hour / 2012-01-30

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-01-30.parquet
  size:    943 KB
  rows:    44,819
  symbols: 3,529

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-01-30 04:00:00	AAPL	Stock	15.9218	15.925	15.8854	15.8854	79940.0
2012-01-30 05:00:00	AAPL	Stock	15.8964	15.9075	15.8929	15.9075	36400.0
2012-01-30 06:00:00	AAPL	Stock	15.9211	15.9214	15.9086	15.9086	58800.0
2012-01-30 07:00:00	AAPL	Stock	15.9214	15.9507	15.9029	15.9157	399140.0
2012-01-30 08:00:00	AAPL	Stock	15.9154	15.95	15.8864	15.8929	1477504.0
2012-01-30 09:00:00	AAPL	Stock	15.8932	16.0243	15.8911	15.9914	48124524.0
2012-01-30 10:00:00	AAPL	Stock	15.9896	16.1732	15.9825	16.1711	107461844.0
2012-01-30 11:00:00	AAPL	Stock	16.1711	16.1911	16.1293	16.145	45076892.0
2012-01-30 12:00:00	AAPL	Stock	16.1461	16.1964	16.1414	16.1657	38325392.0
2012-01-30 13:00:00	AAPL	Stock	16.1671	16.2107	16.1446	16.1811	33495868.0
2012-01-30 14:00:00	AAPL	Stock	16.1796	16.2007	16.17	16.1904	25490528.0
2012-01-30 15:00:00	AAPL	Stock	16.1896	16.1921	16.1364	16.1789	50630216.0
2012-01-30 16:00:00	AAPL	Stock	16.1789	16.1925	16.1152	16.1829	20170976.0
2012-01-30 17:00:00	AAPL	Stock	16.1793	16.1954	16.1786	16.1936	1035916.0
2012-01-30 18:00:00	AAPL	Stock	16.1925	16.195	16.1879	16.1936	147392.0
2012-01-30 19:00:00	AAPL	Stock	16.1946	16.2107	16.1929	16.2089	443156.0
2012-01-30 04:00:00	MSFT	Stock	29.15	29.15	29.0	29.0	200.0
2012-01-30 07:00:00	MSFT	Stock	29.03	29.05	29.0	29.0	4758.0
2012-01-30 08:00:00	MSFT	Stock	29.04	29.23	29.0	29.05	99822.0
2012-01-30 09:00:00	MSFT	Stock	29.05	29.135	28.83	29.125	4748927.0
2012-01-30 10:00:00	MSFT	Stock	29.12	29.22	28.94	29.145	9226223.0
2012-01-30 11:00:00	MSFT	Stock	29.14	29.41	29.14	29.37	5823807.0
2012-01-30 12:00:00	MSFT	Stock	29.37	29.5	29.364	29.495	4901329.0
2012-01-30 13:00:00	MSFT	Stock	29.5	29.58	29.41	29.565	4355218.0
2012-01-30 14:00:00	MSFT	Stock	29.56	29.62	29.52	29.53	6732215.0
2012-01-30 15:00:00	MSFT	Stock	29.53	29.61	29.48	29.61	10325377.0
2012-01-30 16:00:00	MSFT	Stock	29.59	29.61	29.23	29.59	3802374.0
2012-01-30 17:00:00	MSFT	Stock	29.61	29.61	29.59	29.59	136108.0
2012-01-30 18:00:00	MSFT	Stock	29.61	29.61	29.6	29.6	1400.0
2012-01-30 19:00:00	MSFT	Stock	29.63	29.65	29.63	29.65	7468.0
2012-01-30 08:00:00	NVDA	Stock	0.3658	0.3658	0.365	0.365	40000.0
2012-01-30 09:00:00	NVDA	Stock	0.3655	0.3665	0.3608	0.362	61339520.0
2012-01-30 10:00:00	NVDA	Stock	0.362	0.366	0.3616	0.3652	65174400.0
2012-01-30 11:00:00	NVDA	Stock	0.3655	0.3692	0.3652	0.3668	96884000.0
2012-01-30 12:00:00	NVDA	Stock	0.3668	0.367	0.3638	0.3652	29982600.0
2012-01-30 13:00:00	NVDA	Stock	0.3655	0.3692	0.365	0.3685	20716480.0
2012-01-30 14:00:00	NVDA	Stock	0.3683	0.3705	0.368	0.37	34108520.0
2012-01-30 15:00:00	NVDA	Stock	0.37	0.3718	0.369	0.3698	81605720.0
2012-01-30 16:00:00	NVDA	Stock	0.3699	0.3728	0.3642	0.3695	7642760.0
2012-01-30 17:00:00	NVDA	Stock	0.37	0.37	0.37	0.37	431720.0
2012-01-30 18:00:00	NVDA	Stock	0.369	0.3692	0.369	0.3692	20000.0
2012-01-30 19:00:00	NVDA	Stock	0.3692	0.371	0.3692	0.371	338880.0
2012-01-30 04:00:00	AMZN	Stock	9.75	9.75	9.7425	9.7425	4000.0
2012-01-30 07:00:00	AMZN	Stock	9.7805	9.7805	9.7155	9.7265	107460.0
2012-01-30 08:00:00	AMZN	Stock	9.745	9.745	9.695	9.695	288200.0
2012-01-30 09:00:00	AMZN	Stock	9.7	9.75	9.6166	9.6275	14955280.0
2012-01-30 10:00:00	AMZN	Stock	9.6284	9.633	9.5065	9.6035	26361720.0
2012-01-30 11:00:00	AMZN	Stock	9.607	9.655	9.5755	9.5845	12790020.0
2012-01-30 12:00:00	AMZN	Stock	9.5845	9.6085	9.519	9.5235	9621660.0
2012-01-30 13:00:00	AMZN	Stock	9.527	9.606	9.5175	9.5915	10137220.0

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

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