PREVIEW / stock_1hour / 2011-11-02

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-11-02.parquet
  size:    914 KB
  rows:    43,271
  symbols: 3,495

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
2011-11-02 04:00:00	AAPL	Stock	14.2686	14.315	14.2686	14.3125	44800.0
2011-11-02 05:00:00	AAPL	Stock	14.3125	14.3125	14.2143	14.2286	56000.0
2011-11-02 06:00:00	AAPL	Stock	14.2214	14.2286	14.2214	14.225	16800.0
2011-11-02 07:00:00	AAPL	Stock	14.2286	14.2857	14.2286	14.2679	191800.0
2011-11-02 08:00:00	AAPL	Stock	14.25	14.2768	14.2325	14.2518	1436092.0
2011-11-02 09:00:00	AAPL	Stock	14.2536	14.3164	14.1889	14.2086	46474652.0
2011-11-02 10:00:00	AAPL	Stock	14.21	14.2368	14.1393	14.2218	60724888.0
2011-11-02 11:00:00	AAPL	Stock	14.2229	14.2332	14.1832	14.1975	28745024.0
2011-11-02 12:00:00	AAPL	Stock	14.1989	14.2225	14.175	14.1814	29554084.0
2011-11-02 13:00:00	AAPL	Stock	14.18	14.1893	14.1268	14.1411	34906676.0
2011-11-02 14:00:00	AAPL	Stock	14.1396	14.2018	14.1111	14.1921	42418348.0
2011-11-02 15:00:00	AAPL	Stock	14.1929	14.2204	14.1511	14.1893	57893612.0
2011-11-02 16:00:00	AAPL	Stock	14.1893	14.2468	14.1611	14.2461	22025836.0
2011-11-02 17:00:00	AAPL	Stock	14.2421	14.2589	14.2321	14.25	911428.0
2011-11-02 18:00:00	AAPL	Stock	14.2496	14.25	14.1886	14.1964	499408.0
2011-11-02 19:00:00	AAPL	Stock	14.1896	14.2054	14.1746	14.1786	525364.0
2011-11-02 08:00:00	MSFT	Stock	26.1	26.2	26.1	26.2	27829.0
2011-11-02 09:00:00	MSFT	Stock	26.18	26.2	25.94	25.95	4422568.0
2011-11-02 10:00:00	MSFT	Stock	25.95	26.09	25.83	26.08	7335465.0
2011-11-02 11:00:00	MSFT	Stock	26.08	26.139	25.99	26.06	5715141.0
2011-11-02 12:00:00	MSFT	Stock	26.05	26.07	25.92	25.93	3771157.0
2011-11-02 13:00:00	MSFT	Stock	25.94	25.95	25.76	25.79	5564764.0
2011-11-02 14:00:00	MSFT	Stock	25.78	26.03	25.7	26.0	7185734.0
2011-11-02 15:00:00	MSFT	Stock	26.0	26.13	25.941	26.01	12242286.0
2011-11-02 16:00:00	MSFT	Stock	26.02	26.12	25.972	26.05	6377578.0
2011-11-02 17:00:00	MSFT	Stock	26.05	26.07	26.03	26.07	14400.0
2011-11-02 18:00:00	MSFT	Stock	26.01	26.04	25.92	25.92	3004.0
2011-11-02 19:00:00	MSFT	Stock	25.94	26.01	25.94	26.01	1705.0
2011-11-02 08:00:00	NVDA	Stock	0.355	0.3585	0.355	0.3585	345200.0
2011-11-02 09:00:00	NVDA	Stock	0.3588	0.3588	0.3465	0.3466	109405760.0
2011-11-02 10:00:00	NVDA	Stock	0.3468	0.3513	0.3462	0.3494	171228760.0
2011-11-02 11:00:00	NVDA	Stock	0.3495	0.35	0.347	0.3478	105692400.0
2011-11-02 12:00:00	NVDA	Stock	0.3479	0.348	0.3425	0.3428	117842800.0
2011-11-02 13:00:00	NVDA	Stock	0.343	0.343	0.3382	0.3395	130418200.0
2011-11-02 14:00:00	NVDA	Stock	0.3395	0.3455	0.3382	0.3442	131543520.0
2011-11-02 15:00:00	NVDA	Stock	0.3445	0.3468	0.3415	0.3453	170685520.0
2011-11-02 16:00:00	NVDA	Stock	0.3454	0.3468	0.3448	0.3468	21068360.0
2011-11-02 17:00:00	NVDA	Stock	0.3465	0.3465	0.3462	0.3462	128400.0
2011-11-02 18:00:00	NVDA	Stock	0.3462	0.3462	0.3453	0.3455	826800.0
2011-11-02 19:00:00	NVDA	Stock	0.3455	0.3455	0.3445	0.3445	478160.0
2011-11-02 05:00:00	AMZN	Stock	10.6205	10.6205	10.6205	10.6205	4000.0
2011-11-02 07:00:00	AMZN	Stock	10.716	10.725	10.6625	10.676	17000.0
2011-11-02 08:00:00	AMZN	Stock	10.715	10.75	10.69	10.735	571740.0
2011-11-02 09:00:00	AMZN	Stock	10.745	10.794	10.7	10.7375	14521060.0
2011-11-02 10:00:00	AMZN	Stock	10.739	10.8395	10.7105	10.832	20372880.0
2011-11-02 11:00:00	AMZN	Stock	10.8298	10.839	10.7735	10.7995	10965860.0
2011-11-02 12:00:00	AMZN	Stock	10.798	10.802	10.714	10.716	11213540.0
2011-11-02 13:00:00	AMZN	Stock	10.716	10.7225	10.636	10.6735	13422240.0
2011-11-02 14:00:00	AMZN	Stock	10.6715	10.759	10.6425	10.75	13094340.0
2011-11-02 15:00:00	AMZN	Stock	10.7505	10.8005	10.725	10.7785	22660380.0

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

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