PREVIEW / stock_1hour / 2011-03-01

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-03-01.parquet
  size:    966 KB
  rows:    46,364
  symbols: 3,536

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-03-01 04:00:00	AAPL	Stock	12.6793	12.7179	12.6793	12.7179	8400.0
2011-03-01 05:00:00	AAPL	Stock	12.6964	12.6964	12.6964	12.6964	22400.0
2011-03-01 06:00:00	AAPL	Stock	12.7111	12.7139	12.6782	12.6786	69580.0
2011-03-01 07:00:00	AAPL	Stock	12.6936	12.6936	12.6254	12.6536	439236.0
2011-03-01 08:00:00	AAPL	Stock	12.6536	12.6964	12.6464	12.6661	1216908.0
2011-03-01 09:00:00	AAPL	Stock	12.6664	12.7043	12.5714	12.6207	59209920.0
2011-03-01 10:00:00	AAPL	Stock	12.6257	12.6339	12.5357	12.6146	78190476.0
2011-03-01 11:00:00	AAPL	Stock	12.6168	12.6304	12.5	12.5136	51291856.0
2011-03-01 12:00:00	AAPL	Stock	12.5125	12.5357	12.4746	12.4954	47394816.0
2011-03-01 13:00:00	AAPL	Stock	12.4896	12.52	12.4661	12.5111	46111408.0
2011-03-01 14:00:00	AAPL	Stock	12.5076	12.5111	12.4232	12.4468	66932264.0
2011-03-01 15:00:00	AAPL	Stock	12.4466	12.4968	12.4172	12.4821	73251136.0
2011-03-01 16:00:00	AAPL	Stock	12.475	12.5299	12.4286	12.4386	14852292.0
2011-03-01 17:00:00	AAPL	Stock	12.4389	12.4825	12.4304	12.4443	1440040.0
2011-03-01 18:00:00	AAPL	Stock	12.4454	12.4754	12.4371	12.4582	738892.0
2011-03-01 19:00:00	AAPL	Stock	12.4636	12.4639	12.4468	12.4554	343840.0
2011-03-01 04:00:00	MSFT	Stock	26.74	26.74	26.74	26.74	300.0
2011-03-01 06:00:00	MSFT	Stock	26.74	26.74	26.74	26.74	100.0
2011-03-01 07:00:00	MSFT	Stock	26.7	26.71	26.69	26.7	1500.0
2011-03-01 08:00:00	MSFT	Stock	26.69	26.7	26.65	26.69	10495.0
2011-03-01 09:00:00	MSFT	Stock	26.68	26.78	26.58	26.66	5773485.0
2011-03-01 10:00:00	MSFT	Stock	26.66	26.7	26.49	26.534	8074780.0
2011-03-01 11:00:00	MSFT	Stock	26.53	26.56	26.42	26.447	6538409.0
2011-03-01 12:00:00	MSFT	Stock	26.44	26.47	26.37	26.4	6081382.0
2011-03-01 13:00:00	MSFT	Stock	26.4	26.41	26.33	26.41	6730334.0
2011-03-01 14:00:00	MSFT	Stock	26.41	26.41	26.2	26.22	7418815.0
2011-03-01 15:00:00	MSFT	Stock	26.23	26.24	26.15	26.17	14601910.0
2011-03-01 16:00:00	MSFT	Stock	26.18	26.393	26.1	26.1	3244023.0
2011-03-01 17:00:00	MSFT	Stock	26.1	26.54	26.05	26.08	595362.0
2011-03-01 18:00:00	MSFT	Stock	26.08	26.16	26.08	26.1	6267.0
2011-03-01 19:00:00	MSFT	Stock	26.06	26.11	26.06	26.1	8047.0
2011-03-01 04:00:00	NVDA	Stock	0.5662	0.5662	0.5662	0.5662	8000.0
2011-03-01 07:00:00	NVDA	Stock	0.571	0.5725	0.57	0.57	40000.0
2011-03-01 08:00:00	NVDA	Stock	0.57	0.571	0.56	0.5638	963240.0
2011-03-01 09:00:00	NVDA	Stock	0.563	0.5748	0.5475	0.5562	155816840.0
2011-03-01 10:00:00	NVDA	Stock	0.556	0.5688	0.5542	0.5672	184238400.0
2011-03-01 11:00:00	NVDA	Stock	0.5672	0.5685	0.559	0.5592	98709920.0
2011-03-01 12:00:00	NVDA	Stock	0.5595	0.5605	0.5552	0.5562	76102960.0
2011-03-01 13:00:00	NVDA	Stock	0.5562	0.5568	0.5515	0.5538	71413360.0
2011-03-01 14:00:00	NVDA	Stock	0.5538	0.5542	0.5462	0.5468	118326720.0
2011-03-01 15:00:00	NVDA	Stock	0.5469	0.5488	0.5412	0.5418	264070120.0
2011-03-01 16:00:00	NVDA	Stock	0.5416	0.5544	0.539	0.5412	14616760.0
2011-03-01 17:00:00	NVDA	Stock	0.5412	0.543	0.54	0.5418	1145000.0
2011-03-01 18:00:00	NVDA	Stock	0.5422	0.5432	0.5392	0.5405	1012400.0
2011-03-01 19:00:00	NVDA	Stock	0.541	0.5412	0.5382	0.5412	399000.0
2011-03-01 06:00:00	AMZN	Stock	8.6955	8.6955	8.6955	8.6955	2000.0
2011-03-01 07:00:00	AMZN	Stock	8.6975	8.6975	8.6895	8.69	14000.0
2011-03-01 08:00:00	AMZN	Stock	8.675	8.694	8.6645	8.694	108420.0
2011-03-01 09:00:00	AMZN	Stock	8.694	8.7225	8.5755	8.606	16429820.0
2011-03-01 10:00:00	AMZN	Stock	8.6065	8.636	8.5155	8.571	21137440.0

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

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