PREVIEW / stock_1hour / 2010-08-30

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-08-30.parquet
  size:    907 KB
  rows:    44,068
  symbols: 3,459

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-08-30 06:00:00	AAPL	Stock	8.65	8.65	8.65	8.65	14000.0
2010-08-30 07:00:00	AAPL	Stock	8.6375	8.6489	8.6254	8.6393	153832.0
2010-08-30 08:00:00	AAPL	Stock	8.6329	8.6396	8.6107	8.6225	1630888.0
2010-08-30 09:00:00	AAPL	Stock	8.6225	8.7718	8.5914	8.7625	81639740.0
2010-08-30 10:00:00	AAPL	Stock	8.7625	8.7768	8.7279	8.7582	67533592.0
2010-08-30 11:00:00	AAPL	Stock	8.7581	8.7607	8.6975	8.7071	41564516.0
2010-08-30 12:00:00	AAPL	Stock	8.7061	8.7446	8.7061	8.735	29861916.0
2010-08-30 13:00:00	AAPL	Stock	8.7343	8.7429	8.7086	8.7121	32192300.0
2010-08-30 14:00:00	AAPL	Stock	8.7121	8.7357	8.7007	8.7214	32228868.0
2010-08-30 15:00:00	AAPL	Stock	8.7213	8.73	8.6561	8.6611	75420464.0
2010-08-30 16:00:00	AAPL	Stock	8.6607	8.719	8.6102	8.6671	16633036.0
2010-08-30 17:00:00	AAPL	Stock	8.6643	8.7159	8.6607	8.6711	675892.0
2010-08-30 18:00:00	AAPL	Stock	8.6661	8.6839	8.6654	8.6786	170688.0
2010-08-30 19:00:00	AAPL	Stock	8.6732	8.675	8.6286	8.675	341404.0
2010-08-30 07:00:00	MSFT	Stock	23.93	23.93	23.93	23.93	200.0
2010-08-30 08:00:00	MSFT	Stock	23.9	23.94	23.78	23.86	48328.0
2010-08-30 09:00:00	MSFT	Stock	23.84	23.89	23.65	23.73	4116730.0
2010-08-30 10:00:00	MSFT	Stock	23.73	23.82	23.69	23.76	6213156.0
2010-08-30 11:00:00	MSFT	Stock	23.76	23.79	23.665	23.7	5375392.0
2010-08-30 12:00:00	MSFT	Stock	23.7	23.77	23.69	23.72	3262184.0
2010-08-30 13:00:00	MSFT	Stock	23.725	23.77	23.68	23.72	3812269.0
2010-08-30 14:00:00	MSFT	Stock	23.72	23.8	23.69	23.749	4556693.0
2010-08-30 15:00:00	MSFT	Stock	23.75	23.77	23.6	23.64	11373171.0
2010-08-30 16:00:00	MSFT	Stock	23.64	23.755	23.62	23.62	5531692.0
2010-08-30 17:00:00	MSFT	Stock	23.706	23.706	23.63	23.63	47649.0
2010-08-30 18:00:00	MSFT	Stock	23.64	23.66	23.63	23.65	7148.0
2010-08-30 19:00:00	MSFT	Stock	23.64	23.68	23.63	23.63	37151.0
2010-08-30 08:00:00	NVDA	Stock	0.2485	0.2523	0.2485	0.252	76000.0
2010-08-30 09:00:00	NVDA	Stock	0.2513	0.252	0.2498	0.2503	69117520.0
2010-08-30 10:00:00	NVDA	Stock	0.25	0.251	0.247	0.2486	106833920.0
2010-08-30 11:00:00	NVDA	Stock	0.2488	0.249	0.245	0.2453	94263200.0
2010-08-30 12:00:00	NVDA	Stock	0.2451	0.2458	0.2438	0.2442	52410360.0
2010-08-30 13:00:00	NVDA	Stock	0.2442	0.2458	0.2428	0.243	80868920.0
2010-08-30 14:00:00	NVDA	Stock	0.243	0.2445	0.2428	0.244	27986840.0
2010-08-30 15:00:00	NVDA	Stock	0.244	0.2442	0.2412	0.2412	158184480.0
2010-08-30 16:00:00	NVDA	Stock	0.2412	0.2458	0.24	0.2412	3852840.0
2010-08-30 17:00:00	NVDA	Stock	0.2408	0.241	0.2405	0.2405	317960.0
2010-08-30 18:00:00	NVDA	Stock	0.24	0.2405	0.2398	0.2405	88000.0
2010-08-30 19:00:00	NVDA	Stock	0.2405	0.2408	0.2405	0.2408	25480.0
2010-08-30 08:00:00	AMZN	Stock	6.326	6.327	6.305	6.305	14600.0
2010-08-30 09:00:00	AMZN	Stock	6.305	6.3475	6.285	6.319	8278360.0
2010-08-30 10:00:00	AMZN	Stock	6.3195	6.346	6.2845	6.3095	9467420.0
2010-08-30 11:00:00	AMZN	Stock	6.3095	6.313	6.2375	6.2475	7962980.0
2010-08-30 12:00:00	AMZN	Stock	6.248	6.2615	6.235	6.251	6837580.0
2010-08-30 13:00:00	AMZN	Stock	6.25	6.2625	6.2225	6.233	8804700.0
2010-08-30 14:00:00	AMZN	Stock	6.2315	6.2375	6.201	6.2225	10089020.0
2010-08-30 15:00:00	AMZN	Stock	6.2215	6.232	6.1845	6.1845	14068800.0
2010-08-30 16:00:00	AMZN	Stock	6.1825	6.2534	6.181	6.181	1185940.0
2010-08-30 17:00:00	AMZN	Stock	6.1825	6.1895	6.175	6.175	99660.0
2010-08-30 19:00:00	AMZN	Stock	6.1895	6.1895	6.1895	6.1895	100000.0

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

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