PREVIEW / stock_1hour / 2010-01-26

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-01-26.parquet
  size:    898 KB
  rows:    42,702
  symbols: 3,444

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-01-26 04:00:00	AAPL	Stock	7.3554	7.3932	7.3375	7.3932	92344.0
2010-01-26 05:00:00	AAPL	Stock	7.3914	7.3946	7.3682	7.3718	64400.0
2010-01-26 06:00:00	AAPL	Stock	7.3714	7.3736	7.3521	7.3521	264684.0
2010-01-26 07:00:00	AAPL	Stock	7.3618	7.4764	7.3521	7.4496	4855508.0
2010-01-26 08:00:00	AAPL	Stock	7.4343	7.4464	7.3771	7.4039	21239092.0
2010-01-26 09:00:00	AAPL	Stock	7.4043	7.4068	7.235	7.3043	267494892.0
2010-01-26 10:00:00	AAPL	Stock	7.3071	7.4246	7.2654	7.385	242015648.0
2010-01-26 11:00:00	AAPL	Stock	7.3854	7.5279	7.375	7.5221	184111368.0
2010-01-26 12:00:00	AAPL	Stock	7.5218	7.6325	7.5096	7.5975	282306052.0
2010-01-26 13:00:00	AAPL	Stock	7.5971	7.6214	7.54	7.59	164633532.0
2010-01-26 14:00:00	AAPL	Stock	7.5893	7.5929	7.4346	7.4832	250805100.0
2010-01-26 15:00:00	AAPL	Stock	7.4832	7.4964	7.2964	7.3532	327176640.0
2010-01-26 16:00:00	AAPL	Stock	7.3532	7.5681	7.2584	7.3675	13621832.0
2010-01-26 17:00:00	AAPL	Stock	7.3686	7.5814	7.3554	7.3554	4147808.0
2010-01-26 18:00:00	AAPL	Stock	7.3543	7.3839	7.3536	7.37	2428048.0
2010-01-26 19:00:00	AAPL	Stock	7.3707	7.375	7.365	7.375	1197392.0
2010-01-26 04:00:00	MSFT	Stock	29.2	29.2	29.2	29.2	125.0
2010-01-26 05:00:00	MSFT	Stock	29.13	29.13	29.13	29.13	300.0
2010-01-26 06:00:00	MSFT	Stock	29.13	29.16	29.13	29.16	2100.0
2010-01-26 07:00:00	MSFT	Stock	29.19	29.35	29.19	29.35	12745.0
2010-01-26 08:00:00	MSFT	Stock	29.36	29.48	29.32	29.32	33595.0
2010-01-26 09:00:00	MSFT	Stock	29.31	29.35	29.09	29.25	7553407.0
2010-01-26 10:00:00	MSFT	Stock	29.22	29.61	29.21	29.46	10959833.0
2010-01-26 11:00:00	MSFT	Stock	29.46	29.79	29.45	29.77	8851634.0
2010-01-26 12:00:00	MSFT	Stock	29.76	29.84	29.71	29.82	5479922.0
2010-01-26 13:00:00	MSFT	Stock	29.83	29.85	29.76	29.83	6730443.0
2010-01-26 14:00:00	MSFT	Stock	29.83	29.84	29.56	29.702	6639796.0
2010-01-26 15:00:00	MSFT	Stock	29.71	29.74	29.482	29.5	12843902.0
2010-01-26 16:00:00	MSFT	Stock	29.5	29.58	29.29	29.49	6000271.0
2010-01-26 17:00:00	MSFT	Stock	29.54	29.59	29.47	29.58	12644.0
2010-01-26 18:00:00	MSFT	Stock	29.54	29.57	29.5	29.53	14331.0
2010-01-26 19:00:00	MSFT	Stock	29.53	29.6	29.5	29.6	4838.0
2010-01-26 04:00:00	NVDA	Stock	0.422	0.422	0.422	0.422	4000.0
2010-01-26 08:00:00	NVDA	Stock	0.4155	0.42	0.4155	0.4185	200160.0
2010-01-26 09:00:00	NVDA	Stock	0.4165	0.4175	0.4098	0.4122	67933160.0
2010-01-26 10:00:00	NVDA	Stock	0.4125	0.4192	0.411	0.4121	88216080.0
2010-01-26 11:00:00	NVDA	Stock	0.4122	0.4142	0.411	0.4115	89606280.0
2010-01-26 12:00:00	NVDA	Stock	0.4115	0.414	0.4108	0.4136	79177640.0
2010-01-26 13:00:00	NVDA	Stock	0.4138	0.4162	0.4129	0.4135	100539840.0
2010-01-26 14:00:00	NVDA	Stock	0.4135	0.4142	0.4102	0.4125	98023240.0
2010-01-26 15:00:00	NVDA	Stock	0.4125	0.4128	0.405	0.4053	165053920.0
2010-01-26 16:00:00	NVDA	Stock	0.4053	0.415	0.4052	0.4053	10916200.0
2010-01-26 17:00:00	NVDA	Stock	0.4185	0.4185	0.405	0.405	464600.0
2010-01-26 18:00:00	NVDA	Stock	0.4058	0.4058	0.405	0.4053	11866480.0
2010-01-26 19:00:00	NVDA	Stock	0.406	0.4062	0.405	0.4062	42000.0
2010-01-26 07:00:00	AMZN	Stock	5.9945	6.079	5.9945	6.0695	72320.0
2010-01-26 08:00:00	AMZN	Stock	6.0525	6.0985	6.0505	6.061	612320.0
2010-01-26 09:00:00	AMZN	Stock	6.053	6.0985	5.968	6.097	33381220.0
2010-01-26 10:00:00	AMZN	Stock	6.094	6.149	6.0565	6.0712	41723680.0
2010-01-26 11:00:00	AMZN	Stock	6.071	6.078	6.023	6.042	26250060.0

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

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