PREVIEW / stock_1hour / 2013-05-07

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-05-07.parquet
  size:    998 KB
  rows:    46,202
  symbols: 3,510

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
2013-05-07 04:00:00	AAPL	Stock	16.5239	16.5239	16.4957	16.5071	58408.0
2013-05-07 05:00:00	AAPL	Stock	16.5139	16.5168	16.5139	16.5168	11200.0
2013-05-07 06:00:00	AAPL	Stock	16.5232	16.5496	16.52	16.5232	29652.0
2013-05-07 07:00:00	AAPL	Stock	16.5232	16.6071	16.5229	16.5689	1072680.0
2013-05-07 08:00:00	AAPL	Stock	16.5671	16.6175	16.5218	16.6	3784032.0
2013-05-07 09:00:00	AAPL	Stock	16.6025	16.6339	16.4839	16.5179	95987416.0
2013-05-07 10:00:00	AAPL	Stock	16.5171	16.5196	16.2036	16.3018	143587052.0
2013-05-07 11:00:00	AAPL	Stock	16.3018	16.4068	16.2893	16.3061	59236324.0
2013-05-07 12:00:00	AAPL	Stock	16.3036	16.3781	16.2921	16.3639	32992232.0
2013-05-07 13:00:00	AAPL	Stock	16.3639	16.3879	16.3171	16.3818	25638564.0
2013-05-07 14:00:00	AAPL	Stock	16.3821	16.4389	16.3689	16.417	46238836.0
2013-05-07 15:00:00	AAPL	Stock	16.4143	16.4171	16.3396	16.3818	50473696.0
2013-05-07 16:00:00	AAPL	Stock	16.3818	16.4004	16.3754	16.3996	9170028.0
2013-05-07 17:00:00	AAPL	Stock	16.395	16.4196	16.3807	16.4143	382256.0
2013-05-07 18:00:00	AAPL	Stock	16.4111	16.4164	16.3746	16.3746	267904.0
2013-05-07 19:00:00	AAPL	Stock	16.3732	16.3746	16.3571	16.3711	330960.0
2013-05-07 07:00:00	MSFT	Stock	33.77	33.77	33.6	33.68	4825.0
2013-05-07 08:00:00	MSFT	Stock	33.72	33.97	33.59	33.7	42153.0
2013-05-07 09:00:00	MSFT	Stock	33.7	33.79	33.55	33.64	5677832.0
2013-05-07 10:00:00	MSFT	Stock	33.64	33.65	33.34	33.382	7539533.0
2013-05-07 11:00:00	MSFT	Stock	33.385	33.52	33.27	33.33	5376433.0
2013-05-07 12:00:00	MSFT	Stock	33.325	33.38	33.24	33.355	4316411.0
2013-05-07 13:00:00	MSFT	Stock	33.35	33.42	33.29	33.383	5519899.0
2013-05-07 14:00:00	MSFT	Stock	33.389	33.4	33.32	33.362	3507541.0
2013-05-07 15:00:00	MSFT	Stock	33.37	33.42	33.26	33.3	7711947.0
2013-05-07 16:00:00	MSFT	Stock	33.31	33.75	33.249	33.3	1720129.0
2013-05-07 17:00:00	MSFT	Stock	33.31	33.32	33.26	33.26	6033.0
2013-05-07 18:00:00	MSFT	Stock	33.25	33.4	33.25	33.4	7215.0
2013-05-07 19:00:00	MSFT	Stock	33.26	33.29	33.26	33.26	1100.0
2013-05-07 09:00:00	NVDA	Stock	0.3458	0.3465	0.3445	0.3448	41804000.0
2013-05-07 10:00:00	NVDA	Stock	0.345	0.345	0.3404	0.3414	94247280.0
2013-05-07 11:00:00	NVDA	Stock	0.3413	0.3426	0.34	0.3405	52115800.0
2013-05-07 12:00:00	NVDA	Stock	0.3402	0.3415	0.338	0.3398	50249960.0
2013-05-07 13:00:00	NVDA	Stock	0.3399	0.3415	0.3398	0.3413	50506320.0
2013-05-07 14:00:00	NVDA	Stock	0.3413	0.3415	0.3405	0.3408	43382600.0
2013-05-07 15:00:00	NVDA	Stock	0.3409	0.3424	0.3408	0.341	92995680.0
2013-05-07 16:00:00	NVDA	Stock	0.3413	0.3415	0.3408	0.3408	3221360.0
2013-05-07 06:00:00	AMZN	Stock	12.823	12.823	12.823	12.823	4000.0
2013-05-07 07:00:00	AMZN	Stock	12.823	12.823	12.823	12.823	2000.0
2013-05-07 08:00:00	AMZN	Stock	12.803	12.803	12.749	12.786	255600.0
2013-05-07 09:00:00	AMZN	Stock	12.7705	12.849	12.7005	12.7725	8997460.0
2013-05-07 10:00:00	AMZN	Stock	12.7725	12.7745	12.6455	12.743	10487060.0
2013-05-07 11:00:00	AMZN	Stock	12.7395	12.8885	12.7395	12.873	9030840.0
2013-05-07 12:00:00	AMZN	Stock	12.8725	12.987	12.872	12.9355	12206040.0
2013-05-07 13:00:00	AMZN	Stock	12.9395	12.9445	12.8545	12.91	5944760.0
2013-05-07 14:00:00	AMZN	Stock	12.91	12.9335	12.8736	12.917	7045720.0
2013-05-07 15:00:00	AMZN	Stock	12.917	12.93	12.8765	12.891	6628560.0
2013-05-07 16:00:00	AMZN	Stock	12.8865	12.8924	12.688	12.8924	1732340.0
2013-05-07 17:00:00	AMZN	Stock	12.8865	12.8865	12.8865	12.8865	27500.0
2013-05-07 18:00:00	AMZN	Stock	12.8765	12.8765	12.873	12.873	11400.0

> showing 50 of 46,202 rows — these rows as CSV

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