PREVIEW / stock_1hour / 2012-01-19

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-01-19.parquet
  size:    939 KB
  rows:    44,407
  symbols: 3,499

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
2012-01-19 05:00:00	AAPL	Stock	15.3861	15.3861	15.3861	15.3861	5600.0
2012-01-19 06:00:00	AAPL	Stock	15.3771	15.3857	15.3714	15.3714	56000.0
2012-01-19 07:00:00	AAPL	Stock	15.3714	15.3968	15.3607	15.3761	524860.0
2012-01-19 08:00:00	AAPL	Stock	15.375	15.3929	15.3132	15.37	1765176.0
2012-01-19 09:00:00	AAPL	Stock	15.37	15.406	15.3179	15.3336	55005104.0
2012-01-19 10:00:00	AAPL	Stock	15.3311	15.356	15.2929	15.3417	49255976.0
2012-01-19 11:00:00	AAPL	Stock	15.3429	15.36	15.3214	15.3336	27917680.0
2012-01-19 12:00:00	AAPL	Stock	15.3334	15.3461	15.3121	15.3179	17423252.0
2012-01-19 13:00:00	AAPL	Stock	15.3168	15.3371	15.315	15.3311	13502636.0
2012-01-19 14:00:00	AAPL	Stock	15.3318	15.3489	15.3157	15.3232	19907664.0
2012-01-19 15:00:00	AAPL	Stock	15.3218	15.3336	15.2325	15.2725	53073748.0
2012-01-19 16:00:00	AAPL	Stock	15.2725	15.3396	15.1625	15.2321	19249132.0
2012-01-19 17:00:00	AAPL	Stock	15.2321	15.2446	15.22	15.2204	842492.0
2012-01-19 18:00:00	AAPL	Stock	15.2221	15.2768	15.22	15.225	331128.0
2012-01-19 19:00:00	AAPL	Stock	15.2268	15.2268	15.2143	15.2182	284060.0
2012-01-19 07:00:00	MSFT	Stock	28.21	28.3	28.18	28.3	18700.0
2012-01-19 08:00:00	MSFT	Stock	28.3	28.36	28.25	28.26	60835.0
2012-01-19 09:00:00	MSFT	Stock	28.29	28.37	28.05	28.159	8770387.0
2012-01-19 10:00:00	MSFT	Stock	28.15	28.32	28.14	28.315	9695136.0
2012-01-19 11:00:00	MSFT	Stock	28.315	28.435	28.3	28.323	8129531.0
2012-01-19 12:00:00	MSFT	Stock	28.33	28.34	28.19	28.24	7525943.0
2012-01-19 13:00:00	MSFT	Stock	28.231	28.26	28.12	28.13	7458976.0
2012-01-19 14:00:00	MSFT	Stock	28.125	28.2	28.11	28.135	7871946.0
2012-01-19 15:00:00	MSFT	Stock	28.135	28.175	28.03	28.13	16418225.0
2012-01-19 16:00:00	MSFT	Stock	28.129	29.0	27.84	28.76	6317358.0
2012-01-19 17:00:00	MSFT	Stock	28.76	28.82	28.12	28.82	276864.0
2012-01-19 18:00:00	MSFT	Stock	28.83	28.98	28.12	28.82	226019.0
2012-01-19 19:00:00	MSFT	Stock	28.85	28.88	28.76	28.8	27644.0
2012-01-19 07:00:00	NVDA	Stock	0.3525	0.3525	0.3525	0.3525	4000.0
2012-01-19 08:00:00	NVDA	Stock	0.3525	0.3528	0.3515	0.3525	252000.0
2012-01-19 09:00:00	NVDA	Stock	0.3525	0.354	0.3488	0.3538	70923680.0
2012-01-19 10:00:00	NVDA	Stock	0.3538	0.356	0.3513	0.353	76674680.0
2012-01-19 11:00:00	NVDA	Stock	0.3531	0.355	0.353	0.355	53921760.0
2012-01-19 12:00:00	NVDA	Stock	0.3548	0.355	0.3525	0.3541	53226800.0
2012-01-19 13:00:00	NVDA	Stock	0.3542	0.359	0.354	0.3578	143498640.0
2012-01-19 14:00:00	NVDA	Stock	0.3578	0.3585	0.357	0.357	66943440.0
2012-01-19 15:00:00	NVDA	Stock	0.357	0.3592	0.3565	0.3588	126343600.0
2012-01-19 16:00:00	NVDA	Stock	0.3588	0.3592	0.3498	0.3588	13522120.0
2012-01-19 17:00:00	NVDA	Stock	0.3588	0.3605	0.3582	0.3605	495640.0
2012-01-19 18:00:00	NVDA	Stock	0.3525	0.3525	0.3525	0.3525	120000.0
2012-01-19 19:00:00	NVDA	Stock	0.3592	0.36	0.3592	0.36	8000.0
2012-01-19 04:00:00	AMZN	Stock	9.4905	9.4905	9.488	9.488	12000.0
2012-01-19 05:00:00	AMZN	Stock	9.5035	9.5035	9.5035	9.5035	2020.0
2012-01-19 06:00:00	AMZN	Stock	9.48	9.485	9.48	9.485	7800.0
2012-01-19 07:00:00	AMZN	Stock	9.4795	9.515	9.456	9.5	188900.0
2012-01-19 08:00:00	AMZN	Stock	9.4975	9.537	9.4645	9.5135	344500.0
2012-01-19 09:00:00	AMZN	Stock	9.5125	9.672	9.5	9.6635	25136820.0
2012-01-19 10:00:00	AMZN	Stock	9.6656	9.797	9.625	9.72	37201580.0
2012-01-19 11:00:00	AMZN	Stock	9.7161	9.768	9.7114	9.7625	15082160.0
2012-01-19 12:00:00	AMZN	Stock	9.764	9.7874	9.6935	9.705	16179120.0

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

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