PREVIEW / stock_1hour / 2010-08-02

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-08-02.parquet
  size:    926 KB
  rows:    44,284
  symbols: 3,500

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-08-02 04:00:00	AAPL	Stock	9.2339	9.2643	9.2339	9.2643	11200.0
2010-08-02 06:00:00	AAPL	Stock	9.2764	9.2764	9.2611	9.2611	5684.0
2010-08-02 07:00:00	AAPL	Stock	9.2607	9.2607	9.2393	9.2525	312928.0
2010-08-02 08:00:00	AAPL	Stock	9.2521	9.2729	9.1875	9.2668	2089416.0
2010-08-02 09:00:00	AAPL	Stock	9.2711	9.3339	9.2686	9.2854	62447448.0
2010-08-02 10:00:00	AAPL	Stock	9.2854	9.3782	9.2839	9.3703	114981916.0
2010-08-02 11:00:00	AAPL	Stock	9.3721	9.3779	9.3486	9.3679	41928880.0
2010-08-02 12:00:00	AAPL	Stock	9.3679	9.3732	9.35	9.3657	28327152.0
2010-08-02 13:00:00	AAPL	Stock	9.3646	9.3661	9.3161	9.3389	42084000.0
2010-08-02 14:00:00	AAPL	Stock	9.34	9.3686	9.3389	9.3589	48102880.0
2010-08-02 15:00:00	AAPL	Stock	9.3593	9.3685	9.34	9.3489	70500500.0
2010-08-02 16:00:00	AAPL	Stock	9.3518	9.3657	9.3099	9.3475	12250896.0
2010-08-02 17:00:00	AAPL	Stock	9.1875	9.3514	9.1875	9.3432	334068.0
2010-08-02 18:00:00	AAPL	Stock	9.3432	9.3529	9.3432	9.3525	238420.0
2010-08-02 19:00:00	AAPL	Stock	9.3518	9.3532	9.3496	9.3532	276248.0
2010-08-02 06:00:00	MSFT	Stock	26.02	26.02	26.02	26.02	1000.0
2010-08-02 07:00:00	MSFT	Stock	25.98	26.07	25.96	25.96	16990.0
2010-08-02 08:00:00	MSFT	Stock	25.96	26.0	25.92	25.96	43777.0
2010-08-02 09:00:00	MSFT	Stock	25.95	26.05	25.75	25.97	8281453.0
2010-08-02 10:00:00	MSFT	Stock	25.97	26.28	25.96	26.242	8114006.0
2010-08-02 11:00:00	MSFT	Stock	26.245	26.295	26.16	26.201	6707438.0
2010-08-02 12:00:00	MSFT	Stock	26.205	26.22	26.17	26.2	3479876.0
2010-08-02 13:00:00	MSFT	Stock	26.208	26.24	26.14	26.19	4720524.0
2010-08-02 14:00:00	MSFT	Stock	26.19	26.38	26.17	26.33	4984295.0
2010-08-02 15:00:00	MSFT	Stock	26.34	26.35	26.25	26.32	9971196.0
2010-08-02 16:00:00	MSFT	Stock	26.32	26.332	25.81	26.26	7839143.0
2010-08-02 17:00:00	MSFT	Stock	25.81	26.26	25.81	26.26	87420.0
2010-08-02 18:00:00	MSFT	Stock	26.25	26.33	26.25	26.25	16085.0
2010-08-02 19:00:00	MSFT	Stock	26.25	26.3	26.25	26.29	1914.0
2010-08-02 05:00:00	NVDA	Stock	0.2338	0.2338	0.2338	0.2338	40000.0
2010-08-02 06:00:00	NVDA	Stock	0.2325	0.2325	0.2325	0.2325	8000.0
2010-08-02 08:00:00	NVDA	Stock	0.234	0.234	0.2322	0.2328	575720.0
2010-08-02 09:00:00	NVDA	Stock	0.2328	0.2348	0.2295	0.2305	103829920.0
2010-08-02 10:00:00	NVDA	Stock	0.2305	0.233	0.2305	0.231	149817000.0
2010-08-02 11:00:00	NVDA	Stock	0.231	0.2325	0.2308	0.2312	118804680.0
2010-08-02 12:00:00	NVDA	Stock	0.2312	0.2312	0.2288	0.23	77365760.0
2010-08-02 13:00:00	NVDA	Stock	0.2301	0.2305	0.2292	0.2296	49413400.0
2010-08-02 14:00:00	NVDA	Stock	0.2298	0.2308	0.229	0.2305	104496800.0
2010-08-02 15:00:00	NVDA	Stock	0.2305	0.2315	0.2285	0.229	274917920.0
2010-08-02 16:00:00	NVDA	Stock	0.2288	0.2307	0.2283	0.2296	16965080.0
2010-08-02 17:00:00	NVDA	Stock	0.2298	0.2298	0.2288	0.2288	384720.0
2010-08-02 18:00:00	NVDA	Stock	0.2292	0.2295	0.2292	0.2292	118600.0
2010-08-02 19:00:00	NVDA	Stock	0.2292	0.23	0.229	0.23	214040.0
2010-08-02 04:00:00	AMZN	Stock	5.9405	5.9405	5.9405	5.9405	8280.0
2010-08-02 07:00:00	AMZN	Stock	5.9405	5.9405	5.9405	5.9405	6000.0
2010-08-02 08:00:00	AMZN	Stock	5.95	5.974	5.95	5.955	148720.0
2010-08-02 09:00:00	AMZN	Stock	5.9545	5.98	5.901	5.9285	12141180.0
2010-08-02 10:00:00	AMZN	Stock	5.926	5.9685	5.8785	5.913	25518580.0
2010-08-02 11:00:00	AMZN	Stock	5.9155	5.966	5.9105	5.965	10909800.0
2010-08-02 12:00:00	AMZN	Stock	5.965	5.975	5.946	5.955	9033500.0

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

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