PREVIEW / stock_1hour / 2011-12-28

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-12-28.parquet
  size:    924 KB
  rows:    44,561
  symbols: 3,558

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-12-28 04:00:00	AAPL	Stock	14.4779	14.4829	14.4643	14.4829	14000.0
2011-12-28 05:00:00	AAPL	Stock	14.475	14.5036	14.475	14.5036	16800.0
2011-12-28 06:00:00	AAPL	Stock	14.5357	14.5357	14.5357	14.5357	2800.0
2011-12-28 07:00:00	AAPL	Stock	14.5382	14.58	14.5268	14.5446	494480.0
2011-12-28 08:00:00	AAPL	Stock	14.5536	14.5732	14.5464	14.5661	925400.0
2011-12-28 09:00:00	AAPL	Stock	14.5661	14.5804	14.4464	14.4625	48714904.0
2011-12-28 10:00:00	AAPL	Stock	14.465	14.5032	14.4464	14.4575	37656416.0
2011-12-28 11:00:00	AAPL	Stock	14.4571	14.4871	14.4464	14.4518	30416484.0
2011-12-28 12:00:00	AAPL	Stock	14.4518	14.465	14.4	14.4175	24542560.0
2011-12-28 13:00:00	AAPL	Stock	14.4154	14.4464	14.4075	14.4404	13221572.0
2011-12-28 14:00:00	AAPL	Stock	14.4421	14.4427	14.4161	14.4254	13930196.0
2011-12-28 15:00:00	AAPL	Stock	14.4254	14.4307	14.3336	14.3846	49267148.0
2011-12-28 16:00:00	AAPL	Stock	14.3779	14.4477	14.3757	14.395	6316604.0
2011-12-28 17:00:00	AAPL	Stock	14.3893	14.3975	14.3875	14.3889	85736.0
2011-12-28 18:00:00	AAPL	Stock	14.3875	14.3929	14.38	14.3893	192920.0
2011-12-28 19:00:00	AAPL	Stock	14.3921	14.3964	14.3875	14.3929	192948.0
2011-12-28 06:00:00	MSFT	Stock	26.02	26.02	26.02	26.02	200.0
2011-12-28 07:00:00	MSFT	Stock	26.08	26.08	26.04	26.04	1200.0
2011-12-28 08:00:00	MSFT	Stock	26.06	26.14	26.05	26.14	14341.0
2011-12-28 09:00:00	MSFT	Stock	26.14	26.15	25.83	25.88	3570394.0
2011-12-28 10:00:00	MSFT	Stock	25.88	26.03	25.88	25.985	3531354.0
2011-12-28 11:00:00	MSFT	Stock	25.985	26.01	25.9	25.959	3329565.0
2011-12-28 12:00:00	MSFT	Stock	25.96	26.02	25.85	25.855	3098378.0
2011-12-28 13:00:00	MSFT	Stock	25.86	25.95	25.85	25.928	1905740.0
2011-12-28 14:00:00	MSFT	Stock	25.925	25.94	25.86	25.88	2749430.0
2011-12-28 15:00:00	MSFT	Stock	25.87	25.89	25.76	25.82	6851658.0
2011-12-28 16:00:00	MSFT	Stock	25.815	25.939	25.8	25.82	4222241.0
2011-12-28 17:00:00	MSFT	Stock	25.85	25.85	25.81	25.85	4900.0
2011-12-28 18:00:00	MSFT	Stock	25.89	25.89	25.82	25.87	28302.0
2011-12-28 19:00:00	MSFT	Stock	25.81	25.81	25.81	25.81	300.0
2011-12-28 08:00:00	NVDA	Stock	0.3525	0.3525	0.3525	0.3525	60000.0
2011-12-28 09:00:00	NVDA	Stock	0.3515	0.3522	0.3468	0.348	23212120.0
2011-12-28 10:00:00	NVDA	Stock	0.348	0.35	0.3453	0.3455	36261800.0
2011-12-28 11:00:00	NVDA	Stock	0.3453	0.346	0.3435	0.3442	34034400.0
2011-12-28 12:00:00	NVDA	Stock	0.3442	0.346	0.3438	0.345	24981200.0
2011-12-28 13:00:00	NVDA	Stock	0.345	0.3473	0.3448	0.3465	16478280.0
2011-12-28 14:00:00	NVDA	Stock	0.3465	0.3465	0.3438	0.344	28565360.0
2011-12-28 15:00:00	NVDA	Stock	0.344	0.345	0.3425	0.3428	61962040.0
2011-12-28 16:00:00	NVDA	Stock	0.3428	0.3455	0.3426	0.3442	7906840.0
2011-12-28 19:00:00	NVDA	Stock	0.3468	0.3468	0.3468	0.3468	8000.0
2011-12-28 05:00:00	AMZN	Stock	8.84	8.84	8.84	8.84	2000.0
2011-12-28 07:00:00	AMZN	Stock	8.851	8.851	8.8485	8.8485	6000.0
2011-12-28 08:00:00	AMZN	Stock	8.8405	8.8675	8.8175	8.8405	151000.0
2011-12-28 09:00:00	AMZN	Stock	8.8485	8.85	8.6646	8.6795	13264200.0
2011-12-28 10:00:00	AMZN	Stock	8.6805	8.705	8.614	8.6385	13731020.0
2011-12-28 11:00:00	AMZN	Stock	8.635	8.6995	8.634	8.6595	8114120.0
2011-12-28 12:00:00	AMZN	Stock	8.6604	8.67	8.6365	8.6655	6270460.0
2011-12-28 13:00:00	AMZN	Stock	8.6635	8.739	8.6628	8.739	6880320.0
2011-12-28 14:00:00	AMZN	Stock	8.739	8.75	8.6875	8.706	7789600.0
2011-12-28 15:00:00	AMZN	Stock	8.7055	8.737	8.664	8.698	14082780.0

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

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