PREVIEW / stock_1hour / 2013-07-03

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-07-03.parquet
  size:    664 KB
  rows:    28,647
  symbols: 3,403

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
2013-07-03 04:00:00	AAPL	Stock	14.9107	14.9107	14.8286	14.8407	25200.0
2013-07-03 05:00:00	AAPL	Stock	14.8839	14.8839	14.8839	14.8839	2800.0
2013-07-03 06:00:00	AAPL	Stock	14.8564	14.8571	14.8564	14.8571	16800.0
2013-07-03 07:00:00	AAPL	Stock	14.8571	14.8839	14.8561	14.8825	146664.0
2013-07-03 08:00:00	AAPL	Stock	14.8854	15.0286	14.8393	15.0143	3898552.0
2013-07-03 09:00:00	AAPL	Stock	15.0129	15.1064	14.9093	14.9629	80846276.0
2013-07-03 10:00:00	AAPL	Stock	14.9639	15.0168	14.9089	14.9767	53909296.0
2013-07-03 11:00:00	AAPL	Stock	14.978	15.0804	14.9468	15.0761	42939148.0
2013-07-03 12:00:00	AAPL	Stock	15.0729	15.0993	15.0	15.0271	53612832.0
2013-07-03 13:00:00	AAPL	Stock	15.0271	15.0482	14.9758	15.0482	3772860.0
2013-07-03 14:00:00	AAPL	Stock	15.0286	15.05	15.0286	15.0364	203364.0
2013-07-03 15:00:00	AAPL	Stock	15.0464	15.0464	15.0304	15.0439	94696.0
2013-07-03 16:00:00	AAPL	Stock	15.0536	15.0679	15.0361	15.0361	20748.0
2013-07-03 04:00:00	MSFT	Stock	33.89	33.89	33.89	33.89	190.0
2013-07-03 05:00:00	MSFT	Stock	33.65	33.65	33.64	33.64	774.0
2013-07-03 06:00:00	MSFT	Stock	33.62	33.66	33.62	33.66	813.0
2013-07-03 07:00:00	MSFT	Stock	33.66	33.68	33.66	33.66	1367.0
2013-07-03 08:00:00	MSFT	Stock	33.76	33.89	33.67	33.85	8307.0
2013-07-03 09:00:00	MSFT	Stock	33.85	33.96	33.54	33.875	2975738.0
2013-07-03 10:00:00	MSFT	Stock	33.877	34.09	33.77	34.015	4246357.0
2013-07-03 11:00:00	MSFT	Stock	34.02	34.2	33.96	34.2	3173256.0
2013-07-03 12:00:00	MSFT	Stock	34.2	34.37	34.0	34.0	4434229.0
2013-07-03 13:00:00	MSFT	Stock	34.0	34.18	34.0	34.0	716770.0
2013-07-03 14:00:00	MSFT	Stock	33.98	34.01	33.95	34.01	55090.0
2013-07-03 15:00:00	MSFT	Stock	34.01	34.05	34.01	34.05	345.0
2013-07-03 16:00:00	MSFT	Stock	34.01	34.13	34.01	34.13	1000.0
2013-07-03 09:00:00	NVDA	Stock	0.349	0.3558	0.349	0.3553	33474120.0
2013-07-03 10:00:00	NVDA	Stock	0.3553	0.3575	0.3545	0.356	38979520.0
2013-07-03 11:00:00	NVDA	Stock	0.3558	0.3565	0.3548	0.3565	29691320.0
2013-07-03 12:00:00	NVDA	Stock	0.3565	0.3569	0.3533	0.3534	30062520.0
2013-07-03 13:00:00	NVDA	Stock	0.3533	0.3546	0.3533	0.3533	6529520.0
2013-07-03 14:00:00	NVDA	Stock	0.3533	0.3533	0.3533	0.3533	439320.0
2013-07-03 15:00:00	NVDA	Stock	0.3533	0.3533	0.3533	0.3533	8000.0
2013-07-03 05:00:00	AMZN	Stock	14.001	14.1085	13.9	14.05	61400.0
2013-07-03 07:00:00	AMZN	Stock	14.0725	14.0725	14.0725	14.0725	4000.0
2013-07-03 08:00:00	AMZN	Stock	14.1225	14.1395	14.0935	14.1175	116000.0
2013-07-03 09:00:00	AMZN	Stock	14.1175	14.2485	14.1	14.1766	9032480.0
2013-07-03 10:00:00	AMZN	Stock	14.1825	14.2425	14.143	14.225	6281300.0
2013-07-03 11:00:00	AMZN	Stock	14.2275	14.254	14.183	14.2535	4250200.0
2013-07-03 12:00:00	AMZN	Stock	14.2505	14.27	14.193	14.1945	6452000.0
2013-07-03 13:00:00	AMZN	Stock	14.194	14.2375	14.194	14.2375	1203900.0
2013-07-03 14:00:00	AMZN	Stock	14.2015	14.25	14.2015	14.25	126820.0
2013-07-03 15:00:00	AMZN	Stock	14.2155	14.2155	14.2155	14.2155	5000.0
2013-07-03 04:00:00	META	Stock	24.16	24.17	24.16	24.17	2000.0
2013-07-03 05:00:00	META	Stock	24.16	24.16	24.16	24.16	100.0
2013-07-03 06:00:00	META	Stock	24.15	24.18	24.15	24.18	2700.0
2013-07-03 07:00:00	META	Stock	24.14	24.14	24.1	24.11	15807.0
2013-07-03 08:00:00	META	Stock	24.14	24.34	24.1	24.29	71417.0
2013-07-03 09:00:00	META	Stock	24.29	24.442	24.15	24.37	2457910.0
2013-07-03 10:00:00	META	Stock	24.37	24.67	24.32	24.65	2948733.0

> showing 50 of 28,647 rows — these rows as CSV

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