PREVIEW / stock_1hour / 2012-08-28

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-08-28.parquet
  size:    907 KB
  rows:    42,897
  symbols: 3,441

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
2012-08-28 04:00:00	AAPL	Stock	24.1429	24.2343	24.1429	24.2343	101500.0
2012-08-28 05:00:00	AAPL	Stock	24.2325	24.2411	24.2321	24.2411	20720.0
2012-08-28 06:00:00	AAPL	Stock	24.2218	24.225	24.2036	24.2036	24080.0
2012-08-28 07:00:00	AAPL	Stock	24.1843	24.1964	24.1286	24.1429	368032.0
2012-08-28 08:00:00	AAPL	Stock	24.1568	24.2	24.0757	24.0939	1689268.0
2012-08-28 09:00:00	AAPL	Stock	24.0871	24.125	23.9911	24.0236	57006040.0
2012-08-28 10:00:00	AAPL	Stock	24.0189	24.0779	23.9743	23.9836	50179220.0
2012-08-28 11:00:00	AAPL	Stock	23.9854	24.1311	23.9526	24.1118	44276652.0
2012-08-28 12:00:00	AAPL	Stock	24.1118	24.1339	24.0636	24.0964	27749232.0
2012-08-28 13:00:00	AAPL	Stock	24.0957	24.0986	24.0468	24.0661	18422908.0
2012-08-28 14:00:00	AAPL	Stock	24.0654	24.125	24.0625	24.1025	18690616.0
2012-08-28 15:00:00	AAPL	Stock	24.1043	24.1464	24.085	24.0982	35444136.0
2012-08-28 16:00:00	AAPL	Stock	24.1	24.1129	24.0013	24.1107	4270756.0
2012-08-28 17:00:00	AAPL	Stock	24.1093	24.1125	24.1004	24.1071	127904.0
2012-08-28 18:00:00	AAPL	Stock	24.1089	24.1136	24.1071	24.1086	114240.0
2012-08-28 19:00:00	AAPL	Stock	24.1089	24.1225	24.1046	24.1204	359884.0
2012-08-28 05:00:00	MSFT	Stock	30.67	30.67	30.67	30.67	100.0
2012-08-28 06:00:00	MSFT	Stock	30.93	30.93	30.85	30.85	200.0
2012-08-28 07:00:00	MSFT	Stock	30.8	30.91	30.75	30.82	3700.0
2012-08-28 08:00:00	MSFT	Stock	30.77	30.9	30.69	30.8	32350.0
2012-08-28 09:00:00	MSFT	Stock	30.76	30.82	30.56	30.57	2822365.0
2012-08-28 10:00:00	MSFT	Stock	30.57	30.75	30.52	30.66	5092751.0
2012-08-28 11:00:00	MSFT	Stock	30.66	30.71	30.605	30.69	3508077.0
2012-08-28 12:00:00	MSFT	Stock	30.7	30.74	30.67	30.7	2419018.0
2012-08-28 13:00:00	MSFT	Stock	30.71	30.71	30.62	30.665	1672404.0
2012-08-28 14:00:00	MSFT	Stock	30.669	30.71	30.64	30.65	1749455.0
2012-08-28 15:00:00	MSFT	Stock	30.64	30.72	30.61	30.64	5823651.0
2012-08-28 16:00:00	MSFT	Stock	30.63	30.67	30.605	30.61	102248.0
2012-08-28 17:00:00	MSFT	Stock	30.62	30.69	30.62	30.69	4299.0
2012-08-28 18:00:00	MSFT	Stock	30.69	30.69	30.66	30.66	5363.0
2012-08-28 19:00:00	MSFT	Stock	30.66	30.66	30.64	30.65	722.0
2012-08-28 08:00:00	NVDA	Stock	0.3588	0.3588	0.355	0.355	199000.0
2012-08-28 09:00:00	NVDA	Stock	0.356	0.3605	0.356	0.3565	38053000.0
2012-08-28 10:00:00	NVDA	Stock	0.3565	0.3598	0.3553	0.3575	49929840.0
2012-08-28 11:00:00	NVDA	Stock	0.3575	0.3592	0.3572	0.3592	27139760.0
2012-08-28 12:00:00	NVDA	Stock	0.3591	0.3602	0.3585	0.3602	40902760.0
2012-08-28 13:00:00	NVDA	Stock	0.3602	0.3608	0.3588	0.3592	23808000.0
2012-08-28 14:00:00	NVDA	Stock	0.3592	0.3598	0.3582	0.359	31993200.0
2012-08-28 15:00:00	NVDA	Stock	0.359	0.3592	0.3562	0.3572	86359720.0
2012-08-28 16:00:00	NVDA	Stock	0.3572	0.3578	0.3564	0.3572	359800.0
2012-08-28 17:00:00	NVDA	Stock	0.3572	0.3572	0.3572	0.3572	575240.0
2012-08-28 18:00:00	NVDA	Stock	0.3575	0.3575	0.3575	0.3575	8000.0
2012-08-28 19:00:00	NVDA	Stock	0.3575	0.3575	0.3575	0.3575	32000.0
2012-08-28 08:00:00	AMZN	Stock	12.165	12.1975	12.165	12.1875	32000.0
2012-08-28 09:00:00	AMZN	Stock	12.197	12.2745	12.15	12.202	8167320.0
2012-08-28 10:00:00	AMZN	Stock	12.2025	12.255	12.1815	12.2055	8289840.0
2012-08-28 11:00:00	AMZN	Stock	12.211	12.257	12.184	12.2495	6395280.0
2012-08-28 12:00:00	AMZN	Stock	12.25	12.3084	12.245	12.296	9924540.0
2012-08-28 13:00:00	AMZN	Stock	12.2955	12.3145	12.288	12.294	6327320.0
2012-08-28 14:00:00	AMZN	Stock	12.2965	12.308	12.262	12.2825	3110720.0

> showing 50 of 42,897 rows — these rows as CSV

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