PREVIEW / stock_1hour / 2011-09-22

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-09-22.parquet
  size:    958 KB
  rows:    46,428
  symbols: 3,542

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-22 04:00:00	AAPL	Stock	14.525	14.5386	14.4643	14.4896	88396.0
2011-09-22 05:00:00	AAPL	Stock	14.4893	14.4893	14.4643	14.4757	140000.0
2011-09-22 06:00:00	AAPL	Stock	14.4643	14.5107	14.4286	14.4286	201516.0
2011-09-22 07:00:00	AAPL	Stock	14.4286	14.5179	14.4239	14.5089	2342396.0
2011-09-22 08:00:00	AAPL	Stock	14.5079	14.5536	14.3304	14.3682	13560176.0
2011-09-22 09:00:00	AAPL	Stock	14.3679	14.49	14.2857	14.3732	158877936.0
2011-09-22 10:00:00	AAPL	Stock	14.3732	14.6364	14.3546	14.5239	166393304.0
2011-09-22 11:00:00	AAPL	Stock	14.5243	14.58	14.4475	14.4739	88703216.0
2011-09-22 12:00:00	AAPL	Stock	14.4739	14.4982	14.3689	14.475	89031796.0
2011-09-22 13:00:00	AAPL	Stock	14.4721	14.4814	14.2321	14.2321	117334504.0
2011-09-22 14:00:00	AAPL	Stock	14.2368	14.4	14.2104	14.255	149680804.0
2011-09-22 15:00:00	AAPL	Stock	14.2589	14.4214	14.1679	14.3507	156413796.0
2011-09-22 16:00:00	AAPL	Stock	14.3742	14.3932	14.2567	14.3929	18152176.0
2011-09-22 17:00:00	AAPL	Stock	14.5355	14.5355	14.3507	14.375	1034320.0
2011-09-22 18:00:00	AAPL	Stock	14.3929	14.3982	14.3507	14.375	425236.0
2011-09-22 19:00:00	AAPL	Stock	14.3864	14.3929	14.3571	14.3875	541660.0
2011-09-22 04:00:00	MSFT	Stock	25.77	25.77	25.57	25.57	400.0
2011-09-22 05:00:00	MSFT	Stock	25.6	25.6	25.6	25.6	650.0
2011-09-22 06:00:00	MSFT	Stock	25.55	25.55	25.35	25.35	12435.0
2011-09-22 07:00:00	MSFT	Stock	25.34	25.52	25.31	25.43	21243.0
2011-09-22 08:00:00	MSFT	Stock	25.44	25.52	25.25	25.26	65026.0
2011-09-22 09:00:00	MSFT	Stock	25.28	25.65	25.16	25.25	8738392.0
2011-09-22 10:00:00	MSFT	Stock	25.24	25.51	25.24	25.31	11147062.0
2011-09-22 11:00:00	MSFT	Stock	25.3	25.35	25.07	25.11	11810743.0
2011-09-22 12:00:00	MSFT	Stock	25.11	25.24	25.03	25.185	7087094.0
2011-09-22 13:00:00	MSFT	Stock	25.19	25.2	24.71	24.72	10261238.0
2011-09-22 14:00:00	MSFT	Stock	24.725	25.1	24.7	24.89	14872323.0
2011-09-22 15:00:00	MSFT	Stock	24.89	25.23	24.6	25.06	25182757.0
2011-09-22 16:00:00	MSFT	Stock	25.088	25.14	24.749	25.1	4378242.0
2011-09-22 17:00:00	MSFT	Stock	25.08	25.345	25.06	25.11	67226.0
2011-09-22 18:00:00	MSFT	Stock	25.12	25.19	25.06	25.19	81343.0
2011-09-22 19:00:00	MSFT	Stock	25.18	25.2	25.17	25.19	2874.0
2011-09-22 04:00:00	NVDA	Stock	0.361	0.361	0.361	0.361	20000.0
2011-09-22 05:00:00	NVDA	Stock	0.361	0.361	0.3572	0.3572	40000.0
2011-09-22 06:00:00	NVDA	Stock	0.3553	0.3553	0.3553	0.3553	20520.0
2011-09-22 07:00:00	NVDA	Stock	0.3498	0.3513	0.347	0.347	240000.0
2011-09-22 08:00:00	NVDA	Stock	0.346	0.3538	0.345	0.345	2561840.0
2011-09-22 09:00:00	NVDA	Stock	0.345	0.348	0.3318	0.3353	206211000.0
2011-09-22 10:00:00	NVDA	Stock	0.3353	0.3435	0.3348	0.34	241555880.0
2011-09-22 11:00:00	NVDA	Stock	0.3398	0.3413	0.333	0.3362	160515000.0
2011-09-22 12:00:00	NVDA	Stock	0.3362	0.3398	0.3313	0.3385	124331920.0
2011-09-22 13:00:00	NVDA	Stock	0.3388	0.3398	0.3328	0.3328	102843800.0
2011-09-22 14:00:00	NVDA	Stock	0.333	0.3388	0.3315	0.334	168953760.0
2011-09-22 15:00:00	NVDA	Stock	0.334	0.3405	0.3313	0.3378	274927160.0
2011-09-22 16:00:00	NVDA	Stock	0.338	0.34	0.3332	0.3395	26828000.0
2011-09-22 17:00:00	NVDA	Stock	0.3395	0.3475	0.3378	0.345	1273040.0
2011-09-22 18:00:00	NVDA	Stock	0.3413	0.3422	0.3378	0.3398	1158280.0
2011-09-22 19:00:00	NVDA	Stock	0.3388	0.3425	0.3382	0.3418	1028680.0
2011-09-22 04:00:00	AMZN	Stock	11.45	11.45	11.45	11.45	4000.0
2011-09-22 05:00:00	AMZN	Stock	11.454	11.454	11.404	11.415	26000.0

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

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