PREVIEW / stock_1hour / 2010-02-05

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-02-05.parquet
  size:    903 KB
  rows:    43,257
  symbols: 3,429

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-05 04:00:00	AAPL	Stock	6.8571	6.8604	6.8514	6.8514	30800.0
2010-02-05 05:00:00	AAPL	Stock	6.8375	6.8375	6.8193	6.8193	20020.0
2010-02-05 06:00:00	AAPL	Stock	6.7932	6.8179	6.7929	6.8179	174832.0
2010-02-05 07:00:00	AAPL	Stock	6.835	6.845	6.8179	6.8332	328888.0
2010-02-05 08:00:00	AAPL	Stock	6.8232	6.9204	6.7957	6.92	12866868.0
2010-02-05 09:00:00	AAPL	Stock	6.9207	6.9286	6.8161	6.8764	149169048.0
2010-02-05 10:00:00	AAPL	Stock	6.8764	6.9643	6.8429	6.9218	163302272.0
2010-02-05 11:00:00	AAPL	Stock	6.9218	6.9307	6.8686	6.9039	86545088.0
2010-02-05 12:00:00	AAPL	Stock	6.9043	6.9318	6.9	6.9232	55351632.0
2010-02-05 13:00:00	AAPL	Stock	6.9232	6.9243	6.8357	6.8461	80858848.0
2010-02-05 14:00:00	AAPL	Stock	6.8461	6.9107	6.8393	6.9104	96273408.0
2010-02-05 15:00:00	AAPL	Stock	6.9104	7.0	6.9089	6.975	178460296.0
2010-02-05 16:00:00	AAPL	Stock	6.9746	6.9871	6.8456	6.9779	11617648.0
2010-02-05 17:00:00	AAPL	Stock	6.9779	6.9957	6.8571	6.9946	2335536.0
2010-02-05 18:00:00	AAPL	Stock	6.9957	6.9993	6.9807	6.9914	282632.0
2010-02-05 19:00:00	AAPL	Stock	6.9914	6.9982	6.9893	6.9964	296492.0
2010-02-05 20:00:00	AAPL	Stock	6.9157	6.9157	6.9111	6.9111	126000.0
2010-02-05 04:00:00	MSFT	Stock	27.76	27.76	27.7	27.7	1500.0
2010-02-05 05:00:00	MSFT	Stock	27.7	27.7	27.7	27.7	4964.0
2010-02-05 06:00:00	MSFT	Stock	27.53	27.53	27.53	27.53	400.0
2010-02-05 07:00:00	MSFT	Stock	27.57	27.72	27.53	27.71	8400.0
2010-02-05 08:00:00	MSFT	Stock	27.65	28.0	27.63	27.99	172453.0
2010-02-05 09:00:00	MSFT	Stock	27.81	28.1	27.71	27.75	7874407.0
2010-02-05 10:00:00	MSFT	Stock	27.765	28.28	27.74	28.03	14012037.0
2010-02-05 11:00:00	MSFT	Stock	28.02	28.04	27.72	27.82	9811551.0
2010-02-05 12:00:00	MSFT	Stock	27.82	27.9	27.78	27.86	5850216.0
2010-02-05 13:00:00	MSFT	Stock	27.87	27.88	27.57	27.6	7510525.0
2010-02-05 14:00:00	MSFT	Stock	27.602	27.77	27.6	27.69	7915490.0
2010-02-05 15:00:00	MSFT	Stock	27.69	28.13	27.68	28.01	22112220.0
2010-02-05 16:00:00	MSFT	Stock	28.01	28.05	27.616	28.0	1670261.0
2010-02-05 17:00:00	MSFT	Stock	27.81	28.03	27.81	28.0	654079.0
2010-02-05 18:00:00	MSFT	Stock	28.02	28.05	28.02	28.04	8816.0
2010-02-05 19:00:00	MSFT	Stock	28.0	28.05	28.0	28.05	6042.0
2010-02-05 20:00:00	MSFT	Stock	27.81	27.81	27.81	27.81	144700.0
2010-02-05 08:00:00	NVDA	Stock	0.3953	0.4008	0.3925	0.4008	249400.0
2010-02-05 09:00:00	NVDA	Stock	0.4008	0.4022	0.3913	0.3915	62057440.0
2010-02-05 10:00:00	NVDA	Stock	0.3915	0.4053	0.39	0.4032	113175520.0
2010-02-05 11:00:00	NVDA	Stock	0.403	0.404	0.398	0.3993	61340640.0
2010-02-05 12:00:00	NVDA	Stock	0.3993	0.4015	0.3975	0.4	48873320.0
2010-02-05 13:00:00	NVDA	Stock	0.3998	0.4	0.3927	0.3928	58413040.0
2010-02-05 14:00:00	NVDA	Stock	0.393	0.3985	0.3922	0.3985	65830480.0
2010-02-05 15:00:00	NVDA	Stock	0.3982	0.4065	0.3982	0.4055	175284240.0
2010-02-05 16:00:00	NVDA	Stock	0.4062	0.4072	0.3927	0.4065	6721600.0
2010-02-05 17:00:00	NVDA	Stock	0.397	0.4065	0.397	0.4065	1644000.0
2010-02-05 18:00:00	NVDA	Stock	0.4055	0.4065	0.4055	0.4065	1901720.0
2010-02-05 19:00:00	NVDA	Stock	0.4065	0.4065	0.4065	0.4065	28000.0
2010-02-05 06:00:00	AMZN	Stock	5.75	5.75	5.75	5.75	2000.0
2010-02-05 08:00:00	AMZN	Stock	5.7575	5.8375	5.73	5.8285	1001040.0
2010-02-05 09:00:00	AMZN	Stock	5.83	5.8325	5.705	5.7405	40812300.0
2010-02-05 10:00:00	AMZN	Stock	5.7418	5.872	5.721	5.83	48726740.0

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

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