PREVIEW / stock_1hour / 2008-04-22

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-04-22.parquet
  size:    840 KB
  rows:    41,054
  symbols: 3,279

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
2008-04-22 05:00:00	AAPL	Stock	5.9857	6.0129	5.9789	6.0129	11200.0
2008-04-22 06:00:00	AAPL	Stock	6.0125	6.0179	6.0	6.0	73108.0
2008-04-22 07:00:00	AAPL	Stock	5.9993	6.0036	5.9893	5.9893	305620.0
2008-04-22 08:00:00	AAPL	Stock	5.9893	6.0129	5.9468	5.9671	8496964.0
2008-04-22 09:00:00	AAPL	Stock	5.9671	6.0	5.8868	5.9062	176486240.0
2008-04-22 10:00:00	AAPL	Stock	5.9046	5.9082	5.76	5.7968	308615524.0
2008-04-22 11:00:00	AAPL	Stock	5.7968	5.8136	5.7446	5.7611	153815144.0
2008-04-22 12:00:00	AAPL	Stock	5.7604	5.7632	5.6461	5.6786	224704956.0
2008-04-22 13:00:00	AAPL	Stock	5.6786	5.7311	5.6711	5.7175	158637640.0
2008-04-22 14:00:00	AAPL	Stock	5.7179	5.7679	5.7093	5.7339	169182636.0
2008-04-22 15:00:00	AAPL	Stock	5.7339	5.7621	5.7143	5.7214	183104628.0
2008-04-22 16:00:00	AAPL	Stock	5.7275	5.7804	5.7211	5.7446	13849360.0
2008-04-22 17:00:00	AAPL	Stock	5.7446	5.7993	5.7429	5.7975	6041168.0
2008-04-22 18:00:00	AAPL	Stock	5.7982	5.8	5.7214	5.7786	1975204.0
2008-04-22 19:00:00	AAPL	Stock	5.7818	5.7893	5.7779	5.7843	1069516.0
2008-04-22 07:00:00	MSFT	Stock	30.53	30.6	30.53	30.59	6130.0
2008-04-22 08:00:00	MSFT	Stock	30.53	30.61	30.19	30.46	47647.0
2008-04-22 09:00:00	MSFT	Stock	30.46	30.64	30.37	30.46	6716293.0
2008-04-22 10:00:00	MSFT	Stock	30.46	30.7	30.46	30.59	12478362.0
2008-04-22 11:00:00	MSFT	Stock	30.59	30.64	30.2	30.23	12990764.0
2008-04-22 12:00:00	MSFT	Stock	30.24	30.24	29.97	30.08	8109143.0
2008-04-22 13:00:00	MSFT	Stock	30.08	30.15	29.98	30.06	7867370.0
2008-04-22 14:00:00	MSFT	Stock	30.05	30.17	30.0	30.03	7014573.0
2008-04-22 15:00:00	MSFT	Stock	30.03	30.28	30.02	30.27	8854322.0
2008-04-22 16:00:00	MSFT	Stock	30.28	30.42	30.127	30.3	2028119.0
2008-04-22 17:00:00	MSFT	Stock	30.3	30.44	30.25	30.41	130088.0
2008-04-22 18:00:00	MSFT	Stock	30.41	30.46	30.38	30.41	22044.0
2008-04-22 19:00:00	MSFT	Stock	30.4	30.46	30.38	30.46	14026.0
2008-04-22 08:00:00	NVDA	Stock	0.4992	0.4992	0.495	0.495	16000.0
2008-04-22 09:00:00	NVDA	Stock	0.495	0.5	0.4865	0.4888	81705200.0
2008-04-22 10:00:00	NVDA	Stock	0.4885	0.4923	0.4868	0.4888	70632480.0
2008-04-22 11:00:00	NVDA	Stock	0.4888	0.49	0.4822	0.4822	74002200.0
2008-04-22 12:00:00	NVDA	Stock	0.4822	0.4832	0.477	0.478	73139680.0
2008-04-22 13:00:00	NVDA	Stock	0.478	0.4845	0.4778	0.4835	45718000.0
2008-04-22 14:00:00	NVDA	Stock	0.4838	0.487	0.4822	0.4847	89347080.0
2008-04-22 15:00:00	NVDA	Stock	0.4848	0.4885	0.483	0.4878	120565080.0
2008-04-22 16:00:00	NVDA	Stock	0.4878	0.495	0.4846	0.495	7884520.0
2008-04-22 17:00:00	NVDA	Stock	0.4952	0.499	0.4932	0.495	2937600.0
2008-04-22 18:00:00	NVDA	Stock	0.4963	0.4963	0.4942	0.4942	72000.0
2008-04-22 19:00:00	NVDA	Stock	0.497	0.497	0.4942	0.4942	53600.0
2008-04-22 08:00:00	AMZN	Stock	4.009	4.009	3.964	3.964	694860.0
2008-04-22 09:00:00	AMZN	Stock	3.975	3.998	3.918	3.936	17238840.0
2008-04-22 10:00:00	AMZN	Stock	3.933	3.9495	3.8925	3.9205	23929960.0
2008-04-22 11:00:00	AMZN	Stock	3.9205	3.9375	3.9025	3.905	11521060.0
2008-04-22 12:00:00	AMZN	Stock	3.9055	3.9145	3.877	3.904	14800960.0
2008-04-22 13:00:00	AMZN	Stock	3.9045	3.9525	3.9015	3.9385	14805160.0
2008-04-22 14:00:00	AMZN	Stock	3.9375	3.951	3.9275	3.945	15555700.0
2008-04-22 15:00:00	AMZN	Stock	3.946	3.9835	3.9365	3.975	36050880.0
2008-04-22 16:00:00	AMZN	Stock	3.9805	4.0125	3.9351	4.0125	5198380.0
2008-04-22 17:00:00	AMZN	Stock	4.0125	4.0155	4.001	4.0035	43800.0

> showing 50 of 41,054 rows — these rows as CSV

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