PREVIEW / stock_1hour / 2012-11-06

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-11-06.parquet
  size:    922 KB
  rows:    43,664
  symbols: 3,469

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-11-06 05:00:00	AAPL	Stock	20.9786	20.9786	20.9786	20.9786	8400.0
2012-11-06 06:00:00	AAPL	Stock	20.9786	21.0261	20.9782	21.0261	144984.0
2012-11-06 07:00:00	AAPL	Stock	21.0179	21.0632	21.0179	21.0586	924644.0
2012-11-06 08:00:00	AAPL	Stock	21.0586	21.0625	21.025	21.0425	2025408.0
2012-11-06 09:00:00	AAPL	Stock	21.0454	21.0979	20.9571	20.9671	51627940.0
2012-11-06 10:00:00	AAPL	Stock	20.9664	20.9939	20.8714	20.9207	48736660.0
2012-11-06 11:00:00	AAPL	Stock	20.9207	20.9714	20.8396	20.9161	43699152.0
2012-11-06 12:00:00	AAPL	Stock	20.915	20.9936	20.9125	20.93	31193512.0
2012-11-06 13:00:00	AAPL	Stock	20.9271	20.9318	20.8579	20.8718	25595388.0
2012-11-06 14:00:00	AAPL	Stock	20.8711	20.8929	20.7371	20.7907	41947976.0
2012-11-06 15:00:00	AAPL	Stock	20.7857	20.8489	20.7175	20.8161	77913640.0
2012-11-06 16:00:00	AAPL	Stock	20.8203	20.9971	20.7735	20.8254	25914140.0
2012-11-06 17:00:00	AAPL	Stock	20.8257	20.8443	20.8161	20.83	458276.0
2012-11-06 18:00:00	AAPL	Stock	20.8321	20.8393	20.8221	20.8393	286748.0
2012-11-06 19:00:00	AAPL	Stock	20.8339	20.8339	20.7904	20.7904	216132.0
2012-11-06 07:00:00	MSFT	Stock	29.62	29.62	29.62	29.62	100.0
2012-11-06 08:00:00	MSFT	Stock	29.63	29.75	29.58	29.7	19718.0
2012-11-06 09:00:00	MSFT	Stock	29.7	29.95	29.61	29.77	4796948.0
2012-11-06 10:00:00	MSFT	Stock	29.77	29.95	29.71	29.89	6247569.0
2012-11-06 11:00:00	MSFT	Stock	29.89	30.06	29.86	30.052	6292096.0
2012-11-06 12:00:00	MSFT	Stock	30.06	30.2	30.04	30.093	6704795.0
2012-11-06 13:00:00	MSFT	Stock	30.1	30.1	29.94	29.96	4125078.0
2012-11-06 14:00:00	MSFT	Stock	29.955	29.99	29.84	29.89	3418887.0
2012-11-06 15:00:00	MSFT	Stock	29.89	29.94	29.8	29.86	7893322.0
2012-11-06 16:00:00	MSFT	Stock	29.85	29.928	29.597	29.88	3439884.0
2012-11-06 17:00:00	MSFT	Stock	29.86	29.87	29.86	29.87	300.0
2012-11-06 18:00:00	MSFT	Stock	29.86	29.86	29.81	29.84	2987.0
2012-11-06 19:00:00	MSFT	Stock	29.87	29.87	29.81	29.82	3837.0
2012-11-06 09:00:00	NVDA	Stock	0.3255	0.3263	0.3218	0.3223	42194600.0
2012-11-06 10:00:00	NVDA	Stock	0.322	0.3233	0.3198	0.3225	73204960.0
2012-11-06 11:00:00	NVDA	Stock	0.3228	0.325	0.3225	0.324	81762160.0
2012-11-06 12:00:00	NVDA	Stock	0.324	0.3263	0.323	0.325	35512200.0
2012-11-06 13:00:00	NVDA	Stock	0.3248	0.326	0.3238	0.3255	29009320.0
2012-11-06 14:00:00	NVDA	Stock	0.3253	0.326	0.3243	0.3253	31536080.0
2012-11-06 15:00:00	NVDA	Stock	0.3253	0.3253	0.324	0.3253	48373480.0
2012-11-06 16:00:00	NVDA	Stock	0.3253	0.3263	0.3238	0.3253	8889080.0
2012-11-06 17:00:00	NVDA	Stock	0.3268	0.327	0.3268	0.3268	100000.0
2012-11-06 07:00:00	AMZN	Stock	11.7945	11.7945	11.7945	11.7945	2000.0
2012-11-06 08:00:00	AMZN	Stock	11.7535	11.762	11.705	11.7615	16000.0
2012-11-06 09:00:00	AMZN	Stock	11.7735	11.84	11.7225	11.8391	9209460.0
2012-11-06 10:00:00	AMZN	Stock	11.84	11.85	11.7815	11.8118	9415420.0
2012-11-06 11:00:00	AMZN	Stock	11.8185	11.8565	11.808	11.8425	6263180.0
2012-11-06 12:00:00	AMZN	Stock	11.842	11.8875	11.83	11.837	5584400.0
2012-11-06 13:00:00	AMZN	Stock	11.843	11.8625	11.826	11.84	2786000.0
2012-11-06 14:00:00	AMZN	Stock	11.844	11.855	11.808	11.8305	4657480.0
2012-11-06 15:00:00	AMZN	Stock	11.8305	11.8835	11.827	11.883	11509160.0
2012-11-06 16:00:00	AMZN	Stock	11.8745	11.906	11.8173	11.8835	3669100.0
2012-11-06 19:00:00	AMZN	Stock	11.8965	11.8995	11.861	11.862	60800.0
2012-11-06 06:00:00	META	Stock	21.28	21.28	21.28	21.28	100.0
2012-11-06 07:00:00	META	Stock	21.33	21.35	21.25	21.25	33900.0

> showing 50 of 43,664 rows — these rows as CSV

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