PREVIEW / stock_1hour / 2011-01-24

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-01-24.parquet
  size:    948 KB
  rows:    45,554
  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-24 04:00:00	AAPL	Stock	11.7218	11.7229	11.7136	11.7136	11200.0
2011-01-24 05:00:00	AAPL	Stock	11.7214	11.7214	11.6786	11.6786	30744.0
2011-01-24 06:00:00	AAPL	Stock	11.7179	11.7393	11.7179	11.725	58800.0
2011-01-24 07:00:00	AAPL	Stock	11.7321	11.7325	11.6964	11.7157	598640.0
2011-01-24 08:00:00	AAPL	Stock	11.7143	11.7161	11.6782	11.7036	2308992.0
2011-01-24 09:00:00	AAPL	Stock	11.7036	11.8529	11.6686	11.7936	117529748.0
2011-01-24 10:00:00	AAPL	Stock	11.7954	11.8643	11.7625	11.8529	91250768.0
2011-01-24 11:00:00	AAPL	Stock	11.8532	11.9396	11.8443	11.9279	86756404.0
2011-01-24 12:00:00	AAPL	Stock	11.9271	11.9739	11.9236	11.9643	53797184.0
2011-01-24 13:00:00	AAPL	Stock	11.9643	11.9943	11.9382	11.975	45183936.0
2011-01-24 14:00:00	AAPL	Stock	11.9757	12.0389	11.9693	12.0089	61634412.0
2011-01-24 15:00:00	AAPL	Stock	12.0082	12.0507	11.975	12.0493	85247288.0
2011-01-24 16:00:00	AAPL	Stock	12.0518	12.0714	11.6683	12.0411	16574936.0
2011-01-24 17:00:00	AAPL	Stock	11.9322	12.0518	11.9322	12.0393	1358140.0
2011-01-24 18:00:00	AAPL	Stock	12.0393	12.0518	12.0393	12.0421	288540.0
2011-01-24 19:00:00	AAPL	Stock	12.0429	12.0668	12.0421	12.0661	446264.0
2011-01-24 07:00:00	MSFT	Stock	28.11	28.12	28.11	28.12	200.0
2011-01-24 08:00:00	MSFT	Stock	28.05	28.15	28.04	28.09	48548.0
2011-01-24 09:00:00	MSFT	Stock	28.09	28.185	27.99	28.17	5264362.0
2011-01-24 10:00:00	MSFT	Stock	28.175	28.35	28.12	28.31	6926325.0
2011-01-24 11:00:00	MSFT	Stock	28.305	28.5	28.3	28.45	9828914.0
2011-01-24 12:00:00	MSFT	Stock	28.45	28.53	28.44	28.49	5052488.0
2011-01-24 13:00:00	MSFT	Stock	28.495	28.55	28.45	28.476	4791357.0
2011-01-24 14:00:00	MSFT	Stock	28.48	28.55	28.46	28.51	3637435.0
2011-01-24 15:00:00	MSFT	Stock	28.51	28.56	28.32	28.38	11439751.0
2011-01-24 16:00:00	MSFT	Stock	28.37	28.469	28.3	28.37	2133884.0
2011-01-24 17:00:00	MSFT	Stock	28.35	28.4	28.35	28.39	265257.0
2011-01-24 18:00:00	MSFT	Stock	28.38	28.38	28.35	28.35	5371.0
2011-01-24 19:00:00	MSFT	Stock	28.39	28.4	28.37	28.37	2671.0
2011-01-24 06:00:00	NVDA	Stock	0.5718	0.5948	0.5675	0.5712	144000.0
2011-01-24 07:00:00	NVDA	Stock	0.575	0.5863	0.5738	0.5822	739800.0
2011-01-24 08:00:00	NVDA	Stock	0.5825	0.5838	0.5732	0.5812	8849560.0
2011-01-24 09:00:00	NVDA	Stock	0.5812	0.5923	0.5745	0.5858	267141240.0
2011-01-24 10:00:00	NVDA	Stock	0.5858	0.6038	0.5843	0.6003	385303440.0
2011-01-24 11:00:00	NVDA	Stock	0.6003	0.6153	0.5998	0.612	308959560.0
2011-01-24 12:00:00	NVDA	Stock	0.612	0.6248	0.6118	0.6245	263543600.0
2011-01-24 13:00:00	NVDA	Stock	0.6242	0.6263	0.6168	0.6193	249209080.0
2011-01-24 14:00:00	NVDA	Stock	0.6193	0.621	0.612	0.6185	250739480.0
2011-01-24 15:00:00	NVDA	Stock	0.6185	0.6218	0.616	0.618	286706680.0
2011-01-24 16:00:00	NVDA	Stock	0.618	0.6184	0.5894	0.6175	19961200.0
2011-01-24 17:00:00	NVDA	Stock	0.6175	0.6183	0.616	0.616	918520.0
2011-01-24 18:00:00	NVDA	Stock	0.6162	0.6162	0.6153	0.6162	273040.0
2011-01-24 19:00:00	NVDA	Stock	0.617	0.6175	0.6155	0.6175	237280.0
2011-01-24 08:00:00	AMZN	Stock	8.922	8.94	8.9	8.9345	120280.0
2011-01-24 09:00:00	AMZN	Stock	8.938	8.938	8.7074	8.76	24730960.0
2011-01-24 10:00:00	AMZN	Stock	8.7625	8.804	8.709	8.7755	20072920.0
2011-01-24 11:00:00	AMZN	Stock	8.7755	8.8515	8.7725	8.8133	17712020.0
2011-01-24 12:00:00	AMZN	Stock	8.815	8.855	8.797	8.8375	8450880.0
2011-01-24 13:00:00	AMZN	Stock	8.8375	8.883	8.83	8.8515	8366680.0
2011-01-24 14:00:00	AMZN	Stock	8.8515	8.894	8.8425	8.8545	8553160.0

> showing 50 of 45,554 rows — these rows as CSV

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