PREVIEW / stock_1hour / 2010-03-11

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-03-11.parquet
  size:    898 KB
  rows:    42,793
  symbols: 3,461

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
2010-03-11 05:00:00	AAPL	Stock	8.0618	8.0618	8.0618	8.0618	7000.0
2010-03-11 07:00:00	AAPL	Stock	8.0393	8.0429	8.025	8.025	128912.0
2010-03-11 08:00:00	AAPL	Stock	8.025	8.0307	7.9889	8.0	1760528.0
2010-03-11 09:00:00	AAPL	Stock	7.9971	8.0261	7.9757	7.9957	72569840.0
2010-03-11 10:00:00	AAPL	Stock	7.9961	8.0229	7.9936	8.0186	58742964.0
2010-03-11 11:00:00	AAPL	Stock	8.0188	8.0268	8.0	8.0221	45756928.0
2010-03-11 12:00:00	AAPL	Stock	8.0218	8.0218	7.9954	8.0129	40045068.0
2010-03-11 13:00:00	AAPL	Stock	8.0139	8.0204	8.0075	8.0125	25860884.0
2010-03-11 14:00:00	AAPL	Stock	8.0121	8.0143	7.9864	8.0107	46223184.0
2010-03-11 15:00:00	AAPL	Stock	8.0107	8.0536	8.0089	8.0536	96835984.0
2010-03-11 16:00:00	AAPL	Stock	8.0532	8.0571	8.0127	8.0554	8976716.0
2010-03-11 17:00:00	AAPL	Stock	8.0568	8.0614	8.0511	8.0536	513184.0
2010-03-11 18:00:00	AAPL	Stock	8.0539	8.0571	8.0429	8.0464	425264.0
2010-03-11 19:00:00	AAPL	Stock	8.0471	8.0514	8.0439	8.0446	248780.0
2010-03-11 06:00:00	MSFT	Stock	29.12	29.12	29.12	29.12	100.0
2010-03-11 08:00:00	MSFT	Stock	28.98	29.0	28.92	28.94	8170.0
2010-03-11 09:00:00	MSFT	Stock	28.9	29.04	28.85	28.945	3497895.0
2010-03-11 10:00:00	MSFT	Stock	28.95	29.16	28.913	29.102	6108988.0
2010-03-11 11:00:00	MSFT	Stock	29.1	29.13	28.96	28.979	5556478.0
2010-03-11 12:00:00	MSFT	Stock	28.97	28.99	28.92	28.963	3456313.0
2010-03-11 13:00:00	MSFT	Stock	28.965	29.06	28.94	29.03	2549760.0
2010-03-11 14:00:00	MSFT	Stock	29.03	29.08	28.99	29.06	3109800.0
2010-03-11 15:00:00	MSFT	Stock	29.062	29.19	29.06	29.17	8536490.0
2010-03-11 16:00:00	MSFT	Stock	29.17	29.19	28.94	29.18	1484308.0
2010-03-11 17:00:00	MSFT	Stock	29.18	29.18	29.18	29.18	1490.0
2010-03-11 18:00:00	MSFT	Stock	29.15	29.18	29.14	29.18	1376.0
2010-03-11 19:00:00	MSFT	Stock	29.15	29.18	29.12	29.12	3972.0
2010-03-11 08:00:00	NVDA	Stock	0.4398	0.44	0.4398	0.44	12000.0
2010-03-11 09:00:00	NVDA	Stock	0.4358	0.4372	0.4322	0.435	59086720.0
2010-03-11 10:00:00	NVDA	Stock	0.4352	0.4365	0.4332	0.4362	58738120.0
2010-03-11 11:00:00	NVDA	Stock	0.4365	0.4378	0.4318	0.4322	54990600.0
2010-03-11 12:00:00	NVDA	Stock	0.4322	0.4325	0.4295	0.4315	54065920.0
2010-03-11 13:00:00	NVDA	Stock	0.4318	0.4322	0.4305	0.4305	45773280.0
2010-03-11 14:00:00	NVDA	Stock	0.4308	0.4308	0.428	0.4289	87887520.0
2010-03-11 15:00:00	NVDA	Stock	0.429	0.4302	0.4282	0.4298	165788560.0
2010-03-11 16:00:00	NVDA	Stock	0.4295	0.4315	0.429	0.431	2177600.0
2010-03-11 17:00:00	NVDA	Stock	0.431	0.4325	0.4302	0.4325	172800.0
2010-03-11 18:00:00	NVDA	Stock	0.4298	0.4298	0.4298	0.4298	5924040.0
2010-03-11 07:00:00	AMZN	Stock	6.525	6.525	6.525	6.525	2000.0
2010-03-11 08:00:00	AMZN	Stock	6.54	6.54	6.506	6.5065	148100.0
2010-03-11 09:00:00	AMZN	Stock	6.5145	6.59	6.5145	6.585	20220440.0
2010-03-11 10:00:00	AMZN	Stock	6.585	6.6315	6.5805	6.6235	27865000.0
2010-03-11 11:00:00	AMZN	Stock	6.623	6.6475	6.6085	6.647	21708180.0
2010-03-11 12:00:00	AMZN	Stock	6.647	6.6495	6.63	6.6485	20125120.0
2010-03-11 13:00:00	AMZN	Stock	6.6485	6.665	6.643	6.643	12532760.0
2010-03-11 14:00:00	AMZN	Stock	6.643	6.644	6.614	6.6325	12928080.0
2010-03-11 15:00:00	AMZN	Stock	6.6315	6.681	6.6312	6.679	26386880.0
2010-03-11 16:00:00	AMZN	Stock	6.6785	6.7	6.6245	6.695	701440.0
2010-03-11 17:00:00	AMZN	Stock	6.6975	6.7	6.695	6.696	65820.0
2010-03-11 18:00:00	AMZN	Stock	6.697	6.6995	6.679	6.6985	159360.0

> showing 50 of 42,793 rows — these rows as CSV

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