PREVIEW / stock_1hour / 2011-01-03

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-01-03.parquet
  size:    972 KB
  rows:    46,847
  symbols: 3,538

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-01-03 04:00:00	AAPL	Stock	11.5714	11.5968	11.5714	11.5968	35280.0
2011-01-03 05:00:00	AAPL	Stock	11.6064	11.6371	11.6064	11.6096	16800.0
2011-01-03 06:00:00	AAPL	Stock	11.6339	11.6339	11.62	11.6229	14000.0
2011-01-03 07:00:00	AAPL	Stock	11.6143	11.6321	11.5846	11.6321	513744.0
2011-01-03 08:00:00	AAPL	Stock	11.6182	11.6329	11.52	11.6	2289028.0
2011-01-03 09:00:00	AAPL	Stock	11.6007	11.7096	11.52	11.6954	84373744.0
2011-01-03 10:00:00	AAPL	Stock	11.6952	11.785	11.6918	11.7825	102203192.0
2011-01-03 11:00:00	AAPL	Stock	11.7836	11.7929	11.7593	11.7756	59190600.0
2011-01-03 12:00:00	AAPL	Stock	11.7754	11.7804	11.7614	11.7696	29519532.0
2011-01-03 13:00:00	AAPL	Stock	11.7694	11.7854	11.7643	11.7839	24892924.0
2011-01-03 14:00:00	AAPL	Stock	11.7839	11.795	11.7393	11.7686	48452544.0
2011-01-03 15:00:00	AAPL	Stock	11.7689	11.7757	11.7246	11.7757	71745632.0
2011-01-03 16:00:00	AAPL	Stock	11.7757	11.7775	11.744	11.7664	16227904.0
2011-01-03 17:00:00	AAPL	Stock	11.7679	11.7761	11.7679	11.7689	667072.0
2011-01-03 18:00:00	AAPL	Stock	11.7679	11.7818	11.7679	11.7771	440608.0
2011-01-03 19:00:00	AAPL	Stock	11.7782	11.7793	11.7714	11.7714	249648.0
2011-01-03 04:00:00	MSFT	Stock	28.04	28.04	28.04	28.04	100.0
2011-01-03 07:00:00	MSFT	Stock	28.1	28.1	28.05	28.05	2600.0
2011-01-03 08:00:00	MSFT	Stock	28.05	28.14	27.92	28.1	59360.0
2011-01-03 09:00:00	MSFT	Stock	28.1	28.18	27.92	28.11	7212165.0
2011-01-03 10:00:00	MSFT	Stock	28.12	28.13	28.06	28.1	8871477.0
2011-01-03 11:00:00	MSFT	Stock	28.1	28.12	27.97	28.041	6546019.0
2011-01-03 12:00:00	MSFT	Stock	28.05	28.09	27.99	28.03	4510584.0
2011-01-03 13:00:00	MSFT	Stock	28.021	28.04	27.97	28.0	3239960.0
2011-01-03 14:00:00	MSFT	Stock	28.0	28.01	27.94	27.98	4094037.0
2011-01-03 15:00:00	MSFT	Stock	27.99	28.07	27.92	27.97	13007769.0
2011-01-03 16:00:00	MSFT	Stock	27.97	28.047	27.9	27.92	3290837.0
2011-01-03 17:00:00	MSFT	Stock	27.93	27.98	27.93	27.93	54325.0
2011-01-03 18:00:00	MSFT	Stock	27.94	27.98	27.94	27.97	10026.0
2011-01-03 19:00:00	MSFT	Stock	27.98	27.98	27.97	27.97	900.0
2011-01-03 04:00:00	NVDA	Stock	0.386	0.386	0.386	0.386	8000.0
2011-01-03 07:00:00	NVDA	Stock	0.389	0.389	0.389	0.389	24000.0
2011-01-03 08:00:00	NVDA	Stock	0.3875	0.39	0.3875	0.3882	408520.0
2011-01-03 09:00:00	NVDA	Stock	0.3882	0.3982	0.3875	0.3968	129387560.0
2011-01-03 10:00:00	NVDA	Stock	0.397	0.3988	0.3948	0.397	128457680.0
2011-01-03 11:00:00	NVDA	Stock	0.397	0.3975	0.3933	0.394	68327160.0
2011-01-03 12:00:00	NVDA	Stock	0.394	0.3993	0.3938	0.3984	130502760.0
2011-01-03 13:00:00	NVDA	Stock	0.3982	0.3985	0.397	0.3975	57762040.0
2011-01-03 14:00:00	NVDA	Stock	0.3975	0.398	0.3962	0.3968	78016400.0
2011-01-03 15:00:00	NVDA	Stock	0.3968	0.3978	0.3955	0.3958	155817520.0
2011-01-03 16:00:00	NVDA	Stock	0.3955	0.398	0.3946	0.3965	9136400.0
2011-01-03 17:00:00	NVDA	Stock	0.3975	0.3975	0.396	0.3975	341520.0
2011-01-03 18:00:00	NVDA	Stock	0.3965	0.3975	0.3965	0.3965	188560.0
2011-01-03 19:00:00	NVDA	Stock	0.3965	0.3975	0.3965	0.3975	65160.0
2011-01-03 04:00:00	AMZN	Stock	9.048	9.115	9.048	9.115	15740.0
2011-01-03 05:00:00	AMZN	Stock	9.1065	9.111	9.1065	9.111	4000.0
2011-01-03 06:00:00	AMZN	Stock	9.1195	9.16	9.1195	9.16	77280.0
2011-01-03 07:00:00	AMZN	Stock	9.15	9.15	9.115	9.1425	103020.0
2011-01-03 08:00:00	AMZN	Stock	9.1425	9.2	9.0	9.075	768140.0
2011-01-03 09:00:00	AMZN	Stock	9.0725	9.2	9.0415	9.167	21258480.0

> showing 50 of 46,847 rows — these rows as CSV

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