PREVIEW / stock_1hour / 2011-04-05

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-04-05.parquet
  size:    942 KB
  rows:    44,507
  symbols: 3,545

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-04-05 04:00:00	AAPL	Stock	11.9786	11.9786	11.7679	11.8393	252364.0
2011-04-05 05:00:00	AAPL	Stock	11.8214	11.8529	11.8143	11.825	192780.0
2011-04-05 06:00:00	AAPL	Stock	11.8268	11.8571	11.7857	11.8571	696444.0
2011-04-05 07:00:00	AAPL	Stock	11.8868	12.0714	11.885	12.0357	4879896.0
2011-04-05 08:00:00	AAPL	Stock	12.0357	12.0536	11.9339	12.0232	9143652.0
2011-04-05 09:00:00	AAPL	Stock	12.02	12.1136	12.0	12.0786	107528988.0
2011-04-05 10:00:00	AAPL	Stock	12.0768	12.2011	12.0582	12.1786	104629896.0
2011-04-05 11:00:00	AAPL	Stock	12.1786	12.1894	12.1304	12.1507	48545616.0
2011-04-05 12:00:00	AAPL	Stock	12.1507	12.2232	12.1496	12.1818	45171784.0
2011-04-05 13:00:00	AAPL	Stock	12.1823	12.2086	12.1646	12.1941	28803852.0
2011-04-05 14:00:00	AAPL	Stock	12.1939	12.2018	12.0907	12.1118	51792356.0
2011-04-05 15:00:00	AAPL	Stock	12.1114	12.1179	12.0571	12.0961	65863840.0
2011-04-05 16:00:00	AAPL	Stock	12.1021	12.1309	12.0284	12.0925	8138760.0
2011-04-05 17:00:00	AAPL	Stock	12.0918	12.0929	12.0875	12.0911	86156.0
2011-04-05 18:00:00	AAPL	Stock	12.0925	12.1071	12.0925	12.0986	222292.0
2011-04-05 19:00:00	AAPL	Stock	12.1036	12.1043	12.0957	12.0996	83384.0
2011-04-05 04:00:00	MSFT	Stock	25.76	25.89	25.72	25.89	40850.0
2011-04-05 05:00:00	MSFT	Stock	25.89	26.0	25.86	25.95	30633.0
2011-04-05 06:00:00	MSFT	Stock	26.0	26.24	25.91	26.2	109921.0
2011-04-05 07:00:00	MSFT	Stock	26.2	26.27	25.91	25.95	432821.0
2011-04-05 08:00:00	MSFT	Stock	25.99	26.0	25.83	25.94	1152575.0
2011-04-05 09:00:00	MSFT	Stock	25.95	26.18	25.77	25.88	16404515.0
2011-04-05 10:00:00	MSFT	Stock	25.88	25.96	25.75	25.94	14025687.0
2011-04-05 11:00:00	MSFT	Stock	25.94	26.07	25.94	26.0	11268120.0
2011-04-05 12:00:00	MSFT	Stock	25.998	26.0	25.89	25.99	4579700.0
2011-04-05 13:00:00	MSFT	Stock	25.99	26.0	25.9	25.92	3452545.0
2011-04-05 14:00:00	MSFT	Stock	25.924	25.93	25.82	25.873	5759462.0
2011-04-05 15:00:00	MSFT	Stock	25.88	25.88	25.74	25.76	12873864.0
2011-04-05 16:00:00	MSFT	Stock	25.76	25.994	25.55	25.78	2016018.0
2011-04-05 17:00:00	MSFT	Stock	25.78	25.81	25.7	25.78	47666.0
2011-04-05 18:00:00	MSFT	Stock	25.78	25.8	25.78	25.8	42311.0
2011-04-05 19:00:00	MSFT	Stock	25.78	25.81	25.78	25.81	1069.0
2011-04-05 07:00:00	NVDA	Stock	0.4468	0.4475	0.444	0.4462	468000.0
2011-04-05 08:00:00	NVDA	Stock	0.4462	0.4515	0.4452	0.4458	1763400.0
2011-04-05 09:00:00	NVDA	Stock	0.446	0.4462	0.4388	0.4436	167562640.0
2011-04-05 10:00:00	NVDA	Stock	0.4435	0.4488	0.44	0.4472	179665080.0
2011-04-05 11:00:00	NVDA	Stock	0.447	0.4478	0.4448	0.4462	85463400.0
2011-04-05 12:00:00	NVDA	Stock	0.4464	0.4468	0.4442	0.445	59155160.0
2011-04-05 13:00:00	NVDA	Stock	0.445	0.446	0.444	0.4445	42044600.0
2011-04-05 14:00:00	NVDA	Stock	0.4445	0.4452	0.4392	0.4405	100123640.0
2011-04-05 15:00:00	NVDA	Stock	0.4405	0.4422	0.4385	0.4392	166671440.0
2011-04-05 16:00:00	NVDA	Stock	0.4392	0.4433	0.4392	0.4398	1314600.0
2011-04-05 17:00:00	NVDA	Stock	0.4398	0.4412	0.4388	0.4412	934440.0
2011-04-05 18:00:00	NVDA	Stock	0.4412	0.4412	0.4412	0.4412	76000.0
2011-04-05 19:00:00	NVDA	Stock	0.4392	0.4408	0.4392	0.44	49400.0
2011-04-05 06:00:00	AMZN	Stock	9.1765	9.1765	9.17	9.17	4000.0
2011-04-05 07:00:00	AMZN	Stock	9.15	9.15	9.0995	9.0995	40000.0
2011-04-05 08:00:00	AMZN	Stock	9.143	9.143	9.09	9.09	48320.0
2011-04-05 09:00:00	AMZN	Stock	9.0945	9.222	9.09	9.179	13956780.0
2011-04-05 10:00:00	AMZN	Stock	9.1775	9.318	9.152	9.2485	27350180.0

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

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