PREVIEW / stock_1hour / 2011-05-12

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-05-12.parquet
  size:    946 KB
  rows:    44,807
  symbols: 3,566

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-05-12 04:00:00	AAPL	Stock	12.3929	12.3929	12.3293	12.3479	11200.0
2011-05-12 05:00:00	AAPL	Stock	12.3457	12.3457	12.3214	12.3214	8400.0
2011-05-12 06:00:00	AAPL	Stock	12.3307	12.3307	12.295	12.3107	55300.0
2011-05-12 07:00:00	AAPL	Stock	12.3214	12.3393	12.3143	12.3336	407904.0
2011-05-12 08:00:00	AAPL	Stock	12.3321	12.3614	12.3186	12.3504	2538984.0
2011-05-12 09:00:00	AAPL	Stock	12.3479	12.3746	12.2339	12.2679	76753012.0
2011-05-12 10:00:00	AAPL	Stock	12.27	12.3389	12.2239	12.2954	66266816.0
2011-05-12 11:00:00	AAPL	Stock	12.2954	12.3557	12.2832	12.3211	35107016.0
2011-05-12 12:00:00	AAPL	Stock	12.3204	12.3411	12.2982	12.3396	17570840.0
2011-05-12 13:00:00	AAPL	Stock	12.3404	12.3661	12.3236	12.3511	31631124.0
2011-05-12 14:00:00	AAPL	Stock	12.3521	12.3971	12.3514	12.37	32135264.0
2011-05-12 15:00:00	AAPL	Stock	12.3693	12.3862	12.35	12.3782	45865148.0
2011-05-12 16:00:00	AAPL	Stock	12.3771	12.3843	12.3094	12.375	8257536.0
2011-05-12 17:00:00	AAPL	Stock	12.3732	12.3764	12.3536	12.36	757596.0
2011-05-12 18:00:00	AAPL	Stock	12.3539	12.3775	12.34	12.3525	787948.0
2011-05-12 19:00:00	AAPL	Stock	12.3546	12.3571	12.3482	12.3539	103040.0
2011-05-12 06:00:00	MSFT	Stock	25.17	25.17	25.17	25.17	100.0
2011-05-12 07:00:00	MSFT	Stock	25.15	25.22	25.15	25.22	1600.0
2011-05-12 08:00:00	MSFT	Stock	25.21	25.36	25.19	25.25	35757.0
2011-05-12 09:00:00	MSFT	Stock	25.25	25.42	25.2	25.275	8115626.0
2011-05-12 10:00:00	MSFT	Stock	25.275	25.37	25.18	25.21	12212861.0
2011-05-12 11:00:00	MSFT	Stock	25.21	25.21	25.1	25.13	13680460.0
2011-05-12 12:00:00	MSFT	Stock	25.13	25.22	25.11	25.197	6389030.0
2011-05-12 13:00:00	MSFT	Stock	25.2	25.32	25.19	25.29	8230350.0
2011-05-12 14:00:00	MSFT	Stock	25.3	25.33	25.21	25.23	9663350.0
2011-05-12 15:00:00	MSFT	Stock	25.22	25.32	25.21	25.32	11906045.0
2011-05-12 16:00:00	MSFT	Stock	25.32	25.36	25.188	25.3	2381267.0
2011-05-12 17:00:00	MSFT	Stock	25.3	25.3	25.29	25.29	14750.0
2011-05-12 18:00:00	MSFT	Stock	25.32	25.32	25.3	25.3	18175.0
2011-05-12 19:00:00	MSFT	Stock	25.33	25.33	25.33	25.33	200.0
2011-05-12 06:00:00	NVDA	Stock	0.4902	0.4902	0.425	0.4875	30000.0
2011-05-12 07:00:00	NVDA	Stock	0.4875	0.4875	0.4875	0.4875	16000.0
2011-05-12 08:00:00	NVDA	Stock	0.489	0.4968	0.4878	0.49	355400.0
2011-05-12 09:00:00	NVDA	Stock	0.4912	0.5075	0.491	0.506	188774040.0
2011-05-12 10:00:00	NVDA	Stock	0.506	0.5082	0.4988	0.4998	194530640.0
2011-05-12 11:00:00	NVDA	Stock	0.4998	0.506	0.4992	0.5025	109002040.0
2011-05-12 12:00:00	NVDA	Stock	0.5025	0.5045	0.5018	0.504	68628640.0
2011-05-12 13:00:00	NVDA	Stock	0.5043	0.5088	0.5038	0.5058	86658680.0
2011-05-12 14:00:00	NVDA	Stock	0.5056	0.5075	0.5025	0.5035	87633520.0
2011-05-12 15:00:00	NVDA	Stock	0.5035	0.513	0.5028	0.5122	348232880.0
2011-05-12 16:00:00	NVDA	Stock	0.5122	0.5375	0.5052	0.5138	108341120.0
2011-05-12 17:00:00	NVDA	Stock	0.5138	0.5138	0.4952	0.497	19335960.0
2011-05-12 18:00:00	NVDA	Stock	0.4965	0.5003	0.496	0.498	8629320.0
2011-05-12 19:00:00	NVDA	Stock	0.4965	0.4985	0.495	0.4972	2925040.0
2011-05-12 04:00:00	AMZN	Stock	10.14	10.14	10.14	10.14	2000.0
2011-05-12 06:00:00	AMZN	Stock	10.1055	10.1055	10.0855	10.0855	12000.0
2011-05-12 07:00:00	AMZN	Stock	10.106	10.1625	10.1	10.1625	128000.0
2011-05-12 08:00:00	AMZN	Stock	10.1625	10.1695	10.1405	10.1505	65000.0
2011-05-12 09:00:00	AMZN	Stock	10.1505	10.275	10.031	10.1635	18750660.0
2011-05-12 10:00:00	AMZN	Stock	10.1595	10.2425	10.132	10.179	19302300.0

> showing 50 of 44,807 rows — these rows as CSV

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