PREVIEW / stock_1hour / 2011-03-11

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-03-11.parquet
  size:    944 KB
  rows:    44,890
  symbols: 3,488

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-11 04:00:00	AAPL	Stock	12.3246	12.3246	12.2661	12.2729	31892.0
2011-03-11 05:00:00	AAPL	Stock	12.2511	12.2679	12.2214	12.2375	312900.0
2011-03-11 06:00:00	AAPL	Stock	12.25	12.2939	12.2275	12.2939	297024.0
2011-03-11 07:00:00	AAPL	Stock	12.2939	12.3393	12.2714	12.3304	689836.0
2011-03-11 08:00:00	AAPL	Stock	12.3304	12.375	12.2857	12.3636	3268048.0
2011-03-11 09:00:00	AAPL	Stock	12.3629	12.4739	12.3214	12.4379	80299800.0
2011-03-11 10:00:00	AAPL	Stock	12.4361	12.4643	12.3882	12.4612	77644644.0
2011-03-11 11:00:00	AAPL	Stock	12.4632	12.5643	12.3329	12.5636	81755044.0
2011-03-11 12:00:00	AAPL	Stock	12.5643	12.5804	12.5471	12.5671	52588228.0
2011-03-11 13:00:00	AAPL	Stock	12.5671	12.5696	12.5007	12.5368	39201316.0
2011-03-11 14:00:00	AAPL	Stock	12.5371	12.5718	12.5289	12.5629	33109944.0
2011-03-11 15:00:00	AAPL	Stock	12.5621	12.5829	12.5468	12.5717	85667876.0
2011-03-11 16:00:00	AAPL	Stock	12.5714	12.5979	12.3796	12.5979	7239092.0
2011-03-11 17:00:00	AAPL	Stock	12.5936	12.6107	12.5907	12.6107	395192.0
2011-03-11 18:00:00	AAPL	Stock	12.6143	12.6375	12.5711	12.6214	534408.0
2011-03-11 19:00:00	AAPL	Stock	12.6179	12.625	12.6061	12.6214	389704.0
2011-03-11 04:00:00	MSFT	Stock	25.34	25.34	25.34	25.34	300.0
2011-03-11 05:00:00	MSFT	Stock	25.25	25.26	25.25	25.26	800.0
2011-03-11 06:00:00	MSFT	Stock	25.3	25.3	25.3	25.3	200.0
2011-03-11 07:00:00	MSFT	Stock	25.36	25.36	25.26	25.26	6475.0
2011-03-11 08:00:00	MSFT	Stock	25.29	25.42	25.29	25.32	42654.0
2011-03-11 09:00:00	MSFT	Stock	25.38	25.64	25.32	25.585	7064033.0
2011-03-11 10:00:00	MSFT	Stock	25.58	25.62	25.36	25.43	6918296.0
2011-03-11 11:00:00	MSFT	Stock	25.43	25.53	25.41	25.52	4836520.0
2011-03-11 12:00:00	MSFT	Stock	25.519	25.66	25.49	25.66	5725240.0
2011-03-11 13:00:00	MSFT	Stock	25.66	25.69	25.56	25.6	5020075.0
2011-03-11 14:00:00	MSFT	Stock	25.6	25.69	25.58	25.67	4955195.0
2011-03-11 15:00:00	MSFT	Stock	25.67	25.85	25.66	25.68	11063163.0
2011-03-11 16:00:00	MSFT	Stock	25.68	25.82	25.525	25.67	1752377.0
2011-03-11 17:00:00	MSFT	Stock	25.68	25.75	25.68	25.69	9212.0
2011-03-11 18:00:00	MSFT	Stock	25.68	25.7	25.68	25.7	7677.0
2011-03-11 19:00:00	MSFT	Stock	25.7	25.7	25.7	25.7	16063.0
2011-03-11 07:00:00	NVDA	Stock	0.4492	0.4568	0.448	0.4502	176000.0
2011-03-11 08:00:00	NVDA	Stock	0.4505	0.4575	0.4505	0.4538	7130720.0
2011-03-11 09:00:00	NVDA	Stock	0.453	0.4638	0.4502	0.4558	238915640.0
2011-03-11 10:00:00	NVDA	Stock	0.4558	0.4572	0.4482	0.449	251350560.0
2011-03-11 11:00:00	NVDA	Stock	0.449	0.4518	0.4415	0.45	298171720.0
2011-03-11 12:00:00	NVDA	Stock	0.4502	0.4525	0.4481	0.4512	101514960.0
2011-03-11 13:00:00	NVDA	Stock	0.4515	0.4525	0.4458	0.4488	118282400.0
2011-03-11 14:00:00	NVDA	Stock	0.449	0.4512	0.4458	0.4472	124121720.0
2011-03-11 15:00:00	NVDA	Stock	0.4471	0.4525	0.4452	0.451	319867800.0
2011-03-11 16:00:00	NVDA	Stock	0.451	0.4538	0.448	0.4512	24755440.0
2011-03-11 17:00:00	NVDA	Stock	0.451	0.4522	0.45	0.4505	277800.0
2011-03-11 18:00:00	NVDA	Stock	0.452	0.4522	0.452	0.4522	36000.0
2011-03-11 19:00:00	NVDA	Stock	0.451	0.4522	0.451	0.4515	214000.0
2011-03-11 08:00:00	AMZN	Stock	8.262	8.2725	8.2	8.2575	125280.0
2011-03-11 09:00:00	AMZN	Stock	8.271	8.3485	8.21	8.242	12571100.0
2011-03-11 10:00:00	AMZN	Stock	8.247	8.3665	8.206	8.3545	21092680.0
2011-03-11 11:00:00	AMZN	Stock	8.3545	8.46	8.3415	8.457	16455820.0
2011-03-11 12:00:00	AMZN	Stock	8.4564	8.46	8.414	8.442	6762340.0

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

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