PREVIEW / stock_1hour / 2011-03-23

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-03-23.parquet
  size:    943 KB
  rows:    45,010
  symbols: 3,514

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-03-23 04:00:00	AAPL	Stock	12.1875	12.1875	12.1829	12.1829	16800.0
2011-03-23 05:00:00	AAPL	Stock	12.175	12.1964	12.175	12.1964	39200.0
2011-03-23 06:00:00	AAPL	Stock	12.1964	12.2207	12.1964	12.2193	16800.0
2011-03-23 07:00:00	AAPL	Stock	12.2036	12.2143	12.1407	12.1429	152012.0
2011-03-23 08:00:00	AAPL	Stock	12.1429	12.155	12.1154	12.1179	1099840.0
2011-03-23 09:00:00	AAPL	Stock	12.1157	12.1411	12.0629	12.0718	55827632.0
2011-03-23 10:00:00	AAPL	Stock	12.0718	12.0718	11.9982	12.0364	80051244.0
2011-03-23 11:00:00	AAPL	Stock	12.0375	12.0929	12.0366	12.0721	42378364.0
2011-03-23 12:00:00	AAPL	Stock	12.0714	12.1193	12.0625	12.0911	37416904.0
2011-03-23 13:00:00	AAPL	Stock	12.0911	12.1046	12.0725	12.0775	30603972.0
2011-03-23 14:00:00	AAPL	Stock	12.0769	12.1282	12.0643	12.1086	42583856.0
2011-03-23 15:00:00	AAPL	Stock	12.1111	12.1507	12.1036	12.1118	64905232.0
2011-03-23 16:00:00	AAPL	Stock	12.1118	12.1421	12.0815	12.1136	14242788.0
2011-03-23 17:00:00	AAPL	Stock	12.115	12.1286	12.1089	12.125	496636.0
2011-03-23 18:00:00	AAPL	Stock	12.1286	12.1314	12.1139	12.125	240072.0
2011-03-23 19:00:00	AAPL	Stock	12.1296	12.1339	12.1236	12.1339	126224.0
2011-03-23 07:00:00	MSFT	Stock	25.27	25.35	25.27	25.35	400.0
2011-03-23 08:00:00	MSFT	Stock	25.3	25.33	25.3	25.33	600.0
2011-03-23 09:00:00	MSFT	Stock	25.26	25.41	25.2	25.39	4241776.0
2011-03-23 10:00:00	MSFT	Stock	25.395	25.41	25.18	25.18	7201762.0
2011-03-23 11:00:00	MSFT	Stock	25.185	25.37	25.18	25.315	3625545.0
2011-03-23 12:00:00	MSFT	Stock	25.315	25.38	25.28	25.355	3113717.0
2011-03-23 13:00:00	MSFT	Stock	25.356	25.39	25.32	25.365	2962173.0
2011-03-23 14:00:00	MSFT	Stock	25.36	25.5	25.3	25.475	5855173.0
2011-03-23 15:00:00	MSFT	Stock	25.48	25.61	25.46	25.54	11653211.0
2011-03-23 16:00:00	MSFT	Stock	25.54	25.54	25.388	25.53	4480186.0
2011-03-23 17:00:00	MSFT	Stock	25.51	25.51	25.5	25.5	800.0
2011-03-23 18:00:00	MSFT	Stock	25.51	25.54	25.49	25.49	15428.0
2011-03-23 19:00:00	MSFT	Stock	25.51	25.51	25.49	25.51	48197.0
2011-03-23 08:00:00	NVDA	Stock	0.437	0.4372	0.4352	0.4372	112000.0
2011-03-23 09:00:00	NVDA	Stock	0.4362	0.4372	0.4268	0.4312	97581480.0
2011-03-23 10:00:00	NVDA	Stock	0.4312	0.4318	0.426	0.4302	133053240.0
2011-03-23 11:00:00	NVDA	Stock	0.4305	0.4408	0.4304	0.439	162999240.0
2011-03-23 12:00:00	NVDA	Stock	0.4391	0.4422	0.4372	0.4391	85315840.0
2011-03-23 13:00:00	NVDA	Stock	0.4391	0.4405	0.437	0.4398	77198280.0
2011-03-23 14:00:00	NVDA	Stock	0.44	0.445	0.4387	0.4445	86762280.0
2011-03-23 15:00:00	NVDA	Stock	0.4445	0.4465	0.443	0.4452	121307280.0
2011-03-23 16:00:00	NVDA	Stock	0.4455	0.4455	0.4342	0.4448	885680.0
2011-03-23 17:00:00	NVDA	Stock	0.4438	0.4455	0.4438	0.4455	100000.0
2011-03-23 18:00:00	NVDA	Stock	0.4445	0.4452	0.4445	0.445	81200.0
2011-03-23 19:00:00	NVDA	Stock	0.445	0.4455	0.445	0.4455	204000.0
2011-03-23 08:00:00	AMZN	Stock	8.1175	8.1175	8.1125	8.115	33400.0
2011-03-23 09:00:00	AMZN	Stock	8.116	8.12	8.041	8.085	8552540.0
2011-03-23 10:00:00	AMZN	Stock	8.0825	8.105	8.045	8.0565	17468080.0
2011-03-23 11:00:00	AMZN	Stock	8.057	8.153	8.055	8.136	13197020.0
2011-03-23 12:00:00	AMZN	Stock	8.137	8.216	8.128	8.186	10480540.0
2011-03-23 13:00:00	AMZN	Stock	8.186	8.2575	8.183	8.233	10412420.0
2011-03-23 14:00:00	AMZN	Stock	8.2325	8.291	8.2155	8.2795	11256200.0
2011-03-23 15:00:00	AMZN	Stock	8.28	8.313	8.262	8.266	19361280.0
2011-03-23 16:00:00	AMZN	Stock	8.266	8.3051	8.1709	8.274	3148420.0

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

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