PREVIEW / stock_1hour / 2012-12-07

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-12-07.parquet
  size:    934 KB
  rows:    44,446
  symbols: 3,481

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
2012-12-07 04:00:00	AAPL	Stock	19.5736	19.6	19.5736	19.6	19600.0
2012-12-07 05:00:00	AAPL	Stock	19.5743	19.5743	19.5361	19.5396	32032.0
2012-12-07 06:00:00	AAPL	Stock	19.5393	19.5625	19.5357	19.5357	36988.0
2012-12-07 07:00:00	AAPL	Stock	19.5568	19.6871	19.5536	19.5943	877996.0
2012-12-07 08:00:00	AAPL	Stock	19.6068	19.7411	19.3929	19.6907	11145120.0
2012-12-07 09:00:00	AAPL	Stock	19.6857	19.8286	19.4114	19.4286	117357828.0
2012-12-07 10:00:00	AAPL	Stock	19.4239	19.6136	19.1346	19.2711	166230764.0
2012-12-07 11:00:00	AAPL	Stock	19.2711	19.3082	19.0436	19.0593	94511452.0
2012-12-07 12:00:00	AAPL	Stock	19.0593	19.1879	18.9286	19.0561	113882636.0
2012-12-07 13:00:00	AAPL	Stock	19.0562	19.115	18.9643	19.0682	61143880.0
2012-12-07 14:00:00	AAPL	Stock	19.0664	19.2229	18.9825	19.1039	81709264.0
2012-12-07 15:00:00	AAPL	Stock	19.1036	19.155	18.9571	19.0364	118878676.0
2012-12-07 16:00:00	AAPL	Stock	19.0354	19.5457	18.976	19.0043	8608796.0
2012-12-07 17:00:00	AAPL	Stock	19.0061	19.0386	18.9732	18.9807	1587824.0
2012-12-07 18:00:00	AAPL	Stock	18.9821	18.9889	18.9668	18.9889	244776.0
2012-12-07 19:00:00	AAPL	Stock	18.9936	19.0218	18.9936	19.0089	521724.0
2012-12-07 05:00:00	MSFT	Stock	26.77	26.77	26.77	26.77	130.0
2012-12-07 08:00:00	MSFT	Stock	26.73	26.91	26.7	26.83	42178.0
2012-12-07 09:00:00	MSFT	Stock	26.79	26.85	26.41	26.42	5891363.0
2012-12-07 10:00:00	MSFT	Stock	26.42	26.52	26.38	26.475	7774993.0
2012-12-07 11:00:00	MSFT	Stock	26.47	26.53	26.39	26.45	5048864.0
2012-12-07 12:00:00	MSFT	Stock	26.46	26.51	26.44	26.443	2990175.0
2012-12-07 13:00:00	MSFT	Stock	26.45	26.48	26.42	26.43	3495257.0
2012-12-07 14:00:00	MSFT	Stock	26.44	26.49	26.4	26.4	5017871.0
2012-12-07 15:00:00	MSFT	Stock	26.4	26.47	26.37	26.46	12204263.0
2012-12-07 16:00:00	MSFT	Stock	26.45	26.74	26.38	26.45	2155312.0
2012-12-07 17:00:00	MSFT	Stock	26.47	26.47	26.45	26.46	51510.0
2012-12-07 18:00:00	MSFT	Stock	26.47	26.47	26.46	26.46	5078.0
2012-12-07 19:00:00	MSFT	Stock	26.46	26.48	26.46	26.46	14617.0
2012-12-07 08:00:00	NVDA	Stock	0.3	0.3025	0.2998	0.3025	326400.0
2012-12-07 09:00:00	NVDA	Stock	0.3012	0.3012	0.2985	0.2998	40109240.0
2012-12-07 10:00:00	NVDA	Stock	0.2998	0.301	0.2975	0.2976	59045880.0
2012-12-07 11:00:00	NVDA	Stock	0.2975	0.2981	0.2962	0.2965	54325440.0
2012-12-07 12:00:00	NVDA	Stock	0.2962	0.297	0.2955	0.296	44715320.0
2012-12-07 13:00:00	NVDA	Stock	0.296	0.2978	0.296	0.296	28788880.0
2012-12-07 14:00:00	NVDA	Stock	0.296	0.299	0.296	0.2985	42551560.0
2012-12-07 15:00:00	NVDA	Stock	0.2982	0.2998	0.2982	0.299	57636960.0
2012-12-07 16:00:00	NVDA	Stock	0.299	0.2998	0.2981	0.2998	5133960.0
2012-12-07 17:00:00	NVDA	Stock	0.2995	0.2998	0.2992	0.2992	204000.0
2012-12-07 19:00:00	NVDA	Stock	0.2992	0.2992	0.2992	0.2992	12400.0
2012-12-07 07:00:00	AMZN	Stock	12.66	12.66	12.66	12.66	2000.0
2012-12-07 08:00:00	AMZN	Stock	12.66	12.7575	12.62	12.706	450600.0
2012-12-07 09:00:00	AMZN	Stock	12.7005	12.7605	12.6005	12.6285	8020520.0
2012-12-07 10:00:00	AMZN	Stock	12.639	12.7105	12.624	12.6645	7182580.0
2012-12-07 11:00:00	AMZN	Stock	12.6705	12.6975	12.6095	12.6427	5915420.0
2012-12-07 12:00:00	AMZN	Stock	12.644	12.67	12.6295	12.653	3590160.0
2012-12-07 13:00:00	AMZN	Stock	12.6522	12.676	12.6455	12.6565	4312860.0
2012-12-07 14:00:00	AMZN	Stock	12.6495	12.6776	12.6345	12.674	3567280.0
2012-12-07 15:00:00	AMZN	Stock	12.672	12.6895	12.6564	12.659	7820960.0
2012-12-07 16:00:00	AMZN	Stock	12.664	12.6722	12.649	12.65	1789760.0

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

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