PREVIEW / stock_1hour / 2008-06-05

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-06-05.parquet
  size:    842 KB
  rows:    40,310
  symbols: 3,298

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-06-05 06:00:00	AAPL	Stock	6.6293	6.6293	6.6189	6.6189	5600.0
2008-06-05 07:00:00	AAPL	Stock	6.6161	6.7229	6.6161	6.6879	192780.0
2008-06-05 08:00:00	AAPL	Stock	6.6661	6.6836	6.6543	6.6661	3729992.0
2008-06-05 09:00:00	AAPL	Stock	6.6664	6.7036	6.6321	6.6932	92565088.0
2008-06-05 10:00:00	AAPL	Stock	6.6932	6.7011	6.6686	6.6938	115750208.0
2008-06-05 11:00:00	AAPL	Stock	6.6939	6.7457	6.6914	6.7382	109938024.0
2008-06-05 12:00:00	AAPL	Stock	6.7386	6.755	6.7143	6.7266	86238068.0
2008-06-05 13:00:00	AAPL	Stock	6.7257	6.7457	6.7157	6.7425	59824940.0
2008-06-05 14:00:00	AAPL	Stock	6.7425	6.7557	6.7029	6.7375	119855596.0
2008-06-05 15:00:00	AAPL	Stock	6.7375	6.78	6.7339	6.7632	140459732.0
2008-06-05 16:00:00	AAPL	Stock	6.7607	6.7696	6.7206	6.7657	11450320.0
2008-06-05 17:00:00	AAPL	Stock	6.7657	6.7818	6.6139	6.7814	2560376.0
2008-06-05 18:00:00	AAPL	Stock	6.7793	6.7825	6.7786	6.7786	669648.0
2008-06-05 19:00:00	AAPL	Stock	6.7789	6.7832	6.7786	6.7832	422212.0
2008-06-05 07:00:00	MSFT	Stock	27.6	27.6	27.6	27.6	400.0
2008-06-05 08:00:00	MSFT	Stock	27.68	27.8	27.65	27.75	105946.0
2008-06-05 09:00:00	MSFT	Stock	27.77	28.02	27.6	28.01	10200464.0
2008-06-05 10:00:00	MSFT	Stock	28.002	28.3	28.0	28.1	18044456.0
2008-06-05 11:00:00	MSFT	Stock	28.092	28.15	28.03	28.08	7225606.0
2008-06-05 12:00:00	MSFT	Stock	28.08	28.21	28.02	28.152	7802975.0
2008-06-05 13:00:00	MSFT	Stock	28.16	28.18	28.03	28.06	5001612.0
2008-06-05 14:00:00	MSFT	Stock	28.055	28.14	27.98	28.138	7808534.0
2008-06-05 15:00:00	MSFT	Stock	28.13	28.3	28.1	28.21	12936569.0
2008-06-05 16:00:00	MSFT	Stock	28.2	28.31	27.54	28.25	5310150.0
2008-06-05 17:00:00	MSFT	Stock	28.24	28.3	28.23	28.26	24371.0
2008-06-05 18:00:00	MSFT	Stock	28.28	28.3	28.27	28.29	35786.0
2008-06-05 19:00:00	MSFT	Stock	28.28	28.32	28.28	28.31	4396.0
2008-06-05 07:00:00	NVDA	Stock	0.6313	0.6375	0.625	0.625	1009960.0
2008-06-05 08:00:00	NVDA	Stock	0.6268	0.635	0.62	0.6325	8200760.0
2008-06-05 09:00:00	NVDA	Stock	0.6315	0.6372	0.6213	0.6245	133838440.0
2008-06-05 10:00:00	NVDA	Stock	0.6242	0.6265	0.6175	0.621	169476000.0
2008-06-05 11:00:00	NVDA	Stock	0.6208	0.6238	0.6143	0.6208	94347720.0
2008-06-05 12:00:00	NVDA	Stock	0.6207	0.6245	0.6188	0.6242	62740960.0
2008-06-05 13:00:00	NVDA	Stock	0.6242	0.627	0.6235	0.6235	67773080.0
2008-06-05 14:00:00	NVDA	Stock	0.6238	0.6238	0.6178	0.6218	78185160.0
2008-06-05 15:00:00	NVDA	Stock	0.6218	0.6263	0.6205	0.6225	114486720.0
2008-06-05 16:00:00	NVDA	Stock	0.6225	0.6242	0.606	0.6213	52603440.0
2008-06-05 17:00:00	NVDA	Stock	0.6238	0.6242	0.6213	0.6242	232640.0
2008-06-05 18:00:00	NVDA	Stock	0.6242	0.626	0.6238	0.626	322080.0
2008-06-05 19:00:00	NVDA	Stock	0.6238	0.6238	0.6238	0.6238	57280.0
2008-06-05 04:00:00	AMZN	Stock	4.09	4.095	4.09	4.095	8000.0
2008-06-05 08:00:00	AMZN	Stock	4.097	4.1125	4.097	4.1125	348100.0
2008-06-05 09:00:00	AMZN	Stock	4.115	4.185	4.09	4.183	31479480.0
2008-06-05 10:00:00	AMZN	Stock	4.183	4.2265	4.16	4.2175	41547420.0
2008-06-05 11:00:00	AMZN	Stock	4.218	4.2205	4.1905	4.217	20902100.0
2008-06-05 12:00:00	AMZN	Stock	4.217	4.2245	4.1935	4.1976	15586520.0
2008-06-05 13:00:00	AMZN	Stock	4.198	4.207	4.19	4.1975	13842900.0
2008-06-05 14:00:00	AMZN	Stock	4.197	4.218	4.1765	4.209	15215160.0
2008-06-05 15:00:00	AMZN	Stock	4.2095	4.244	4.194	4.2255	35485240.0
2008-06-05 16:00:00	AMZN	Stock	4.2235	4.253	4.075	4.253	1570220.0

> showing 50 of 40,310 rows — these rows as CSV

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