PREVIEW / stock_1hour / 2011-06-14

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-06-14.parquet
  size:    962 KB
  rows:    46,977
  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-06-14 04:00:00	AAPL	Stock	11.7182	11.7182	11.7	11.7	5600.0
2011-06-14 05:00:00	AAPL	Stock	11.7321	11.7321	11.7321	11.7321	5600.0
2011-06-14 06:00:00	AAPL	Stock	11.7493	11.7493	11.7464	11.7464	12600.0
2011-06-14 07:00:00	AAPL	Stock	11.7471	11.7636	11.7279	11.7536	226212.0
2011-06-14 08:00:00	AAPL	Stock	11.7604	11.8179	11.7379	11.8139	2440676.0
2011-06-14 09:00:00	AAPL	Stock	11.8125	11.8429	11.7611	11.8361	60382448.0
2011-06-14 10:00:00	AAPL	Stock	11.8357	11.8725	11.8257	11.836	55115564.0
2011-06-14 11:00:00	AAPL	Stock	11.835	11.8429	11.8057	11.8236	32325272.0
2011-06-14 12:00:00	AAPL	Stock	11.8246	11.8364	11.8132	11.8257	26249104.0
2011-06-14 13:00:00	AAPL	Stock	11.8268	11.8632	11.82	11.8529	26180840.0
2011-06-14 14:00:00	AAPL	Stock	11.8543	11.8971	11.8496	11.8814	37044448.0
2011-06-14 15:00:00	AAPL	Stock	11.8814	11.9018	11.8457	11.8689	64705732.0
2011-06-14 16:00:00	AAPL	Stock	11.8661	11.8811	11.8426	11.8786	13034644.0
2011-06-14 17:00:00	AAPL	Stock	11.875	11.8804	11.8729	11.8779	118552.0
2011-06-14 18:00:00	AAPL	Stock	11.8746	11.8989	11.8729	11.8875	439964.0
2011-06-14 19:00:00	AAPL	Stock	11.8918	11.8979	11.8893	11.8979	116368.0
2011-06-14 04:00:00	MSFT	Stock	24.1	24.15	24.1	24.15	1400.0
2011-06-14 05:00:00	MSFT	Stock	24.15	24.15	24.15	24.15	200.0
2011-06-14 06:00:00	MSFT	Stock	24.1	24.1	24.1	24.1	200.0
2011-06-14 07:00:00	MSFT	Stock	24.15	24.17	24.15	24.17	2306.0
2011-06-14 08:00:00	MSFT	Stock	24.19	24.32	24.16	24.26	382557.0
2011-06-14 09:00:00	MSFT	Stock	24.29	24.41	24.21	24.37	6168229.0
2011-06-14 10:00:00	MSFT	Stock	24.37	24.45	24.35	24.39	6472031.0
2011-06-14 11:00:00	MSFT	Stock	24.385	24.39	24.2	24.25	4011972.0
2011-06-14 12:00:00	MSFT	Stock	24.255	24.32	24.23	24.29	3328426.0
2011-06-14 13:00:00	MSFT	Stock	24.29	24.36	24.26	24.3	3752515.0
2011-06-14 14:00:00	MSFT	Stock	24.29	24.32	24.27	24.28	4020086.0
2011-06-14 15:00:00	MSFT	Stock	24.28	24.32	24.19	24.21	8543340.0
2011-06-14 16:00:00	MSFT	Stock	24.21	24.305	24.14	24.22	3976122.0
2011-06-14 17:00:00	MSFT	Stock	24.21	24.22	24.2	24.22	2070.0
2011-06-14 18:00:00	MSFT	Stock	24.22	24.22	24.22	24.22	35599.0
2011-06-14 19:00:00	MSFT	Stock	24.22	24.22	24.22	24.22	3183.0
2011-06-14 08:00:00	NVDA	Stock	0.4282	0.4322	0.4282	0.4312	670240.0
2011-06-14 09:00:00	NVDA	Stock	0.432	0.4335	0.4288	0.431	65851080.0
2011-06-14 10:00:00	NVDA	Stock	0.431	0.438	0.4303	0.4369	90220640.0
2011-06-14 11:00:00	NVDA	Stock	0.4368	0.4375	0.4328	0.4354	61484800.0
2011-06-14 12:00:00	NVDA	Stock	0.4355	0.4366	0.4334	0.4338	34245680.0
2011-06-14 13:00:00	NVDA	Stock	0.4338	0.434	0.4314	0.4318	51724000.0
2011-06-14 14:00:00	NVDA	Stock	0.4318	0.432	0.4302	0.4305	58916280.0
2011-06-14 15:00:00	NVDA	Stock	0.4302	0.4305	0.4268	0.4282	145390680.0
2011-06-14 16:00:00	NVDA	Stock	0.4282	0.4332	0.4282	0.4285	14640440.0
2011-06-14 17:00:00	NVDA	Stock	0.425	0.4295	0.425	0.4285	654400.0
2011-06-14 18:00:00	NVDA	Stock	0.4295	0.43	0.4295	0.4298	160000.0
2011-06-14 19:00:00	NVDA	Stock	0.43	0.43	0.43	0.43	10000.0
2011-06-14 07:00:00	AMZN	Stock	9.4055	9.455	9.4055	9.4425	23000.0
2011-06-14 08:00:00	AMZN	Stock	9.411	9.48	9.4085	9.4725	93000.0
2011-06-14 09:00:00	AMZN	Stock	9.4675	9.4725	9.381	9.407	8180040.0
2011-06-14 10:00:00	AMZN	Stock	9.4095	9.4725	9.3535	9.4695	16666040.0
2011-06-14 11:00:00	AMZN	Stock	9.4635	9.498	9.44	9.4848	8950500.0
2011-06-14 12:00:00	AMZN	Stock	9.483	9.49	9.4465	9.4535	5493740.0

> showing 50 of 46,977 rows — these rows as CSV

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