PREVIEW / stock_1hour / 2013-12-12

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-12-12.parquet
  size:    1.0 MB
  rows:    48,170
  symbols: 3,533

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-12-12 04:00:00	AAPL	Stock	20.0357	20.0489	20.0096	20.0157	33600.0
2013-12-12 05:00:00	AAPL	Stock	20.0157	20.0157	19.9929	19.9929	31640.0
2013-12-12 06:00:00	AAPL	Stock	20.0011	20.0114	20.0011	20.0057	20888.0
2013-12-12 07:00:00	AAPL	Stock	20.0118	20.1236	20.0107	20.1214	396648.0
2013-12-12 08:00:00	AAPL	Stock	20.1179	20.1525	20.0321	20.1361	1275624.0
2013-12-12 09:00:00	AAPL	Stock	20.1375	20.1521	20.0269	20.0775	39136132.0
2013-12-12 10:00:00	AAPL	Stock	20.0789	20.1586	20.0121	20.1464	38052980.0
2013-12-12 11:00:00	AAPL	Stock	20.1443	20.1907	20.0393	20.0436	35897596.0
2013-12-12 12:00:00	AAPL	Stock	20.0429	20.0936	20.025	20.0711	25803456.0
2013-12-12 13:00:00	AAPL	Stock	20.0696	20.1236	20.0461	20.0571	18202324.0
2013-12-12 14:00:00	AAPL	Stock	20.0604	20.1	20.0421	20.0643	15261736.0
2013-12-12 15:00:00	AAPL	Stock	20.0636	20.0761	20.0011	20.0239	31522792.0
2013-12-12 16:00:00	AAPL	Stock	20.0193	20.0817	20.0071	20.0104	10666488.0
2013-12-12 17:00:00	AAPL	Stock	20.0121	20.0161	20.0043	20.0161	207508.0
2013-12-12 18:00:00	AAPL	Stock	20.0179	20.0314	20.0139	20.0286	167188.0
2013-12-12 19:00:00	AAPL	Stock	20.0332	20.0336	20.0139	20.0286	106988.0
2013-12-12 07:00:00	MSFT	Stock	37.48	37.54	36.88	37.3	36722.0
2013-12-12 08:00:00	MSFT	Stock	37.38	37.59	37.25	37.54	34593.0
2013-12-12 09:00:00	MSFT	Stock	37.59	37.64	37.3	37.39	4493926.0
2013-12-12 10:00:00	MSFT	Stock	37.39	37.51	37.37	37.42	5254046.0
2013-12-12 11:00:00	MSFT	Stock	37.42	37.51	37.42	37.44	3108307.0
2013-12-12 12:00:00	MSFT	Stock	37.444	37.46	37.4	37.42	3019207.0
2013-12-12 13:00:00	MSFT	Stock	37.42	37.47	37.4	37.439	3320828.0
2013-12-12 14:00:00	MSFT	Stock	37.43	37.49	37.37	37.435	4310543.0
2013-12-12 15:00:00	MSFT	Stock	37.43	37.44	37.18	37.23	8405934.0
2013-12-12 16:00:00	MSFT	Stock	37.22	37.434	37.21	37.35	3052153.0
2013-12-12 17:00:00	MSFT	Stock	37.22	37.35	36.5	37.29	37569.0
2013-12-12 18:00:00	MSFT	Stock	37.22	37.29	37.22	37.29	12513.0
2013-12-12 19:00:00	MSFT	Stock	37.21	37.25	37.21	37.25	984.0
2013-12-12 09:00:00	NVDA	Stock	0.384	0.386	0.3803	0.3818	26545240.0
2013-12-12 10:00:00	NVDA	Stock	0.3816	0.382	0.3798	0.3801	41338720.0
2013-12-12 11:00:00	NVDA	Stock	0.3801	0.3808	0.3788	0.3798	21300240.0
2013-12-12 12:00:00	NVDA	Stock	0.3799	0.3803	0.379	0.3793	23303960.0
2013-12-12 13:00:00	NVDA	Stock	0.3794	0.38	0.3778	0.378	24709360.0
2013-12-12 14:00:00	NVDA	Stock	0.378	0.3785	0.3773	0.3782	22608000.0
2013-12-12 15:00:00	NVDA	Stock	0.3781	0.3783	0.377	0.3776	66094280.0
2013-12-12 16:00:00	NVDA	Stock	0.3778	0.3788	0.3775	0.3775	26188360.0
2013-12-12 17:00:00	NVDA	Stock	0.3765	0.3778	0.3765	0.3778	284000.0
2013-12-12 05:00:00	AMZN	Stock	19.1045	19.1045	19.1045	19.1045	2000.0
2013-12-12 07:00:00	AMZN	Stock	19.1	19.1	19.1	19.1	4000.0
2013-12-12 08:00:00	AMZN	Stock	19.1095	19.241	19.0975	19.2395	82480.0
2013-12-12 09:00:00	AMZN	Stock	19.1995	19.25	18.975	19.074	8002200.0
2013-12-12 10:00:00	AMZN	Stock	19.0605	19.1985	18.975	19.175	9380440.0
2013-12-12 11:00:00	AMZN	Stock	19.168	19.21	19.0645	19.0773	3511700.0
2013-12-12 12:00:00	AMZN	Stock	19.082	19.0885	19.0	19.061	3450120.0
2013-12-12 13:00:00	AMZN	Stock	19.0655	19.147	19.052	19.147	2749720.0
2013-12-12 14:00:00	AMZN	Stock	19.141	19.195	19.129	19.164	2652080.0
2013-12-12 15:00:00	AMZN	Stock	19.163	19.1745	19.0535	19.065	5460300.0
2013-12-12 16:00:00	AMZN	Stock	19.0625	19.1012	19.03	19.03	473880.0
2013-12-12 17:00:00	AMZN	Stock	19.018	19.0625	19.018	19.04	72000.0

> showing 50 of 48,170 rows — these rows as CSV

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