PREVIEW / stock_1hour / 2013-06-11

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-06-11.parquet
  size:    985 KB
  rows:    46,356
  symbols: 3,495

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
2013-06-11 04:00:00	AAPL	Stock	15.6764	15.6764	15.6764	15.6764	8400.0
2013-06-11 06:00:00	AAPL	Stock	15.6036	15.6036	15.5339	15.5429	89320.0
2013-06-11 07:00:00	AAPL	Stock	15.5371	15.5786	15.525	15.5764	321636.0
2013-06-11 08:00:00	AAPL	Stock	15.5714	15.7143	15.5189	15.5536	1903188.0
2013-06-11 09:00:00	AAPL	Stock	15.5518	15.7518	15.4757	15.7229	67219208.0
2013-06-11 10:00:00	AAPL	Stock	15.7189	15.8129	15.69	15.735	71671824.0
2013-06-11 11:00:00	AAPL	Stock	15.735	15.7725	15.7025	15.7196	24871028.0
2013-06-11 12:00:00	AAPL	Stock	15.7239	15.7968	15.7054	15.7461	27457808.0
2013-06-11 13:00:00	AAPL	Stock	15.7496	15.7757	15.6875	15.7246	23235996.0
2013-06-11 14:00:00	AAPL	Stock	15.7246	15.7482	15.6964	15.7446	21947436.0
2013-06-11 15:00:00	AAPL	Stock	15.7429	15.7561	15.62	15.6314	39554256.0
2013-06-11 16:00:00	AAPL	Stock	15.6286	15.7367	15.625	15.6286	5778052.0
2013-06-11 17:00:00	AAPL	Stock	15.6418	15.6446	15.6357	15.6393	184688.0
2013-06-11 18:00:00	AAPL	Stock	15.6404	15.6404	15.6393	15.6393	5600.0
2013-06-11 19:00:00	AAPL	Stock	15.6429	15.6482	15.6393	15.6482	272244.0
2013-06-11 07:00:00	MSFT	Stock	35.19	35.2	35.19	35.2	1016.0
2013-06-11 08:00:00	MSFT	Stock	35.5	35.5	35.11	35.11	69514.0
2013-06-11 09:00:00	MSFT	Stock	35.15	35.15	34.81	34.945	5630149.0
2013-06-11 10:00:00	MSFT	Stock	34.95	34.97	34.68	34.88	7888546.0
2013-06-11 11:00:00	MSFT	Stock	34.89	35.15	34.83	35.1	5770053.0
2013-06-11 12:00:00	MSFT	Stock	35.105	35.18	34.99	35.045	3775661.0
2013-06-11 13:00:00	MSFT	Stock	35.045	35.08	34.86	34.88	3218969.0
2013-06-11 14:00:00	MSFT	Stock	34.87	34.98	34.8	34.98	3825532.0
2013-06-11 15:00:00	MSFT	Stock	34.975	35.01	34.81	34.85	6369136.0
2013-06-11 16:00:00	MSFT	Stock	34.85	35.47	34.84	34.87	1796237.0
2013-06-11 17:00:00	MSFT	Stock	34.833	35.05	34.833	35.05	20385.0
2013-06-11 18:00:00	MSFT	Stock	34.98	34.98	34.87	34.87	417.0
2013-06-11 19:00:00	MSFT	Stock	34.87	34.87	34.87	34.87	1500.0
2013-06-11 09:00:00	NVDA	Stock	0.357	0.3588	0.3555	0.3579	25189160.0
2013-06-11 10:00:00	NVDA	Stock	0.3579	0.3608	0.3565	0.3601	30330000.0
2013-06-11 11:00:00	NVDA	Stock	0.3601	0.3612	0.3588	0.3595	33302440.0
2013-06-11 12:00:00	NVDA	Stock	0.3592	0.3612	0.359	0.361	32310560.0
2013-06-11 13:00:00	NVDA	Stock	0.361	0.3612	0.3565	0.3565	28053520.0
2013-06-11 14:00:00	NVDA	Stock	0.3565	0.3585	0.356	0.3568	30745280.0
2013-06-11 15:00:00	NVDA	Stock	0.357	0.3576	0.3542	0.3545	100996200.0
2013-06-11 16:00:00	NVDA	Stock	0.3542	0.357	0.3542	0.3542	3337760.0
2013-06-11 18:00:00	NVDA	Stock	0.3578	0.3578	0.3578	0.3578	28000.0
2013-06-11 19:00:00	NVDA	Stock	0.355	0.355	0.355	0.355	16000.0
2013-06-11 04:00:00	AMZN	Stock	14.0015	14.0015	13.9555	13.9555	4000.0
2013-06-11 05:00:00	AMZN	Stock	13.86	13.9515	13.86	13.9515	9240.0
2013-06-11 06:00:00	AMZN	Stock	13.92	13.94	13.858	13.8625	34400.0
2013-06-11 07:00:00	AMZN	Stock	13.863	13.863	13.825	13.85	148800.0
2013-06-11 08:00:00	AMZN	Stock	13.8875	14.0535	13.8175	13.851	1230960.0
2013-06-11 09:00:00	AMZN	Stock	13.855	13.89	13.725	13.856	19005220.0
2013-06-11 10:00:00	AMZN	Stock	13.8645	13.9206	13.775	13.822	10463320.0
2013-06-11 11:00:00	AMZN	Stock	13.828	13.8895	13.815	13.828	6263240.0
2013-06-11 12:00:00	AMZN	Stock	13.8292	13.875	13.8205	13.8505	3629500.0
2013-06-11 13:00:00	AMZN	Stock	13.8492	13.865	13.769	13.7795	5091300.0
2013-06-11 14:00:00	AMZN	Stock	13.777	13.82	13.766	13.817	4022440.0
2013-06-11 15:00:00	AMZN	Stock	13.8185	13.836	13.712	13.7435	9755820.0

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

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