PREVIEW / stock_1hour / 2010-01-19

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-01-19.parquet
  size:    925 KB
  rows:    44,199
  symbols: 3,467

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-19 04:00:00	AAPL	Stock	7.4446	7.4446	7.42	7.4289	18620.0
2010-01-19 05:00:00	AAPL	Stock	7.42	7.42	7.3982	7.4057	24220.0
2010-01-19 06:00:00	AAPL	Stock	7.4057	7.4139	7.4021	7.4021	49028.0
2010-01-19 07:00:00	AAPL	Stock	7.4154	7.4386	7.4007	7.4093	521976.0
2010-01-19 08:00:00	AAPL	Stock	7.4107	7.4286	7.3546	7.415	3794952.0
2010-01-19 09:00:00	AAPL	Stock	7.4096	7.5368	7.3957	7.5268	103834780.0
2010-01-19 10:00:00	AAPL	Stock	7.5268	7.5954	7.5268	7.5796	122563028.0
2010-01-19 11:00:00	AAPL	Stock	7.58	7.6279	7.5768	7.6147	84061656.0
2010-01-19 12:00:00	AAPL	Stock	7.6146	7.6518	7.6146	7.6382	78444856.0
2010-01-19 13:00:00	AAPL	Stock	7.6375	7.6639	7.6214	7.6575	89466048.0
2010-01-19 14:00:00	AAPL	Stock	7.6572	7.6679	7.648	7.6625	52603768.0
2010-01-19 15:00:00	AAPL	Stock	7.6618	7.6854	7.6486	7.68	116897872.0
2010-01-19 16:00:00	AAPL	Stock	7.6825	7.6946	7.5315	7.6564	17639048.0
2010-01-19 17:00:00	AAPL	Stock	7.6557	7.68	7.3577	7.6521	4469668.0
2010-01-19 18:00:00	AAPL	Stock	7.6518	7.68	7.6518	7.6571	444164.0
2010-01-19 19:00:00	AAPL	Stock	7.6611	7.6625	7.6518	7.6579	472052.0
2010-01-19 06:00:00	MSFT	Stock	30.72	30.74	30.72	30.74	2000.0
2010-01-19 07:00:00	MSFT	Stock	30.65	30.72	30.53	30.65	17667.0
2010-01-19 08:00:00	MSFT	Stock	30.68	30.86	30.57	30.72	154390.0
2010-01-19 09:00:00	MSFT	Stock	30.72	31.15	30.68	31.02	5807761.0
2010-01-19 10:00:00	MSFT	Stock	31.01	31.2	30.97	31.18	7772972.0
2010-01-19 11:00:00	MSFT	Stock	31.178	31.18	31.02	31.04	4486846.0
2010-01-19 12:00:00	MSFT	Stock	31.04	31.19	31.035	31.17	2741941.0
2010-01-19 13:00:00	MSFT	Stock	31.17	31.19	31.1	31.19	3219013.0
2010-01-19 14:00:00	MSFT	Stock	31.18	31.24	31.06	31.11	5146777.0
2010-01-19 15:00:00	MSFT	Stock	31.11	31.13	31.04	31.1	9814198.0
2010-01-19 16:00:00	MSFT	Stock	31.09	31.23	30.95	31.0	5548187.0
2010-01-19 17:00:00	MSFT	Stock	30.947	31.1	30.947	31.04	503808.0
2010-01-19 18:00:00	MSFT	Stock	31.04	31.04	30.98	30.98	3165.0
2010-01-19 19:00:00	MSFT	Stock	31.04	31.05	30.99	31.0	4040.0
2010-01-19 04:00:00	NVDA	Stock	0.402	0.402	0.3935	0.3935	18520.0
2010-01-19 08:00:00	NVDA	Stock	0.425	0.4295	0.4248	0.4288	477880.0
2010-01-19 09:00:00	NVDA	Stock	0.4293	0.4362	0.4232	0.435	95729680.0
2010-01-19 10:00:00	NVDA	Stock	0.435	0.4385	0.4315	0.4355	117365360.0
2010-01-19 11:00:00	NVDA	Stock	0.4352	0.4355	0.433	0.4335	56120920.0
2010-01-19 12:00:00	NVDA	Stock	0.4338	0.435	0.4335	0.4347	37736120.0
2010-01-19 13:00:00	NVDA	Stock	0.4345	0.4371	0.434	0.437	40655400.0
2010-01-19 14:00:00	NVDA	Stock	0.4368	0.437	0.4345	0.4368	34612320.0
2010-01-19 15:00:00	NVDA	Stock	0.437	0.438	0.4348	0.4358	134243320.0
2010-01-19 16:00:00	NVDA	Stock	0.437	0.437	0.4335	0.4335	1122720.0
2010-01-19 17:00:00	NVDA	Stock	0.4299	0.4358	0.4298	0.4308	12786760.0
2010-01-19 18:00:00	NVDA	Stock	0.4325	0.4325	0.4325	0.4325	8000.0
2010-01-19 04:00:00	AMZN	Stock	6.2875	6.2875	6.2875	6.2875	2000.0
2010-01-19 06:00:00	AMZN	Stock	6.337	6.3375	6.337	6.3375	4000.0
2010-01-19 07:00:00	AMZN	Stock	6.318	6.318	6.2875	6.3085	24700.0
2010-01-19 08:00:00	AMZN	Stock	6.318	6.357	6.3	6.3165	431920.0
2010-01-19 09:00:00	AMZN	Stock	6.3165	6.32	6.2165	6.2915	43783880.0
2010-01-19 10:00:00	AMZN	Stock	6.2915	6.3495	6.272	6.2895	31590740.0
2010-01-19 11:00:00	AMZN	Stock	6.29	6.4	6.2675	6.3408	29767440.0
2010-01-19 12:00:00	AMZN	Stock	6.341	6.389	6.3395	6.3825	13233780.0

> showing 50 of 44,199 rows — these rows as CSV

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