PREVIEW / stock_1hour / 2011-02-14

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-02-14.parquet
  size:    942 KB
  rows:    44,891
  symbols: 3,563

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-02-14 04:00:00	AAPL	Stock	12.7436	12.7521	12.7393	12.7393	22400.0
2011-02-14 05:00:00	AAPL	Stock	12.7396	12.7425	12.7393	12.7393	19600.0
2011-02-14 06:00:00	AAPL	Stock	12.7393	12.7636	12.7393	12.7636	5600.0
2011-02-14 07:00:00	AAPL	Stock	12.7393	12.7996	12.7232	12.7704	494060.0
2011-02-14 08:00:00	AAPL	Stock	12.775	12.7768	12.7364	12.7482	1541876.0
2011-02-14 09:00:00	AAPL	Stock	12.7482	12.8386	12.7382	12.8125	63537068.0
2011-02-14 10:00:00	AAPL	Stock	12.8136	12.8325	12.7882	12.8014	56712320.0
2011-02-14 11:00:00	AAPL	Stock	12.8014	12.83	12.8014	12.8261	30266432.0
2011-02-14 12:00:00	AAPL	Stock	12.8268	12.8375	12.8143	12.8214	34055700.0
2011-02-14 13:00:00	AAPL	Stock	12.8218	12.8282	12.8146	12.8211	16363844.0
2011-02-14 14:00:00	AAPL	Stock	12.8218	12.8243	12.8071	12.8196	24326848.0
2011-02-14 15:00:00	AAPL	Stock	12.8196	12.8286	12.8107	12.8279	48521396.0
2011-02-14 16:00:00	AAPL	Stock	12.8279	12.8286	12.7395	12.8107	28976444.0
2011-02-14 17:00:00	AAPL	Stock	12.8107	12.8175	12.8093	12.8125	186228.0
2011-02-14 18:00:00	AAPL	Stock	12.8093	12.8279	12.8093	12.8146	148652.0
2011-02-14 19:00:00	AAPL	Stock	12.8161	12.8179	12.8125	12.8146	222236.0
2011-02-14 06:00:00	MSFT	Stock	27.37	27.37	27.37	27.37	700.0
2011-02-14 07:00:00	MSFT	Stock	27.37	27.4	27.32	27.33	3348.0
2011-02-14 08:00:00	MSFT	Stock	27.34	27.34	27.31	27.32	11950.0
2011-02-14 09:00:00	MSFT	Stock	27.31	27.37	26.95	26.99	7906059.0
2011-02-14 10:00:00	MSFT	Stock	26.987	27.13	26.95	27.115	9237602.0
2011-02-14 11:00:00	MSFT	Stock	27.11	27.25	27.09	27.14	5931297.0
2011-02-14 12:00:00	MSFT	Stock	27.15	27.25	27.07	27.089	5883655.0
2011-02-14 13:00:00	MSFT	Stock	27.08	27.19	27.08	27.12	3899275.0
2011-02-14 14:00:00	MSFT	Stock	27.125	27.13	27.04	27.085	5844618.0
2011-02-14 15:00:00	MSFT	Stock	27.085	27.23	27.02	27.23	13581879.0
2011-02-14 16:00:00	MSFT	Stock	27.23	27.27	27.083	27.083	1519601.0
2011-02-14 17:00:00	MSFT	Stock	27.18	27.22	27.16	27.22	19917.0
2011-02-14 18:00:00	MSFT	Stock	27.22	27.23	27.2	27.21	12647.0
2011-02-14 19:00:00	MSFT	Stock	27.21	27.22	27.19	27.21	8766.0
2011-02-14 06:00:00	NVDA	Stock	0.5923	0.5923	0.5923	0.5923	20000.0
2011-02-14 07:00:00	NVDA	Stock	0.581	0.6125	0.581	0.5988	340000.0
2011-02-14 08:00:00	NVDA	Stock	0.5992	0.6025	0.5903	0.5908	5696960.0
2011-02-14 09:00:00	NVDA	Stock	0.5908	0.608	0.585	0.607	232753960.0
2011-02-14 10:00:00	NVDA	Stock	0.6073	0.6125	0.6025	0.6048	227455120.0
2011-02-14 11:00:00	NVDA	Stock	0.6048	0.605	0.5885	0.5918	168354280.0
2011-02-14 12:00:00	NVDA	Stock	0.5918	0.595	0.5878	0.591	109425400.0
2011-02-14 13:00:00	NVDA	Stock	0.591	0.5915	0.5858	0.5872	115211320.0
2011-02-14 14:00:00	NVDA	Stock	0.587	0.5898	0.5755	0.576	179210000.0
2011-02-14 15:00:00	NVDA	Stock	0.576	0.5802	0.5758	0.5775	227578400.0
2011-02-14 16:00:00	NVDA	Stock	0.5778	0.5926	0.572	0.5755	9345000.0
2011-02-14 17:00:00	NVDA	Stock	0.5768	0.5778	0.5762	0.5772	899280.0
2011-02-14 18:00:00	NVDA	Stock	0.5772	0.5775	0.5765	0.5765	186320.0
2011-02-14 19:00:00	NVDA	Stock	0.577	0.5772	0.5762	0.5772	825880.0
2011-02-14 07:00:00	AMZN	Stock	9.435	9.435	9.414	9.42	16000.0
2011-02-14 08:00:00	AMZN	Stock	9.43	9.4475	9.4	9.4245	114900.0
2011-02-14 09:00:00	AMZN	Stock	9.4475	9.5175	9.4175	9.4735	16049620.0
2011-02-14 10:00:00	AMZN	Stock	9.475	9.57	9.4665	9.4995	16340880.0
2011-02-14 11:00:00	AMZN	Stock	9.5	9.5315	9.491	9.5265	7189800.0
2011-02-14 12:00:00	AMZN	Stock	9.528	9.5455	9.5155	9.534	5917240.0

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

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