PREVIEW / stock_1hour / 2011-04-15

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-04-15.parquet
  size:    941 KB
  rows:    45,104
  symbols: 3,530

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-04-15 04:00:00	AAPL	Stock	11.8736	11.8736	11.8736	11.8736	2800.0
2011-04-15 05:00:00	AAPL	Stock	11.8993	11.8993	11.8714	11.8714	49980.0
2011-04-15 06:00:00	AAPL	Stock	11.8714	11.8714	11.8714	11.8714	11200.0
2011-04-15 07:00:00	AAPL	Stock	11.8468	11.8711	11.8464	11.8704	117852.0
2011-04-15 08:00:00	AAPL	Stock	11.8611	11.8611	11.8179	11.8554	986776.0
2011-04-15 09:00:00	AAPL	Stock	11.8536	11.9189	11.755	11.7932	89359956.0
2011-04-15 10:00:00	AAPL	Stock	11.7939	11.8193	11.78	11.8043	66738952.0
2011-04-15 11:00:00	AAPL	Stock	11.8046	11.8529	11.8043	11.8187	42352604.0
2011-04-15 12:00:00	AAPL	Stock	11.8176	11.8257	11.8039	11.8218	25911200.0
2011-04-15 13:00:00	AAPL	Stock	11.8243	11.8289	11.7893	11.7907	21790804.0
2011-04-15 14:00:00	AAPL	Stock	11.7895	11.7954	11.7614	11.7654	37766372.0
2011-04-15 15:00:00	AAPL	Stock	11.765	11.765	11.6714	11.6957	114932832.0
2011-04-15 16:00:00	AAPL	Stock	11.6979	11.8211	11.6895	11.7021	10779440.0
2011-04-15 17:00:00	AAPL	Stock	11.6986	11.7086	11.6982	11.7086	428064.0
2011-04-15 18:00:00	AAPL	Stock	11.695	11.7246	11.695	11.7211	347956.0
2011-04-15 19:00:00	AAPL	Stock	11.7232	11.7286	11.7164	11.7286	156408.0
2011-04-15 06:00:00	MSFT	Stock	25.44	25.44	25.44	25.44	100.0
2011-04-15 07:00:00	MSFT	Stock	25.42	25.42	25.42	25.42	1400.0
2011-04-15 08:00:00	MSFT	Stock	25.38	25.4	25.35	25.38	7266.0
2011-04-15 09:00:00	MSFT	Stock	25.4	25.56	25.28	25.36	10768041.0
2011-04-15 10:00:00	MSFT	Stock	25.36	25.43	25.22	25.22	6082292.0
2011-04-15 11:00:00	MSFT	Stock	25.22	25.25	25.18	25.225	5957219.0
2011-04-15 12:00:00	MSFT	Stock	25.225	25.29	25.19	25.27	6311170.0
2011-04-15 13:00:00	MSFT	Stock	25.27	25.36	25.24	25.325	7856210.0
2011-04-15 14:00:00	MSFT	Stock	25.33	25.41	25.31	25.38	6458014.0
2011-04-15 15:00:00	MSFT	Stock	25.375	25.39	25.27	25.37	7670133.0
2011-04-15 16:00:00	MSFT	Stock	25.37	25.4	25.25	25.4	13764662.0
2011-04-15 17:00:00	MSFT	Stock	25.4	25.4	25.37	25.37	20500.0
2011-04-15 18:00:00	MSFT	Stock	25.37	25.37	25.3	25.35	58750.0
2011-04-15 19:00:00	MSFT	Stock	25.35	25.4	25.32	25.4	12365.0
2011-04-15 08:00:00	NVDA	Stock	0.4625	0.4625	0.4588	0.4588	243200.0
2011-04-15 09:00:00	NVDA	Stock	0.4582	0.4648	0.457	0.458	147526040.0
2011-04-15 10:00:00	NVDA	Stock	0.458	0.4683	0.458	0.467	209477600.0
2011-04-15 11:00:00	NVDA	Stock	0.467	0.4723	0.4665	0.4722	163141000.0
2011-04-15 12:00:00	NVDA	Stock	0.472	0.4735	0.4695	0.4715	119560240.0
2011-04-15 13:00:00	NVDA	Stock	0.4717	0.472	0.4662	0.4662	77232760.0
2011-04-15 14:00:00	NVDA	Stock	0.4665	0.4673	0.4652	0.4662	59787280.0
2011-04-15 15:00:00	NVDA	Stock	0.4662	0.4678	0.4633	0.4675	134222520.0
2011-04-15 16:00:00	NVDA	Stock	0.4678	0.4728	0.4628	0.4692	48236760.0
2011-04-15 17:00:00	NVDA	Stock	0.4675	0.4688	0.4675	0.4688	104000.0
2011-04-15 18:00:00	NVDA	Stock	0.4675	0.4675	0.4675	0.4675	8000.0
2011-04-15 19:00:00	NVDA	Stock	0.4675	0.4695	0.4668	0.4695	84000.0
2011-04-15 07:00:00	AMZN	Stock	9.0305	9.032	9.0	9.005	75000.0
2011-04-15 08:00:00	AMZN	Stock	9.009	9.009	8.9935	9.0005	60040.0
2011-04-15 09:00:00	AMZN	Stock	9.02	9.0725	8.951	8.988	19741600.0
2011-04-15 10:00:00	AMZN	Stock	8.99	9.065	8.99	9.065	11954700.0
2011-04-15 11:00:00	AMZN	Stock	9.064	9.089	9.0325	9.038	8685500.0
2011-04-15 12:00:00	AMZN	Stock	9.0395	9.0675	9.0295	9.045	6737040.0
2011-04-15 13:00:00	AMZN	Stock	9.0445	9.0535	9.0145	9.016	6200020.0
2011-04-15 14:00:00	AMZN	Stock	9.0172	9.037	9.0125	9.0185	5397660.0

> showing 50 of 45,104 rows — these rows as CSV

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