PREVIEW / stock_1hour / 2010-02-01

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-02-01.parquet
  size:    903 KB
  rows:    43,049
  symbols: 3,445

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-02-01 04:00:00	AAPL	Stock	6.8718	6.9007	6.8718	6.8932	19600.0
2010-02-01 05:00:00	AAPL	Stock	6.9004	6.9082	6.8939	6.9082	36400.0
2010-02-01 06:00:00	AAPL	Stock	6.9107	6.9107	6.9007	6.9096	41440.0
2010-02-01 07:00:00	AAPL	Stock	6.9054	6.9082	6.8664	6.8918	685076.0
2010-02-01 08:00:00	AAPL	Stock	6.8761	6.8886	6.8361	6.8396	4800012.0
2010-02-01 09:00:00	AAPL	Stock	6.8404	7.0	6.8321	6.9354	144996460.0
2010-02-01 10:00:00	AAPL	Stock	6.935	6.9768	6.8486	6.8632	193255664.0
2010-02-01 11:00:00	AAPL	Stock	6.8642	6.946	6.8464	6.8911	96699792.0
2010-02-01 12:00:00	AAPL	Stock	6.8911	6.9493	6.885	6.9332	54933424.0
2010-02-01 13:00:00	AAPL	Stock	6.9335	6.9571	6.9175	6.9457	54201336.0
2010-02-01 14:00:00	AAPL	Stock	6.9457	6.9489	6.9021	6.9054	53527264.0
2010-02-01 15:00:00	AAPL	Stock	6.9061	6.9539	6.8764	6.9537	122338944.0
2010-02-01 16:00:00	AAPL	Stock	6.9539	6.9575	6.9207	6.9546	13125420.0
2010-02-01 17:00:00	AAPL	Stock	6.8953	6.9546	6.8953	6.95	511672.0
2010-02-01 18:00:00	AAPL	Stock	6.9486	6.9554	6.9482	6.9529	400568.0
2010-02-01 19:00:00	AAPL	Stock	6.9536	6.9629	6.9536	6.9607	274568.0
2010-02-01 06:00:00	MSFT	Stock	28.38	28.38	28.35	28.35	800.0
2010-02-01 07:00:00	MSFT	Stock	28.37	28.37	28.34	28.35	4200.0
2010-02-01 08:00:00	MSFT	Stock	28.34	28.51	28.18	28.46	349367.0
2010-02-01 09:00:00	MSFT	Stock	28.46	28.46	28.18	28.351	10834448.0
2010-02-01 10:00:00	MSFT	Stock	28.36	28.39	27.96	27.975	22857470.0
2010-02-01 11:00:00	MSFT	Stock	27.97	28.2	27.92	28.13	11242048.0
2010-02-01 12:00:00	MSFT	Stock	28.13	28.37	28.11	28.35	11150390.0
2010-02-01 13:00:00	MSFT	Stock	28.35	28.44	28.27	28.4	6139173.0
2010-02-01 14:00:00	MSFT	Stock	28.4	28.48	28.35	28.45	6576749.0
2010-02-01 15:00:00	MSFT	Stock	28.45	28.48	28.26	28.41	11279132.0
2010-02-01 16:00:00	MSFT	Stock	28.4	28.41	28.18	28.41	2600897.0
2010-02-01 17:00:00	MSFT	Stock	28.159	28.37	28.159	28.31	54992.0
2010-02-01 18:00:00	MSFT	Stock	28.41	28.41	28.31	28.34	15591.0
2010-02-01 19:00:00	MSFT	Stock	28.33	28.37	28.32	28.36	6396.0
2010-02-01 08:00:00	NVDA	Stock	0.3865	0.3875	0.3862	0.3862	64000.0
2010-02-01 09:00:00	NVDA	Stock	0.3862	0.396	0.383	0.3922	74805360.0
2010-02-01 10:00:00	NVDA	Stock	0.3922	0.3959	0.3895	0.3922	97403840.0
2010-02-01 11:00:00	NVDA	Stock	0.3922	0.405	0.391	0.4048	157555160.0
2010-02-01 12:00:00	NVDA	Stock	0.4048	0.409	0.402	0.408	106712280.0
2010-02-01 13:00:00	NVDA	Stock	0.408	0.4108	0.4065	0.4102	101522720.0
2010-02-01 14:00:00	NVDA	Stock	0.4104	0.4145	0.4088	0.4133	138512440.0
2010-02-01 15:00:00	NVDA	Stock	0.4133	0.415	0.4115	0.4145	229195760.0
2010-02-01 16:00:00	NVDA	Stock	0.414	0.415	0.4022	0.4142	22249920.0
2010-02-01 17:00:00	NVDA	Stock	0.4125	0.418	0.4125	0.418	28800.0
2010-02-01 18:00:00	NVDA	Stock	0.4142	0.4142	0.414	0.414	5193200.0
2010-02-01 19:00:00	NVDA	Stock	0.4155	0.4155	0.414	0.4155	66160.0
2010-02-01 05:00:00	AMZN	Stock	6.274	6.274	6.274	6.274	4000.0
2010-02-01 06:00:00	AMZN	Stock	6.3295	6.3295	6.2655	6.2655	10000.0
2010-02-01 07:00:00	AMZN	Stock	6.2495	6.2495	6.2005	6.223	67800.0
2010-02-01 08:00:00	AMZN	Stock	6.25	6.25	6.141	6.155	1289640.0
2010-02-01 09:00:00	AMZN	Stock	6.15	6.243	6.0625	6.0831	67266420.0
2010-02-01 10:00:00	AMZN	Stock	6.0845	6.105	5.8675	5.87	134761200.0
2010-02-01 11:00:00	AMZN	Stock	5.869	6.116	5.701	5.7065	144964580.0
2010-02-01 12:00:00	AMZN	Stock	5.7045	5.8345	5.691	5.7771	109723300.0

> showing 50 of 43,049 rows — these rows as CSV

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