PREVIEW / stock_1hour / 2011-12-27

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-12-27.parquet
  size:    913 KB
  rows:    43,894
  symbols: 3,559

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-12-27 07:00:00	AAPL	Stock	14.4143	14.4214	14.3929	14.3946	131096.0
2011-12-27 08:00:00	AAPL	Stock	14.3936	14.4786	14.3936	14.4268	1244012.0
2011-12-27 09:00:00	AAPL	Stock	14.4232	14.6104	14.3936	14.5764	68653788.0
2011-12-27 10:00:00	AAPL	Stock	14.5746	14.5957	14.4846	14.5018	47231156.0
2011-12-27 11:00:00	AAPL	Stock	14.4996	14.5571	14.4929	14.5536	22863652.0
2011-12-27 12:00:00	AAPL	Stock	14.5529	14.5675	14.5293	14.535	17978184.0
2011-12-27 13:00:00	AAPL	Stock	14.5336	14.585	14.5304	14.5807	17901968.0
2011-12-27 14:00:00	AAPL	Stock	14.58	14.5871	14.5251	14.5789	22688344.0
2011-12-27 15:00:00	AAPL	Stock	14.58	14.5925	14.5136	14.5204	41210316.0
2011-12-27 16:00:00	AAPL	Stock	14.5193	14.5863	14.4636	14.5179	20359248.0
2011-12-27 17:00:00	AAPL	Stock	14.5171	14.5339	14.5146	14.5332	364336.0
2011-12-27 18:00:00	AAPL	Stock	14.5268	14.5304	14.5179	14.5179	154420.0
2011-12-27 19:00:00	AAPL	Stock	14.5179	14.5204	14.5154	14.5154	65268.0
2011-12-27 05:00:00	MSFT	Stock	26.04	26.04	26.04	26.04	425.0
2011-12-27 06:00:00	MSFT	Stock	26.04	26.04	26.04	26.04	575.0
2011-12-27 07:00:00	MSFT	Stock	26.03	26.03	26.0	26.0	500.0
2011-12-27 08:00:00	MSFT	Stock	26.02	26.02	25.97	25.97	6550.0
2011-12-27 09:00:00	MSFT	Stock	25.99	26.11	25.93	26.08	3075978.0
2011-12-27 10:00:00	MSFT	Stock	26.08	26.13	26.02	26.041	2928118.0
2011-12-27 11:00:00	MSFT	Stock	26.04	26.09	26.04	26.05	1618278.0
2011-12-27 12:00:00	MSFT	Stock	26.06	26.12	26.05	26.078	2072334.0
2011-12-27 13:00:00	MSFT	Stock	26.07	26.14	26.06	26.1	1829637.0
2011-12-27 14:00:00	MSFT	Stock	26.1	26.11	26.06	26.075	1700402.0
2011-12-27 15:00:00	MSFT	Stock	26.08	26.09	26.02	26.03	4735280.0
2011-12-27 16:00:00	MSFT	Stock	26.04	26.09	25.929	26.05	3063070.0
2011-12-27 17:00:00	MSFT	Stock	26.04	26.04	26.0	26.0	4400.0
2011-12-27 18:00:00	MSFT	Stock	26.04	26.04	26.01	26.04	13669.0
2011-12-27 09:00:00	NVDA	Stock	0.3548	0.357	0.3505	0.3542	34826720.0
2011-12-27 10:00:00	NVDA	Stock	0.3545	0.3562	0.3515	0.3528	46952200.0
2011-12-27 11:00:00	NVDA	Stock	0.3528	0.3545	0.3522	0.3535	17031880.0
2011-12-27 12:00:00	NVDA	Stock	0.3535	0.3553	0.3533	0.3548	19442680.0
2011-12-27 13:00:00	NVDA	Stock	0.3546	0.3548	0.3538	0.3542	12170760.0
2011-12-27 14:00:00	NVDA	Stock	0.3544	0.3545	0.3522	0.3529	16977680.0
2011-12-27 15:00:00	NVDA	Stock	0.3529	0.353	0.351	0.3515	41320840.0
2011-12-27 16:00:00	NVDA	Stock	0.3515	0.3539	0.3515	0.3516	5813000.0
2011-12-27 17:00:00	NVDA	Stock	0.353	0.353	0.353	0.353	160000.0
2011-12-27 19:00:00	NVDA	Stock	0.3525	0.3525	0.3525	0.3525	40000.0
2011-12-27 06:00:00	AMZN	Stock	8.94	8.94	8.94	8.94	2000.0
2011-12-27 07:00:00	AMZN	Stock	8.9335	8.9345	8.9075	8.9285	52000.0
2011-12-27 08:00:00	AMZN	Stock	8.9105	8.9445	8.8575	8.8625	189000.0
2011-12-27 09:00:00	AMZN	Stock	8.8625	8.9298	8.8255	8.894	10415420.0
2011-12-27 10:00:00	AMZN	Stock	8.9005	8.9215	8.8555	8.8628	10106480.0
2011-12-27 11:00:00	AMZN	Stock	8.861	8.8745	8.8236	8.8525	7478000.0
2011-12-27 12:00:00	AMZN	Stock	8.8525	8.862	8.8255	8.8595	6682900.0
2011-12-27 13:00:00	AMZN	Stock	8.8565	8.9068	8.8545	8.9	5196100.0
2011-12-27 14:00:00	AMZN	Stock	8.899	8.924	8.883	8.891	5230800.0
2011-12-27 15:00:00	AMZN	Stock	8.89	8.891	8.808	8.8135	11985500.0
2011-12-27 16:00:00	AMZN	Stock	8.8135	8.8692	8.8025	8.864	1284940.0
2011-12-27 17:00:00	AMZN	Stock	8.8125	8.83	8.8085	8.811	72440.0
2011-12-27 18:00:00	AMZN	Stock	8.8125	8.8145	8.8075	8.8075	18100.0

> showing 50 of 43,894 rows — these rows as CSV

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