PREVIEW / stock_1hour / 2011-09-30

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-09-30.parquet
  size:    916 KB
  rows:    43,623
  symbols: 3,520

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-09-30 04:00:00	AAPL	Stock	13.9932	13.9932	13.9071	13.9071	8400.0
2011-09-30 05:00:00	AAPL	Stock	13.8518	13.8661	13.8393	13.865	16800.0
2011-09-30 06:00:00	AAPL	Stock	13.8468	13.8714	13.8171	13.8171	37772.0
2011-09-30 07:00:00	AAPL	Stock	13.8393	13.8643	13.8275	13.8393	696556.0
2011-09-30 08:00:00	AAPL	Stock	13.8525	13.9196	13.8325	13.8393	2593080.0
2011-09-30 09:00:00	AAPL	Stock	13.8339	13.8393	13.6504	13.7039	102330732.0
2011-09-30 10:00:00	AAPL	Stock	13.7039	13.8532	13.6789	13.7339	100291436.0
2011-09-30 11:00:00	AAPL	Stock	13.7332	13.8889	13.73	13.8318	67614708.0
2011-09-30 12:00:00	AAPL	Stock	13.8321	13.8475	13.7829	13.7953	32626244.0
2011-09-30 13:00:00	AAPL	Stock	13.7875	13.825	13.7536	13.7789	37964024.0
2011-09-30 14:00:00	AAPL	Stock	13.7786	13.7871	13.7093	13.7582	58372328.0
2011-09-30 15:00:00	AAPL	Stock	13.755	13.7736	13.6139	13.6143	106847300.0
2011-09-30 16:00:00	AAPL	Stock	13.6139	13.8285	13.5975	13.6214	32713772.0
2011-09-30 17:00:00	AAPL	Stock	13.6204	13.6243	13.6018	13.6179	542248.0
2011-09-30 18:00:00	AAPL	Stock	13.6179	13.6214	13.575	13.5804	325696.0
2011-09-30 19:00:00	AAPL	Stock	13.5721	13.6186	13.5714	13.5857	297080.0
2011-09-30 07:00:00	MSFT	Stock	25.19	25.25	25.19	25.23	3100.0
2011-09-30 08:00:00	MSFT	Stock	25.28	25.32	25.25	25.25	18100.0
2011-09-30 09:00:00	MSFT	Stock	25.25	25.46	25.17	25.225	6793925.0
2011-09-30 10:00:00	MSFT	Stock	25.22	25.5	25.185	25.2	7848344.0
2011-09-30 11:00:00	MSFT	Stock	25.2	25.33	25.162	25.29	4533593.0
2011-09-30 12:00:00	MSFT	Stock	25.28	25.32	25.15	25.16	3007895.0
2011-09-30 13:00:00	MSFT	Stock	25.15	25.3	25.1	25.26	2819021.0
2011-09-30 14:00:00	MSFT	Stock	25.25	25.26	25.02	25.14	5956634.0
2011-09-30 15:00:00	MSFT	Stock	25.14	25.24	24.88	24.898	13545951.0
2011-09-30 16:00:00	MSFT	Stock	24.9	25.19	24.84	24.87	8895135.0
2011-09-30 17:00:00	MSFT	Stock	24.89	24.99	24.89	24.95	10017.0
2011-09-30 18:00:00	MSFT	Stock	24.95	25.19	24.9	24.93	8500.0
2011-09-30 19:00:00	MSFT	Stock	24.93	24.93	24.8	24.8	18748.0
2011-09-30 08:00:00	NVDA	Stock	0.3253	0.3263	0.3213	0.3228	594240.0
2011-09-30 09:00:00	NVDA	Stock	0.3233	0.3233	0.3133	0.3163	98273800.0
2011-09-30 10:00:00	NVDA	Stock	0.3163	0.321	0.3153	0.317	98346720.0
2011-09-30 11:00:00	NVDA	Stock	0.317	0.3238	0.3168	0.32	80603080.0
2011-09-30 12:00:00	NVDA	Stock	0.3198	0.321	0.3158	0.316	50370640.0
2011-09-30 13:00:00	NVDA	Stock	0.316	0.3168	0.3148	0.3159	50431040.0
2011-09-30 14:00:00	NVDA	Stock	0.3158	0.3163	0.3125	0.3148	93503600.0
2011-09-30 15:00:00	NVDA	Stock	0.3148	0.3168	0.3123	0.3123	152919240.0
2011-09-30 16:00:00	NVDA	Stock	0.3125	0.3164	0.3115	0.3138	21148000.0
2011-09-30 17:00:00	NVDA	Stock	0.3138	0.3138	0.3125	0.3125	133480.0
2011-09-30 18:00:00	NVDA	Stock	0.3128	0.3133	0.3125	0.3125	139760.0
2011-09-30 19:00:00	NVDA	Stock	0.3125	0.3128	0.3115	0.3128	528960.0
2011-09-30 05:00:00	AMZN	Stock	11.07	11.07	11.07	11.07	2000.0
2011-09-30 06:00:00	AMZN	Stock	11.0365	11.0365	11.0365	11.0365	2000.0
2011-09-30 07:00:00	AMZN	Stock	11.013	11.02	10.9995	11.0	52000.0
2011-09-30 08:00:00	AMZN	Stock	11.0195	11.054	10.8	10.979	390920.0
2011-09-30 09:00:00	AMZN	Stock	10.965	10.965	10.7605	10.787	21666360.0
2011-09-30 10:00:00	AMZN	Stock	10.7805	11.017	10.765	10.8885	23400660.0
2011-09-30 11:00:00	AMZN	Stock	10.8879	11.15	10.875	11.0415	16984640.0
2011-09-30 12:00:00	AMZN	Stock	11.047	11.103	11.013	11.0198	7905620.0
2011-09-30 13:00:00	AMZN	Stock	11.0175	11.0175	10.915	10.9955	9411020.0

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

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