PREVIEW / stock_1hour / 2010-09-24

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-09-24.parquet
  size:    942 KB
  rows:    45,205
  symbols: 3,486

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
2010-09-24 06:00:00	AAPL	Stock	10.3557	10.3557	10.3554	10.3554	19600.0
2010-09-24 07:00:00	AAPL	Stock	10.3557	10.3889	10.3557	10.3868	199696.0
2010-09-24 08:00:00	AAPL	Stock	10.375	10.4454	10.37	10.43	6920396.0
2010-09-24 09:00:00	AAPL	Stock	10.4318	10.4832	10.3979	10.4348	149531256.0
2010-09-24 10:00:00	AAPL	Stock	10.4396	10.4679	10.4004	10.4325	125096272.0
2010-09-24 11:00:00	AAPL	Stock	10.4325	10.4657	10.4243	10.4629	74079908.0
2010-09-24 12:00:00	AAPL	Stock	10.4629	10.4654	10.44	10.4532	38803016.0
2010-09-24 13:00:00	AAPL	Stock	10.4536	10.4571	10.4289	10.4329	39145456.0
2010-09-24 14:00:00	AAPL	Stock	10.4343	10.4411	10.3768	10.4057	83934060.0
2010-09-24 15:00:00	AAPL	Stock	10.4061	10.4468	10.3829	10.4457	103995388.0
2010-09-24 16:00:00	AAPL	Stock	10.445	10.4621	10.3946	10.4618	19712532.0
2010-09-24 17:00:00	AAPL	Stock	10.4607	10.4743	10.4094	10.4714	3954524.0
2010-09-24 18:00:00	AAPL	Stock	10.4711	10.4718	10.4575	10.4596	356020.0
2010-09-24 19:00:00	AAPL	Stock	10.4596	10.4607	10.44	10.4536	580328.0
2010-09-24 05:00:00	MSFT	Stock	24.64	24.65	24.64	24.65	400.0
2010-09-24 07:00:00	MSFT	Stock	24.54	24.61	24.54	24.58	8826.0
2010-09-24 08:00:00	MSFT	Stock	24.56	24.65	24.49	24.63	86797.0
2010-09-24 09:00:00	MSFT	Stock	24.61	24.74	24.58	24.63	6229082.0
2010-09-24 10:00:00	MSFT	Stock	24.62	24.79	24.61	24.67	11225808.0
2010-09-24 11:00:00	MSFT	Stock	24.675	24.75	24.64	24.72	6040583.0
2010-09-24 12:00:00	MSFT	Stock	24.72	24.75	24.69	24.72	3771238.0
2010-09-24 13:00:00	MSFT	Stock	24.72	24.75	24.68	24.685	4681085.0
2010-09-24 14:00:00	MSFT	Stock	24.68	24.8	24.68	24.75	6198909.0
2010-09-24 15:00:00	MSFT	Stock	24.74	24.78	24.69	24.77	10383862.0
2010-09-24 16:00:00	MSFT	Stock	24.78	24.8	24.705	24.77	2763355.0
2010-09-24 17:00:00	MSFT	Stock	24.78	24.78	24.75	24.75	79246.0
2010-09-24 18:00:00	MSFT	Stock	24.75	24.77	24.75	24.75	1965.0
2010-09-24 19:00:00	MSFT	Stock	24.75	24.77	24.75	24.75	22569.0
2010-09-24 07:00:00	NVDA	Stock	0.2938	0.2962	0.2938	0.295	196000.0
2010-09-24 08:00:00	NVDA	Stock	0.295	0.2972	0.2942	0.297	1490400.0
2010-09-24 09:00:00	NVDA	Stock	0.2955	0.2995	0.2948	0.297	129707840.0
2010-09-24 10:00:00	NVDA	Stock	0.2968	0.298	0.2955	0.2978	140766720.0
2010-09-24 11:00:00	NVDA	Stock	0.2978	0.3018	0.2975	0.3016	134925880.0
2010-09-24 12:00:00	NVDA	Stock	0.3016	0.3075	0.301	0.307	173191280.0
2010-09-24 13:00:00	NVDA	Stock	0.307	0.3073	0.3032	0.3045	141326920.0
2010-09-24 14:00:00	NVDA	Stock	0.3046	0.3075	0.3045	0.3058	107742160.0
2010-09-24 15:00:00	NVDA	Stock	0.3055	0.3075	0.3055	0.3068	231531120.0
2010-09-24 16:00:00	NVDA	Stock	0.3073	0.3095	0.3027	0.3083	10274800.0
2010-09-24 17:00:00	NVDA	Stock	0.2905	0.3088	0.2905	0.3085	1089200.0
2010-09-24 18:00:00	NVDA	Stock	0.3088	0.312	0.3088	0.3093	545600.0
2010-09-24 19:00:00	NVDA	Stock	0.3093	0.3093	0.307	0.3078	431800.0
2010-09-24 07:00:00	AMZN	Stock	7.7045	7.724	7.7045	7.7225	22000.0
2010-09-24 08:00:00	AMZN	Stock	7.725	7.775	7.72	7.763	644420.0
2010-09-24 09:00:00	AMZN	Stock	7.763	7.885	7.751	7.8705	31062380.0
2010-09-24 10:00:00	AMZN	Stock	7.8705	7.94	7.8465	7.9295	37110520.0
2010-09-24 11:00:00	AMZN	Stock	7.929	7.967	7.919	7.9385	19558540.0
2010-09-24 12:00:00	AMZN	Stock	7.938	8.022	7.9325	8.002	25113460.0
2010-09-24 13:00:00	AMZN	Stock	8.0025	8.0445	7.9885	7.9985	23256680.0
2010-09-24 14:00:00	AMZN	Stock	7.9995	8.0375	7.9785	7.981	28253340.0
2010-09-24 15:00:00	AMZN	Stock	7.9808	8.0425	7.9615	8.0405	41224760.0

> showing 50 of 45,205 rows — these rows as CSV

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