PREVIEW / stock_1hour / 2010-01-15

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-01-15.parquet
  size:    898 KB
  rows:    42,720
  symbols: 3,439

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-15 06:00:00	AAPL	Stock	7.5086	7.5232	7.5086	7.5232	8400.0
2010-01-15 07:00:00	AAPL	Stock	7.4918	7.4918	7.4639	7.4657	189224.0
2010-01-15 08:00:00	AAPL	Stock	7.4761	7.5	7.4721	7.4854	868448.0
2010-01-15 09:00:00	AAPL	Stock	7.4861	7.5571	7.4764	7.4975	86403128.0
2010-01-15 10:00:00	AAPL	Stock	7.4999	7.5068	7.4139	7.4429	114995496.0
2010-01-15 11:00:00	AAPL	Stock	7.4432	7.4514	7.3964	7.405	53595780.0
2010-01-15 12:00:00	AAPL	Stock	7.405	7.4204	7.3621	7.3791	66011512.0
2010-01-15 13:00:00	AAPL	Stock	7.3804	7.41	7.3764	7.4089	44800224.0
2010-01-15 14:00:00	AAPL	Stock	7.4096	7.4182	7.3907	7.3963	44982084.0
2010-01-15 15:00:00	AAPL	Stock	7.3963	7.4089	7.3525	7.3536	115408076.0
2010-01-15 16:00:00	AAPL	Stock	7.3536	7.4349	7.3502	7.3607	16145276.0
2010-01-15 17:00:00	AAPL	Stock	7.3571	7.3614	7.3504	7.3536	357420.0
2010-01-15 18:00:00	AAPL	Stock	7.3525	7.3643	7.3525	7.3625	164024.0
2010-01-15 19:00:00	AAPL	Stock	7.3625	7.3629	7.3571	7.3571	137452.0
2010-01-15 04:00:00	MSFT	Stock	31.16	31.16	31.16	31.16	1266.0
2010-01-15 05:00:00	MSFT	Stock	31.0	31.0	30.97	30.97	200.0
2010-01-15 07:00:00	MSFT	Stock	30.98	31.0	30.92	31.0	7735.0
2010-01-15 08:00:00	MSFT	Stock	31.0	31.15	30.96	31.08	214329.0
2010-01-15 09:00:00	MSFT	Stock	31.06	31.24	30.83	30.9	12335763.0
2010-01-15 10:00:00	MSFT	Stock	30.9	30.96	30.73	30.79	15655875.0
2010-01-15 11:00:00	MSFT	Stock	30.79	30.885	30.72	30.778	7586032.0
2010-01-15 12:00:00	MSFT	Stock	30.775	30.87	30.71	30.86	6455927.0
2010-01-15 13:00:00	MSFT	Stock	30.86	30.9	30.79	30.815	5528714.0
2010-01-15 14:00:00	MSFT	Stock	30.814	30.86	30.73	30.832	5127000.0
2010-01-15 15:00:00	MSFT	Stock	30.84	30.95	30.83	30.85	11002917.0
2010-01-15 16:00:00	MSFT	Stock	30.86	30.921	30.77	30.81	6082806.0
2010-01-15 17:00:00	MSFT	Stock	30.789	30.86	30.789	30.81	3462.0
2010-01-15 18:00:00	MSFT	Stock	30.8	30.85	30.8	30.8	3140.0
2010-01-15 19:00:00	MSFT	Stock	30.81	30.81	30.81	30.81	100.0
2010-01-15 08:00:00	NVDA	Stock	0.4398	0.4398	0.43	0.435	711920.0
2010-01-15 09:00:00	NVDA	Stock	0.435	0.4412	0.4272	0.4284	130592000.0
2010-01-15 10:00:00	NVDA	Stock	0.428	0.4312	0.4253	0.4276	127578600.0
2010-01-15 11:00:00	NVDA	Stock	0.4275	0.4282	0.4258	0.4265	58869400.0
2010-01-15 12:00:00	NVDA	Stock	0.4265	0.4274	0.4255	0.4258	58869560.0
2010-01-15 13:00:00	NVDA	Stock	0.426	0.426	0.4238	0.425	45210480.0
2010-01-15 14:00:00	NVDA	Stock	0.4253	0.4255	0.422	0.4222	65342200.0
2010-01-15 15:00:00	NVDA	Stock	0.422	0.4288	0.422	0.4278	307373680.0
2010-01-15 16:00:00	NVDA	Stock	0.4285	0.4285	0.4219	0.4278	2768000.0
2010-01-15 17:00:00	NVDA	Stock	0.4278	0.4278	0.4278	0.4278	56920.0
2010-01-15 19:00:00	NVDA	Stock	0.425	0.425	0.425	0.425	60000.0
2010-01-15 06:00:00	AMZN	Stock	6.368	6.368	6.365	6.368	6000.0
2010-01-15 07:00:00	AMZN	Stock	6.35	6.35	6.35	6.35	2000.0
2010-01-15 08:00:00	AMZN	Stock	6.3675	6.395	6.3375	6.382	349480.0
2010-01-15 09:00:00	AMZN	Stock	6.382	6.474	6.375	6.463	46459700.0
2010-01-15 10:00:00	AMZN	Stock	6.463	6.4825	6.3655	6.434	84869920.0
2010-01-15 11:00:00	AMZN	Stock	6.4345	6.44	6.412	6.414	35674220.0
2010-01-15 12:00:00	AMZN	Stock	6.415	6.4415	6.3905	6.4184	30703360.0
2010-01-15 13:00:00	AMZN	Stock	6.419	6.4205	6.366	6.38	23198560.0
2010-01-15 14:00:00	AMZN	Stock	6.3785	6.386	6.362	6.3764	24650820.0
2010-01-15 15:00:00	AMZN	Stock	6.3764	6.391	6.353	6.357	40536880.0

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

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