PREVIEW / stock_1hour / 2012-09-04

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-09-04.parquet
  size:    930 KB
  rows:    43,677
  symbols: 3,468

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-09-04 04:00:00	AAPL	Stock	23.8607	23.8839	23.8571	23.8661	148512.0
2012-09-04 05:00:00	AAPL	Stock	23.8839	23.8839	23.8839	23.8839	16800.0
2012-09-04 06:00:00	AAPL	Stock	23.8839	23.8839	23.86	23.86	7980.0
2012-09-04 07:00:00	AAPL	Stock	23.8568	23.8671	23.8036	23.8571	599144.0
2012-09-04 08:00:00	AAPL	Stock	23.8482	23.9286	23.6964	23.7704	1547084.0
2012-09-04 09:00:00	AAPL	Stock	23.7643	23.9582	23.7582	23.9518	55461532.0
2012-09-04 10:00:00	AAPL	Stock	23.9486	23.9932	23.7321	23.7429	70155960.0
2012-09-04 11:00:00	AAPL	Stock	23.7429	23.885	23.7414	23.8645	38445428.0
2012-09-04 12:00:00	AAPL	Stock	23.8661	23.9279	23.8171	23.9196	35680960.0
2012-09-04 13:00:00	AAPL	Stock	23.9236	23.9679	23.9146	23.9359	27080088.0
2012-09-04 14:00:00	AAPL	Stock	23.935	24.1	23.9214	24.0746	56684544.0
2012-09-04 15:00:00	AAPL	Stock	24.0746	24.1121	24.0446	24.0943	68578384.0
2012-09-04 16:00:00	AAPL	Stock	24.0932	24.1268	23.7961	24.0982	8665860.0
2012-09-04 17:00:00	AAPL	Stock	24.0982	24.1179	24.0918	24.1132	303772.0
2012-09-04 18:00:00	AAPL	Stock	24.1175	24.1186	24.1089	24.11	168812.0
2012-09-04 19:00:00	AAPL	Stock	24.11	24.1111	24.0989	24.1068	311948.0
2012-09-04 04:00:00	MSFT	Stock	30.81	30.81	30.78	30.78	200.0
2012-09-04 05:00:00	MSFT	Stock	31.0	31.02	31.0	31.02	600.0
2012-09-04 07:00:00	MSFT	Stock	30.89	30.89	30.85	30.85	290.0
2012-09-04 08:00:00	MSFT	Stock	30.89	30.95	30.82	30.82	22551.0
2012-09-04 09:00:00	MSFT	Stock	30.82	30.82	29.88	30.571	7185268.0
2012-09-04 10:00:00	MSFT	Stock	30.57	30.63	30.17	30.2	8063937.0
2012-09-04 11:00:00	MSFT	Stock	30.2	30.34	30.15	30.335	4950777.0
2012-09-04 12:00:00	MSFT	Stock	30.34	30.34	30.23	30.29	5995465.0
2012-09-04 13:00:00	MSFT	Stock	30.28	30.31	30.2	30.24	3395120.0
2012-09-04 14:00:00	MSFT	Stock	30.235	30.42	30.2	30.39	5656697.0
2012-09-04 15:00:00	MSFT	Stock	30.385	30.44	30.34	30.35	7354743.0
2012-09-04 16:00:00	MSFT	Stock	30.35	30.771	30.3	30.37	2465116.0
2012-09-04 17:00:00	MSFT	Stock	30.4	30.43	30.38	30.38	5368.0
2012-09-04 18:00:00	MSFT	Stock	30.38	30.42	30.38	30.42	1050.0
2012-09-04 19:00:00	MSFT	Stock	30.39	30.39	30.38	30.39	4110.0
2012-09-04 07:00:00	NVDA	Stock	0.348	0.3485	0.345	0.3465	248000.0
2012-09-04 08:00:00	NVDA	Stock	0.3465	0.347	0.3445	0.345	728000.0
2012-09-04 09:00:00	NVDA	Stock	0.345	0.3462	0.3385	0.339	80461400.0
2012-09-04 10:00:00	NVDA	Stock	0.339	0.339	0.3328	0.333	107710680.0
2012-09-04 11:00:00	NVDA	Stock	0.333	0.3338	0.3308	0.3311	114874960.0
2012-09-04 12:00:00	NVDA	Stock	0.3313	0.3313	0.3293	0.3299	72868040.0
2012-09-04 13:00:00	NVDA	Stock	0.33	0.3315	0.3288	0.3313	64365640.0
2012-09-04 14:00:00	NVDA	Stock	0.331	0.3361	0.331	0.3348	82844080.0
2012-09-04 15:00:00	NVDA	Stock	0.335	0.335	0.3315	0.3318	143814480.0
2012-09-04 16:00:00	NVDA	Stock	0.332	0.3513	0.3315	0.3318	3190840.0
2012-09-04 17:00:00	NVDA	Stock	0.3318	0.3325	0.3318	0.3325	12000.0
2012-09-04 18:00:00	NVDA	Stock	0.3328	0.3348	0.3328	0.3348	66000.0
2012-09-04 19:00:00	NVDA	Stock	0.3325	0.3345	0.3325	0.3345	28000.0
2012-09-04 07:00:00	AMZN	Stock	12.4385	12.451	12.4385	12.4445	28000.0
2012-09-04 08:00:00	AMZN	Stock	12.44	12.44	12.4	12.4195	97540.0
2012-09-04 09:00:00	AMZN	Stock	12.41	12.55	12.405	12.478	17500160.0
2012-09-04 10:00:00	AMZN	Stock	12.4745	12.4895	12.305	12.3204	16465240.0
2012-09-04 11:00:00	AMZN	Stock	12.318	12.3215	12.2515	12.2925	11436500.0
2012-09-04 12:00:00	AMZN	Stock	12.295	12.3	12.233	12.2955	8171280.0

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

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