PREVIEW / stock_1hour / 2012-02-17

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-02-17.parquet
  size:    952 KB
  rows:    44,510
  symbols: 3,561

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
2012-02-17 04:00:00	AAPL	Stock	18.0443	18.1071	18.0443	18.0518	259420.0
2012-02-17 05:00:00	AAPL	Stock	18.0604	18.0604	18.0204	18.0268	102564.0
2012-02-17 06:00:00	AAPL	Stock	18.0357	18.0446	18.0268	18.0268	96460.0
2012-02-17 07:00:00	AAPL	Stock	18.0179	18.05	17.9875	18.0186	736428.0
2012-02-17 08:00:00	AAPL	Stock	18.0232	18.0468	17.9643	18.0057	2878540.0
2012-02-17 09:00:00	AAPL	Stock	18.0064	18.1346	17.9179	18.0571	141683724.0
2012-02-17 10:00:00	AAPL	Stock	18.0582	18.095	18.0179	18.0411	71050532.0
2012-02-17 11:00:00	AAPL	Stock	18.0432	18.0432	17.875	17.9696	84225120.0
2012-02-17 12:00:00	AAPL	Stock	17.9714	18.0096	17.9304	17.9607	38012268.0
2012-02-17 13:00:00	AAPL	Stock	17.9606	17.9785	17.9514	17.9617	22789844.0
2012-02-17 14:00:00	AAPL	Stock	17.9618	17.9671	17.8829	17.8964	38320436.0
2012-02-17 15:00:00	AAPL	Stock	17.895	17.9729	17.8679	17.9321	103931716.0
2012-02-17 16:00:00	AAPL	Stock	17.9329	17.9825	17.9089	17.98	16509052.0
2012-02-17 17:00:00	AAPL	Stock	17.9818	17.9879	17.9329	17.9714	621684.0
2012-02-17 18:00:00	AAPL	Stock	17.9736	17.9821	17.9536	17.9593	495208.0
2012-02-17 19:00:00	AAPL	Stock	17.9636	17.9768	17.9579	17.975	438172.0
2012-02-17 07:00:00	MSFT	Stock	31.27	31.3	31.25	31.27	7255.0
2012-02-17 08:00:00	MSFT	Stock	31.28	31.3	31.2	31.25	23228.0
2012-02-17 09:00:00	MSFT	Stock	31.22	31.32	31.11	31.133	6929401.0
2012-02-17 10:00:00	MSFT	Stock	31.139	31.28	31.08	31.27	10181360.0
2012-02-17 11:00:00	MSFT	Stock	31.264	31.27	31.03	31.08	8400016.0
2012-02-17 12:00:00	MSFT	Stock	31.08	31.09	30.95	31.073	6911155.0
2012-02-17 13:00:00	MSFT	Stock	31.078	31.08	30.99	31.05	4235272.0
2012-02-17 14:00:00	MSFT	Stock	31.055	31.22	31.05	31.175	6954209.0
2012-02-17 15:00:00	MSFT	Stock	31.18	31.27	31.17	31.26	13296890.0
2012-02-17 16:00:00	MSFT	Stock	31.25	31.33	31.154	31.26	2352217.0
2012-02-17 17:00:00	MSFT	Stock	31.182	31.26	31.182	31.25	69167.0
2012-02-17 18:00:00	MSFT	Stock	31.29	31.29	31.29	31.29	200.0
2012-02-17 19:00:00	MSFT	Stock	31.29	31.42	31.29	31.39	4411.0
2012-02-17 08:00:00	NVDA	Stock	0.4108	0.4112	0.4108	0.4112	68000.0
2012-02-17 09:00:00	NVDA	Stock	0.4128	0.4138	0.4022	0.4133	244471000.0
2012-02-17 10:00:00	NVDA	Stock	0.4133	0.4142	0.3993	0.4	200095720.0
2012-02-17 11:00:00	NVDA	Stock	0.3999	0.4	0.3938	0.3957	153975120.0
2012-02-17 12:00:00	NVDA	Stock	0.3958	0.3965	0.3938	0.394	67924440.0
2012-02-17 13:00:00	NVDA	Stock	0.3942	0.3973	0.3925	0.3945	85596160.0
2012-02-17 14:00:00	NVDA	Stock	0.3945	0.3962	0.3942	0.396	52880800.0
2012-02-17 15:00:00	NVDA	Stock	0.396	0.3965	0.393	0.396	200436480.0
2012-02-17 16:00:00	NVDA	Stock	0.3962	0.4	0.3955	0.396	3584920.0
2012-02-17 17:00:00	NVDA	Stock	0.396	0.3963	0.3958	0.3962	115120.0
2012-02-17 18:00:00	NVDA	Stock	0.3962	0.3962	0.3958	0.3962	58000.0
2012-02-17 19:00:00	NVDA	Stock	0.3958	0.3958	0.394	0.3942	95200.0
2012-02-17 05:00:00	AMZN	Stock	9.045	9.045	9.045	9.045	2800.0
2012-02-17 06:00:00	AMZN	Stock	9.05	9.05	8.9855	8.9995	35800.0
2012-02-17 07:00:00	AMZN	Stock	8.9995	9.0165	8.9955	9.0	82100.0
2012-02-17 08:00:00	AMZN	Stock	9.025	9.07	9.015	9.017	189440.0
2012-02-17 09:00:00	AMZN	Stock	9.0245	9.136	8.9965	9.1218	30930440.0
2012-02-17 10:00:00	AMZN	Stock	9.1195	9.1331	9.0775	9.0925	21579160.0
2012-02-17 11:00:00	AMZN	Stock	9.0915	9.093	8.968	9.0098	23624620.0
2012-02-17 12:00:00	AMZN	Stock	9.0098	9.0525	9.0098	9.035	11762600.0
2012-02-17 13:00:00	AMZN	Stock	9.0345	9.0655	9.019	9.064	11979780.0

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

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