PREVIEW / stock_1hour / 2013-09-30

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-09-30.parquet
  size:    1.0 MB
  rows:    48,318
  symbols: 3,548

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-09-30 04:00:00	AAPL	Stock	17.1532	17.1532	17.0039	17.0446	222292.0
2013-09-30 05:00:00	AAPL	Stock	17.0539	17.0714	17.0539	17.0714	16800.0
2013-09-30 06:00:00	AAPL	Stock	17.0543	17.0786	17.0539	17.0593	261436.0
2013-09-30 07:00:00	AAPL	Stock	17.0607	17.1204	17.0482	17.0893	1116136.0
2013-09-30 08:00:00	AAPL	Stock	17.0893	17.155	17.0393	17.0929	1778980.0
2013-09-30 09:00:00	AAPL	Stock	17.0904	17.3214	16.9432	17.0982	55700932.0
2013-09-30 10:00:00	AAPL	Stock	17.0915	17.2021	17.0357	17.1471	44746688.0
2013-09-30 11:00:00	AAPL	Stock	17.148	17.1529	17.0761	17.1279	18849068.0
2013-09-30 12:00:00	AAPL	Stock	17.1272	17.1529	17.0905	17.1269	12487160.0
2013-09-30 13:00:00	AAPL	Stock	17.1261	17.1429	17.0682	17.0779	17175676.0
2013-09-30 14:00:00	AAPL	Stock	17.0804	17.1021	17.06	17.0605	15779260.0
2013-09-30 15:00:00	AAPL	Stock	17.0604	17.0639	16.9861	17.0268	54421556.0
2013-09-30 16:00:00	AAPL	Stock	17.0293	17.0647	17.0036	17.0132	28338884.0
2013-09-30 17:00:00	AAPL	Stock	17.0146	17.0268	17.0004	17.0196	566356.0
2013-09-30 18:00:00	AAPL	Stock	17.0179	17.0357	17.0118	17.0314	432712.0
2013-09-30 19:00:00	AAPL	Stock	17.0286	17.0368	17.0146	17.0214	313404.0
2013-09-30 04:00:00	MSFT	Stock	33.29	33.29	33.29	33.29	100.0
2013-09-30 06:00:00	MSFT	Stock	32.98	32.98	32.98	32.98	1000.0
2013-09-30 07:00:00	MSFT	Stock	32.95	33.06	32.88	33.0	3300.0
2013-09-30 08:00:00	MSFT	Stock	33.01	33.14	32.86	32.97	18271.0
2013-09-30 09:00:00	MSFT	Stock	32.98	33.02	32.7	32.74	5531038.0
2013-09-30 10:00:00	MSFT	Stock	32.733	32.96	32.733	32.885	4704804.0
2013-09-30 11:00:00	MSFT	Stock	32.88	33.11	32.85	33.11	3518158.0
2013-09-30 12:00:00	MSFT	Stock	33.108	33.11	32.958	33.0	2318026.0
2013-09-30 13:00:00	MSFT	Stock	33.01	33.15	33.01	33.1	2918209.0
2013-09-30 14:00:00	MSFT	Stock	33.105	33.2	33.07	33.185	2762027.0
2013-09-30 15:00:00	MSFT	Stock	33.18	33.31	33.04	33.31	9655515.0
2013-09-30 16:00:00	MSFT	Stock	33.31	33.33	32.825	33.28	6403473.0
2013-09-30 17:00:00	MSFT	Stock	33.31	33.31	33.157	33.31	69398.0
2013-09-30 18:00:00	MSFT	Stock	33.31	33.33	33.28	33.33	533.0
2013-09-30 19:00:00	MSFT	Stock	33.34	33.34	33.28	33.3	900.0
2013-09-30 08:00:00	NVDA	Stock	0.3828	0.3828	0.3828	0.3828	44000.0
2013-09-30 09:00:00	NVDA	Stock	0.3855	0.3884	0.3833	0.3878	25311960.0
2013-09-30 10:00:00	NVDA	Stock	0.3878	0.3893	0.3864	0.3888	27044960.0
2013-09-30 11:00:00	NVDA	Stock	0.3885	0.3905	0.3882	0.3905	24872000.0
2013-09-30 12:00:00	NVDA	Stock	0.3905	0.3915	0.3901	0.3905	14853280.0
2013-09-30 13:00:00	NVDA	Stock	0.3908	0.3918	0.3888	0.3893	25917080.0
2013-09-30 14:00:00	NVDA	Stock	0.3895	0.39	0.3891	0.3893	24981280.0
2013-09-30 15:00:00	NVDA	Stock	0.3893	0.3894	0.3878	0.389	54318440.0
2013-09-30 16:00:00	NVDA	Stock	0.389	0.3901	0.3882	0.3882	28498520.0
2013-09-30 17:00:00	NVDA	Stock	0.389	0.389	0.389	0.389	190840.0
2013-09-30 18:00:00	NVDA	Stock	0.3882	0.3882	0.3875	0.3875	47400.0
2013-09-30 05:00:00	AMZN	Stock	15.6785	15.7135	15.6595	15.666	8000.0
2013-09-30 07:00:00	AMZN	Stock	15.6775	15.6775	15.5555	15.63	43660.0
2013-09-30 08:00:00	AMZN	Stock	15.7005	15.775	15.6	15.6025	67160.0
2013-09-30 09:00:00	AMZN	Stock	15.622	15.6825	15.553	15.6065	4418100.0
2013-09-30 10:00:00	AMZN	Stock	15.614	15.7655	15.6	15.7222	5195020.0
2013-09-30 11:00:00	AMZN	Stock	15.7095	15.747	15.6505	15.717	2353880.0
2013-09-30 12:00:00	AMZN	Stock	15.722	15.722	15.6505	15.6581	1727920.0
2013-09-30 13:00:00	AMZN	Stock	15.6625	15.7199	15.6455	15.6595	2366640.0

> showing 50 of 48,318 rows — these rows as CSV

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