PREVIEW / stock_1hour / 2011-01-04

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-01-04.parquet
  size:    950 KB
  rows:    44,460
  symbols: 3,506

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-04 05:00:00	AAPL	Stock	11.7964	11.8332	11.7964	11.8332	5600.0
2011-01-04 06:00:00	AAPL	Stock	11.8157	11.8243	11.8157	11.8243	14000.0
2011-01-04 07:00:00	AAPL	Stock	11.825	11.8875	11.825	11.8682	1410808.0
2011-01-04 08:00:00	AAPL	Stock	11.8654	11.8968	11.8489	11.8739	3384388.0
2011-01-04 09:00:00	AAPL	Stock	11.8736	11.8821	11.8089	11.8282	54274584.0
2011-01-04 10:00:00	AAPL	Stock	11.8286	11.8421	11.7929	11.8161	53159260.0
2011-01-04 11:00:00	AAPL	Stock	11.8161	11.8216	11.7607	11.7611	45544968.0
2011-01-04 12:00:00	AAPL	Stock	11.7607	11.7729	11.7196	11.7589	38934812.0
2011-01-04 13:00:00	AAPL	Stock	11.7589	11.7814	11.7564	11.7706	20706252.0
2011-01-04 14:00:00	AAPL	Stock	11.7707	11.8211	11.7686	11.7996	35646128.0
2011-01-04 15:00:00	AAPL	Stock	11.8	11.8354	11.7811	11.8321	43689100.0
2011-01-04 16:00:00	AAPL	Stock	11.8318	11.8831	11.7899	11.8282	7271404.0
2011-01-04 17:00:00	AAPL	Stock	11.8279	11.8304	11.8168	11.8189	388444.0
2011-01-04 18:00:00	AAPL	Stock	11.8214	11.8318	11.8186	11.8214	130480.0
2011-01-04 19:00:00	AAPL	Stock	11.8214	11.8286	11.8196	11.8254	224840.0
2011-01-04 06:00:00	MSFT	Stock	28.03	28.03	28.03	28.03	100.0
2011-01-04 07:00:00	MSFT	Stock	28.03	28.03	28.02	28.03	5800.0
2011-01-04 08:00:00	MSFT	Stock	28.03	28.03	27.95	27.98	16150.0
2011-01-04 09:00:00	MSFT	Stock	28.0	28.14	27.85	27.96	5098191.0
2011-01-04 10:00:00	MSFT	Stock	27.97	28.055	27.95	27.96	8425150.0
2011-01-04 11:00:00	MSFT	Stock	27.96	27.99	27.92	27.96	5745650.0
2011-01-04 12:00:00	MSFT	Stock	27.96	28.02	27.94	28.015	6646158.0
2011-01-04 13:00:00	MSFT	Stock	28.015	28.06	27.99	28.04	5315361.0
2011-01-04 14:00:00	MSFT	Stock	28.03	28.1	28.0	28.08	6694809.0
2011-01-04 15:00:00	MSFT	Stock	28.08	28.17	28.035	28.05	11111084.0
2011-01-04 16:00:00	MSFT	Stock	28.08	28.117	28.0	28.05	2623010.0
2011-01-04 17:00:00	MSFT	Stock	28.05	28.05	28.01	28.01	1648.0
2011-01-04 18:00:00	MSFT	Stock	28.09	28.09	28.02	28.02	14025.0
2011-01-04 19:00:00	MSFT	Stock	28.01	28.03	28.01	28.01	1828.0
2011-01-04 07:00:00	NVDA	Stock	0.3982	0.3982	0.3982	0.3982	8000.0
2011-01-04 08:00:00	NVDA	Stock	0.4	0.4	0.3982	0.3995	779520.0
2011-01-04 09:00:00	NVDA	Stock	0.3995	0.3995	0.392	0.3925	76962840.0
2011-01-04 10:00:00	NVDA	Stock	0.3928	0.3942	0.3855	0.3893	143430880.0
2011-01-04 11:00:00	NVDA	Stock	0.3893	0.3905	0.3868	0.388	60133000.0
2011-01-04 12:00:00	NVDA	Stock	0.388	0.3885	0.3859	0.3885	60622160.0
2011-01-04 13:00:00	NVDA	Stock	0.3882	0.3901	0.3878	0.3898	36677520.0
2011-01-04 14:00:00	NVDA	Stock	0.3898	0.3908	0.3878	0.389	71405000.0
2011-01-04 15:00:00	NVDA	Stock	0.389	0.395	0.3888	0.3942	185833520.0
2011-01-04 16:00:00	NVDA	Stock	0.3942	0.3957	0.3905	0.393	11818640.0
2011-01-04 17:00:00	NVDA	Stock	0.3942	0.3955	0.393	0.3938	226840.0
2011-01-04 18:00:00	NVDA	Stock	0.3955	0.3955	0.3955	0.3955	16000.0
2011-01-04 19:00:00	NVDA	Stock	0.3948	0.3948	0.3948	0.3948	26400.0
2011-01-04 04:00:00	AMZN	Stock	9.228	9.228	9.228	9.228	2000.0
2011-01-04 07:00:00	AMZN	Stock	9.225	9.303	9.225	9.3025	220000.0
2011-01-04 08:00:00	AMZN	Stock	9.2965	9.309	9.275	9.2955	518420.0
2011-01-04 09:00:00	AMZN	Stock	9.297	9.385	9.291	9.3485	22095000.0
2011-01-04 10:00:00	AMZN	Stock	9.35	9.359	9.2405	9.261	19462500.0
2011-01-04 11:00:00	AMZN	Stock	9.2616	9.2675	9.217	9.221	12747760.0
2011-01-04 12:00:00	AMZN	Stock	9.218	9.23	9.189	9.2214	11204960.0
2011-01-04 13:00:00	AMZN	Stock	9.222	9.2495	9.2165	9.227	7168040.0

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

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