PREVIEW / stock_1hour / 2010-03-03

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-03-03.parquet
  size:    899 KB
  rows:    42,867
  symbols: 3,470

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-03-03 04:00:00	AAPL	Stock	7.445	7.445	7.445	7.445	2800.0
2010-03-03 05:00:00	AAPL	Stock	7.4436	7.4436	7.4436	7.4436	5600.0
2010-03-03 07:00:00	AAPL	Stock	7.4589	7.4589	7.4339	7.4339	106400.0
2010-03-03 08:00:00	AAPL	Stock	7.4421	7.4782	7.4321	7.4709	1660596.0
2010-03-03 09:00:00	AAPL	Stock	7.4661	7.4821	7.4264	7.4761	57976856.0
2010-03-03 10:00:00	AAPL	Stock	7.4761	7.4954	7.4479	7.4868	76586300.0
2010-03-03 11:00:00	AAPL	Stock	7.4879	7.4946	7.4714	7.4889	47042660.0
2010-03-03 12:00:00	AAPL	Stock	7.4886	7.4889	7.4732	7.4826	29727376.0
2010-03-03 13:00:00	AAPL	Stock	7.4831	7.4954	7.475	7.4829	28475664.0
2010-03-03 14:00:00	AAPL	Stock	7.4834	7.4911	7.4432	7.4525	56239848.0
2010-03-03 15:00:00	AAPL	Stock	7.4522	7.4839	7.4436	7.4761	61914132.0
2010-03-03 16:00:00	AAPL	Stock	7.4732	7.4893	7.4714	7.4714	8489936.0
2010-03-03 17:00:00	AAPL	Stock	7.4714	7.4757	7.4714	7.4732	260624.0
2010-03-03 18:00:00	AAPL	Stock	7.4721	7.4754	7.4721	7.4739	68684.0
2010-03-03 19:00:00	AAPL	Stock	7.4739	7.4739	7.4711	7.4721	137480.0
2010-03-03 05:00:00	MSFT	Stock	28.5	28.5	28.5	28.5	400.0
2010-03-03 07:00:00	MSFT	Stock	28.57	28.57	28.52	28.54	2111.0
2010-03-03 08:00:00	MSFT	Stock	28.51	28.59	28.48	28.52	23282.0
2010-03-03 09:00:00	MSFT	Stock	28.52	28.61	28.35	28.45	6430808.0
2010-03-03 10:00:00	MSFT	Stock	28.45	28.59	28.41	28.58	9092698.0
2010-03-03 11:00:00	MSFT	Stock	28.57	28.58	28.46	28.49	6573796.0
2010-03-03 12:00:00	MSFT	Stock	28.48	28.5	28.4	28.431	5487435.0
2010-03-03 13:00:00	MSFT	Stock	28.43	28.52	28.43	28.51	3770807.0
2010-03-03 14:00:00	MSFT	Stock	28.51	28.55	28.37	28.43	7259032.0
2010-03-03 15:00:00	MSFT	Stock	28.43	28.56	28.39	28.46	6756886.0
2010-03-03 16:00:00	MSFT	Stock	28.46	28.515	28.45	28.483	2180760.0
2010-03-03 17:00:00	MSFT	Stock	28.5	28.5	28.46	28.46	285300.0
2010-03-03 18:00:00	MSFT	Stock	28.46	28.46	28.46	28.46	3226.0
2010-03-03 19:00:00	MSFT	Stock	28.46	28.46	28.46	28.46	18239.0
2010-03-03 09:00:00	NVDA	Stock	0.4235	0.4258	0.4222	0.4245	38327600.0
2010-03-03 10:00:00	NVDA	Stock	0.4248	0.4255	0.421	0.423	82864560.0
2010-03-03 11:00:00	NVDA	Stock	0.4232	0.4238	0.422	0.4235	34808880.0
2010-03-03 12:00:00	NVDA	Stock	0.4234	0.4238	0.4188	0.419	28126080.0
2010-03-03 13:00:00	NVDA	Stock	0.4191	0.4205	0.419	0.4194	29674480.0
2010-03-03 14:00:00	NVDA	Stock	0.4195	0.42	0.4128	0.4135	90074480.0
2010-03-03 15:00:00	NVDA	Stock	0.4138	0.417	0.4122	0.4158	88331840.0
2010-03-03 16:00:00	NVDA	Stock	0.4162	0.4194	0.4145	0.4175	705480.0
2010-03-03 17:00:00	NVDA	Stock	0.4165	0.4165	0.4165	0.4165	30000.0
2010-03-03 18:00:00	NVDA	Stock	0.4162	0.4162	0.4158	0.4158	2141160.0
2010-03-03 08:00:00	AMZN	Stock	6.2765	6.2825	6.2505	6.277	83640.0
2010-03-03 09:00:00	AMZN	Stock	6.277	6.282	6.2215	6.2625	18351500.0
2010-03-03 10:00:00	AMZN	Stock	6.2635	6.3415	6.235	6.3385	31745560.0
2010-03-03 11:00:00	AMZN	Stock	6.338	6.347	6.2975	6.2985	15115220.0
2010-03-03 12:00:00	AMZN	Stock	6.298	6.3095	6.284	6.2975	9483660.0
2010-03-03 13:00:00	AMZN	Stock	6.2975	6.3265	6.295	6.3225	13641760.0
2010-03-03 14:00:00	AMZN	Stock	6.3215	6.325	6.2625	6.2733	17436120.0
2010-03-03 15:00:00	AMZN	Stock	6.2711	6.304	6.259	6.2955	21201780.0
2010-03-03 16:00:00	AMZN	Stock	6.2955	6.3045	6.2765	6.3	1350120.0
2010-03-03 17:00:00	AMZN	Stock	6.3025	6.3025	6.3025	6.3025	9000.0
2010-03-03 18:00:00	AMZN	Stock	6.3005	6.3005	6.2975	6.2975	50040.0

> showing 50 of 42,867 rows — these rows as CSV

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