PREVIEW / stock_1hour / 2010-06-03

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-06-03.parquet
  size:    890 KB
  rows:    42,822
  symbols: 3,460

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-06-03 04:00:00	AAPL	Stock	9.5575	9.5575	9.4532	9.5	25200.0
2010-06-03 05:00:00	AAPL	Stock	9.5004	9.5179	9.5004	9.5143	14000.0
2010-06-03 06:00:00	AAPL	Stock	9.5143	9.5143	9.4911	9.4911	25732.0
2010-06-03 07:00:00	AAPL	Stock	9.4911	9.5121	9.4786	9.4986	862204.0
2010-06-03 08:00:00	AAPL	Stock	9.4954	9.5032	9.4493	9.4761	3798592.0
2010-06-03 09:00:00	AAPL	Stock	9.4775	9.4839	9.4075	9.4345	101931592.0
2010-06-03 10:00:00	AAPL	Stock	9.4343	9.4343	9.3571	9.4136	117675152.0
2010-06-03 11:00:00	AAPL	Stock	9.4139	9.4439	9.3871	9.3943	74807432.0
2010-06-03 12:00:00	AAPL	Stock	9.3968	9.4032	9.3004	9.3221	91096236.0
2010-06-03 13:00:00	AAPL	Stock	9.3229	9.3786	9.3075	9.3496	57162924.0
2010-06-03 14:00:00	AAPL	Stock	9.35	9.3971	9.3232	9.3736	68995696.0
2010-06-03 15:00:00	AAPL	Stock	9.3739	9.4264	9.3393	9.4036	113666532.0
2010-06-03 16:00:00	AAPL	Stock	9.4068	9.4211	9.3667	9.3918	11182304.0
2010-06-03 17:00:00	AAPL	Stock	9.4268	9.4268	9.3793	9.3907	304864.0
2010-06-03 18:00:00	AAPL	Stock	9.3857	9.3971	9.3841	9.3882	203504.0
2010-06-03 19:00:00	AAPL	Stock	9.3864	9.4018	9.3829	9.4018	367248.0
2010-06-03 07:00:00	MSFT	Stock	26.45	26.45	26.45	26.45	100.0
2010-06-03 08:00:00	MSFT	Stock	26.49	26.59	26.49	26.53	13494.0
2010-06-03 09:00:00	MSFT	Stock	26.52	26.6	26.41	26.6	7622145.0
2010-06-03 10:00:00	MSFT	Stock	26.59	26.67	26.46	26.61	10040832.0
2010-06-03 11:00:00	MSFT	Stock	26.61	26.63	26.5	26.55	5866097.0
2010-06-03 12:00:00	MSFT	Stock	26.54	26.69	26.465	26.65	8371656.0
2010-06-03 13:00:00	MSFT	Stock	26.65	26.81	26.62	26.73	7908602.0
2010-06-03 14:00:00	MSFT	Stock	26.73	26.9	26.66	26.83	6698759.0
2010-06-03 15:00:00	MSFT	Stock	26.83	26.93	26.75	26.85	14953881.0
2010-06-03 16:00:00	MSFT	Stock	26.85	26.926	26.415	26.81	5427745.0
2010-06-03 17:00:00	MSFT	Stock	26.43	26.84	26.43	26.84	900.0
2010-06-03 18:00:00	MSFT	Stock	26.86	26.86	26.86	26.86	38706.0
2010-06-03 19:00:00	MSFT	Stock	26.83	26.85	26.8	26.81	2400.0
2010-06-03 07:00:00	NVDA	Stock	0.318	0.318	0.318	0.318	4000.0
2010-06-03 08:00:00	NVDA	Stock	0.3175	0.318	0.3165	0.3178	786000.0
2010-06-03 09:00:00	NVDA	Stock	0.318	0.318	0.3105	0.3155	117528600.0
2010-06-03 10:00:00	NVDA	Stock	0.3153	0.3153	0.3105	0.3133	131562520.0
2010-06-03 11:00:00	NVDA	Stock	0.3133	0.3148	0.3125	0.3135	57550560.0
2010-06-03 12:00:00	NVDA	Stock	0.3135	0.3135	0.3105	0.3115	41968960.0
2010-06-03 13:00:00	NVDA	Stock	0.3115	0.313	0.3108	0.3123	33309640.0
2010-06-03 14:00:00	NVDA	Stock	0.3123	0.3158	0.312	0.3149	79334160.0
2010-06-03 15:00:00	NVDA	Stock	0.3149	0.3183	0.314	0.3173	109554320.0
2010-06-03 16:00:00	NVDA	Stock	0.3173	0.3184	0.3142	0.3173	2605200.0
2010-06-03 18:00:00	NVDA	Stock	0.316	0.316	0.316	0.316	20000.0
2010-06-03 19:00:00	NVDA	Stock	0.3153	0.3153	0.3153	0.3153	4000.0
2010-06-03 08:00:00	AMZN	Stock	6.3	6.34	6.3	6.328	81000.0
2010-06-03 09:00:00	AMZN	Stock	6.324	6.3335	6.2425	6.323	13035400.0
2010-06-03 10:00:00	AMZN	Stock	6.322	6.3245	6.261	6.317	12996780.0
2010-06-03 11:00:00	AMZN	Stock	6.3175	6.3565	6.295	6.3555	11196280.0
2010-06-03 12:00:00	AMZN	Stock	6.3555	6.3665	6.2836	6.3125	14621820.0
2010-06-03 13:00:00	AMZN	Stock	6.3155	6.35	6.2935	6.3335	6213980.0
2010-06-03 14:00:00	AMZN	Stock	6.331	6.406	6.331	6.3945	13278940.0
2010-06-03 15:00:00	AMZN	Stock	6.3929	6.4575	6.3765	6.4315	30451500.0
2010-06-03 16:00:00	AMZN	Stock	6.431	6.4475	6.352	6.4296	493880.0

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

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