PREVIEW / stock_1hour / 2011-06-16

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-06-16.parquet
  size:    946 KB
  rows:    44,734
  symbols: 3,548

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-06-16 04:00:00	AAPL	Stock	11.6886	11.6886	11.6886	11.6886	2800.0
2011-06-16 05:00:00	AAPL	Stock	11.6518	11.6518	11.6518	11.6518	8400.0
2011-06-16 06:00:00	AAPL	Stock	11.6421	11.6421	11.6146	11.6271	11200.0
2011-06-16 07:00:00	AAPL	Stock	11.6271	11.6607	11.6271	11.6339	131600.0
2011-06-16 08:00:00	AAPL	Stock	11.6389	11.6964	11.6179	11.6964	1983380.0
2011-06-16 09:00:00	AAPL	Stock	11.7004	11.7071	11.6339	11.6911	51911300.0
2011-06-16 10:00:00	AAPL	Stock	11.69	11.7386	11.65	11.7075	68815292.0
2011-06-16 11:00:00	AAPL	Stock	11.7066	11.7075	11.6604	11.6654	34534052.0
2011-06-16 12:00:00	AAPL	Stock	11.6654	11.6907	11.6607	11.6786	18127172.0
2011-06-16 13:00:00	AAPL	Stock	11.6795	11.6814	11.5914	11.5939	37140432.0
2011-06-16 14:00:00	AAPL	Stock	11.5946	11.6107	11.3689	11.4329	139270096.0
2011-06-16 15:00:00	AAPL	Stock	11.4329	11.6129	11.4229	11.6129	136034724.0
2011-06-16 16:00:00	AAPL	Stock	11.6107	11.6575	11.5741	11.6357	16409904.0
2011-06-16 17:00:00	AAPL	Stock	11.6357	11.6429	11.6118	11.6304	527184.0
2011-06-16 18:00:00	AAPL	Stock	11.6375	11.6407	11.6129	11.6389	2751672.0
2011-06-16 19:00:00	AAPL	Stock	11.6304	11.6607	11.6304	11.6607	371980.0
2011-06-16 07:00:00	MSFT	Stock	23.67	23.67	23.66	23.66	500.0
2011-06-16 08:00:00	MSFT	Stock	23.72	23.74	23.7	23.72	10670.0
2011-06-16 09:00:00	MSFT	Stock	23.74	23.92	23.65	23.92	5187999.0
2011-06-16 10:00:00	MSFT	Stock	23.91	24.0	23.82	23.96	8327134.0
2011-06-16 11:00:00	MSFT	Stock	23.965	24.05	23.93	24.0	6475560.0
2011-06-16 12:00:00	MSFT	Stock	23.995	24.1	23.98	24.005	7829460.0
2011-06-16 13:00:00	MSFT	Stock	24.0	24.04	23.96	23.981	5076861.0
2011-06-16 14:00:00	MSFT	Stock	23.98	24.035	23.92	24.0	9364002.0
2011-06-16 15:00:00	MSFT	Stock	23.995	24.05	23.97	23.99	11705097.0
2011-06-16 16:00:00	MSFT	Stock	24.0	24.05	23.969	24.0	2864998.0
2011-06-16 17:00:00	MSFT	Stock	24.053	24.053	23.92	23.94	87375.0
2011-06-16 18:00:00	MSFT	Stock	23.97	24.0	23.97	24.0	100742.0
2011-06-16 19:00:00	MSFT	Stock	24.0	24.06	23.97	24.05	2706.0
2011-06-16 08:00:00	NVDA	Stock	0.4138	0.4175	0.4138	0.4175	322000.0
2011-06-16 09:00:00	NVDA	Stock	0.418	0.426	0.418	0.421	100611480.0
2011-06-16 10:00:00	NVDA	Stock	0.4211	0.4232	0.419	0.422	122853800.0
2011-06-16 11:00:00	NVDA	Stock	0.4218	0.4225	0.4185	0.419	86760120.0
2011-06-16 12:00:00	NVDA	Stock	0.4192	0.4192	0.4148	0.4148	88468000.0
2011-06-16 13:00:00	NVDA	Stock	0.4149	0.4152	0.4085	0.4085	137745880.0
2011-06-16 14:00:00	NVDA	Stock	0.4088	0.409	0.3988	0.4027	235523280.0
2011-06-16 15:00:00	NVDA	Stock	0.4028	0.4055	0.4013	0.405	227165080.0
2011-06-16 16:00:00	NVDA	Stock	0.4048	0.4117	0.4023	0.4048	18529000.0
2011-06-16 17:00:00	NVDA	Stock	0.4048	0.4055	0.4025	0.4025	191520.0
2011-06-16 18:00:00	NVDA	Stock	0.4013	0.4038	0.4013	0.4038	24000.0
2011-06-16 19:00:00	NVDA	Stock	0.4038	0.4055	0.4038	0.4053	48000.0
2011-06-16 08:00:00	AMZN	Stock	9.265	9.312	9.25	9.312	41700.0
2011-06-16 09:00:00	AMZN	Stock	9.3255	9.3715	9.1615	9.169	18919400.0
2011-06-16 10:00:00	AMZN	Stock	9.1665	9.2915	9.1365	9.229	25248940.0
2011-06-16 11:00:00	AMZN	Stock	9.2255	9.3045	9.2075	9.2815	11750760.0
2011-06-16 12:00:00	AMZN	Stock	9.2825	9.305	9.2655	9.2795	5133640.0
2011-06-16 13:00:00	AMZN	Stock	9.28	9.3025	9.2035	9.2072	6857720.0
2011-06-16 14:00:00	AMZN	Stock	9.2065	9.222	9.0795	9.118	19032900.0
2011-06-16 15:00:00	AMZN	Stock	9.12	9.184	9.0845	9.1835	29893560.0
2011-06-16 16:00:00	AMZN	Stock	9.1825	9.1979	9.1362	9.1795	3369480.0

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

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