PREVIEW / stock_1hour / 2009-11-20

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-11-20.parquet
  size:    880 KB
  rows:    42,043
  symbols: 3,414

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
2009-11-20 04:00:00	AAPL	Stock	7.1707	7.1707	7.1707	7.1707	3500.0
2009-11-20 05:00:00	AAPL	Stock	7.1546	7.1546	7.1411	7.1411	13916.0
2009-11-20 06:00:00	AAPL	Stock	7.1425	7.1425	7.1375	7.1375	12292.0
2009-11-20 07:00:00	AAPL	Stock	7.1232	7.1282	7.1182	7.1282	11200.0
2009-11-20 08:00:00	AAPL	Stock	7.1304	7.1425	7.0954	7.1107	2173752.0
2009-11-20 09:00:00	AAPL	Stock	7.1161	7.1346	7.0629	7.1182	85448916.0
2009-11-20 10:00:00	AAPL	Stock	7.1175	7.1275	7.1036	7.1155	55647872.0
2009-11-20 11:00:00	AAPL	Stock	7.1157	7.1307	7.1	7.12	40313868.0
2009-11-20 12:00:00	AAPL	Stock	7.12	7.1332	7.1164	7.1314	22166368.0
2009-11-20 13:00:00	AAPL	Stock	7.1314	7.1564	7.1311	7.1507	40349820.0
2009-11-20 14:00:00	AAPL	Stock	7.1505	7.1568	7.1457	7.1484	34933444.0
2009-11-20 15:00:00	AAPL	Stock	7.1479	7.15	7.1354	7.1404	82927208.0
2009-11-20 16:00:00	AAPL	Stock	7.1404	7.1443	7.1246	7.1429	9460612.0
2009-11-20 17:00:00	AAPL	Stock	7.1436	7.1443	7.1393	7.1393	204092.0
2009-11-20 18:00:00	AAPL	Stock	7.1393	7.1447	7.1393	7.1396	150444.0
2009-11-20 19:00:00	AAPL	Stock	7.1411	7.1421	7.1393	7.1393	97440.0
2009-11-20 08:00:00	MSFT	Stock	29.7	29.73	29.62	29.62	24846.0
2009-11-20 09:00:00	MSFT	Stock	29.65	29.73	29.43	29.52	6703489.0
2009-11-20 10:00:00	MSFT	Stock	29.52	29.55	29.45	29.55	6208451.0
2009-11-20 11:00:00	MSFT	Stock	29.54	29.65	29.5	29.56	3929698.0
2009-11-20 12:00:00	MSFT	Stock	29.56	29.57	29.43	29.5	2856651.0
2009-11-20 13:00:00	MSFT	Stock	29.502	29.63	29.5	29.598	3225246.0
2009-11-20 14:00:00	MSFT	Stock	29.6	29.65	29.56	29.62	3460262.0
2009-11-20 15:00:00	MSFT	Stock	29.61	29.77	29.6	29.63	6982655.0
2009-11-20 16:00:00	MSFT	Stock	29.63	29.67	29.555	29.66	1801580.0
2009-11-20 17:00:00	MSFT	Stock	29.66	29.67	29.6	29.67	103094.0
2009-11-20 18:00:00	MSFT	Stock	29.673	29.68	29.673	29.68	3990.0
2009-11-20 19:00:00	MSFT	Stock	29.69	29.69	29.69	29.69	100.0
2009-11-20 08:00:00	NVDA	Stock	0.3205	0.3205	0.3188	0.3188	578320.0
2009-11-20 09:00:00	NVDA	Stock	0.3183	0.322	0.3163	0.321	86033400.0
2009-11-20 10:00:00	NVDA	Stock	0.3209	0.322	0.3193	0.3213	70575640.0
2009-11-20 11:00:00	NVDA	Stock	0.321	0.3218	0.32	0.3209	40622440.0
2009-11-20 12:00:00	NVDA	Stock	0.3209	0.3215	0.3208	0.3213	18932520.0
2009-11-20 13:00:00	NVDA	Stock	0.3214	0.3225	0.3203	0.3225	73703520.0
2009-11-20 14:00:00	NVDA	Stock	0.3223	0.324	0.322	0.322	37382400.0
2009-11-20 15:00:00	NVDA	Stock	0.322	0.3235	0.3208	0.3225	84820600.0
2009-11-20 16:00:00	NVDA	Stock	0.3225	0.3225	0.3211	0.3211	11837120.0
2009-11-20 17:00:00	NVDA	Stock	0.3225	0.3225	0.3225	0.3225	40000.0
2009-11-20 18:00:00	NVDA	Stock	0.3225	0.3225	0.3225	0.3225	24000.0
2009-11-20 19:00:00	NVDA	Stock	0.3225	0.3245	0.322	0.322	156000.0
2009-11-20 08:00:00	AMZN	Stock	6.4395	6.4495	6.365	6.394	814860.0
2009-11-20 09:00:00	AMZN	Stock	6.388	6.4625	6.3705	6.426	22119920.0
2009-11-20 10:00:00	AMZN	Stock	6.4255	6.4675	6.413	6.445	22668400.0
2009-11-20 11:00:00	AMZN	Stock	6.446	6.4545	6.428	6.447	10753580.0
2009-11-20 12:00:00	AMZN	Stock	6.448	6.449	6.436	6.4448	8427760.0
2009-11-20 13:00:00	AMZN	Stock	6.4458	6.482	6.439	6.4805	13462540.0
2009-11-20 14:00:00	AMZN	Stock	6.481	6.4935	6.4805	6.483	14283560.0
2009-11-20 15:00:00	AMZN	Stock	6.483	6.4995	6.4675	6.483	31938280.0
2009-11-20 16:00:00	AMZN	Stock	6.488	6.4995	6.4402	6.49	3256640.0
2009-11-20 17:00:00	AMZN	Stock	6.4495	6.501	6.4495	6.483	1059820.0

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

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