PREVIEW / stock_1hour / 2015-06-25

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-06-25.parquet
  size:    1.0 MB
  rows:    48,943
  symbols: 3,492

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
2015-06-25 04:00:00	AAPL	Stock	32.105	32.2125	32.105	32.185	20232.0
2015-06-25 05:00:00	AAPL	Stock	32.1675	32.1675	32.135	32.1675	19596.0
2015-06-25 06:00:00	AAPL	Stock	32.155	32.2125	32.155	32.1975	29052.0
2015-06-25 07:00:00	AAPL	Stock	32.2	32.2125	32.15	32.1875	122144.0
2015-06-25 08:00:00	AAPL	Stock	32.1925	32.225	31.95	32.195	570864.0
2015-06-25 09:00:00	AAPL	Stock	32.2	32.3	32.115	32.185	21992892.0
2015-06-25 10:00:00	AAPL	Stock	32.1865	32.2525	32.105	32.185	17390904.0
2015-06-25 11:00:00	AAPL	Stock	32.185	32.235	32.1582	32.1825	10260224.0
2015-06-25 12:00:00	AAPL	Stock	32.1825	32.185	32.0375	32.0575	10812692.0
2015-06-25 13:00:00	AAPL	Stock	32.0625	32.0725	31.985	32.02	10591788.0
2015-06-25 14:00:00	AAPL	Stock	32.0198	32.0198	31.89	31.9175	16083596.0
2015-06-25 15:00:00	AAPL	Stock	31.915	31.9925	31.875	31.8775	19169040.0
2015-06-25 16:00:00	AAPL	Stock	31.8812	32.1995	31.875	31.8925	13550676.0
2015-06-25 17:00:00	AAPL	Stock	31.88	31.8925	31.875	31.885	81536.0
2015-06-25 18:00:00	AAPL	Stock	31.8825	31.912	31.875	31.8825	63752.0
2015-06-25 19:00:00	AAPL	Stock	31.89	31.8992	31.8625	31.875	77356.0
2015-06-25 06:00:00	MSFT	Stock	45.95	46.09	45.92	46.09	5399.0
2015-06-25 07:00:00	MSFT	Stock	46.02	46.02	45.92	45.92	3683.0
2015-06-25 08:00:00	MSFT	Stock	45.93	45.93	45.8	45.84	10152.0
2015-06-25 09:00:00	MSFT	Stock	45.89	46.06	45.69	45.97	2897896.0
2015-06-25 10:00:00	MSFT	Stock	45.97	45.99	45.7	45.91	2800200.0
2015-06-25 11:00:00	MSFT	Stock	45.905	45.97	45.74	45.78	1695143.0
2015-06-25 12:00:00	MSFT	Stock	45.78	45.84	45.63	45.714	1374100.0
2015-06-25 13:00:00	MSFT	Stock	45.71	45.77	45.65	45.745	1308507.0
2015-06-25 14:00:00	MSFT	Stock	45.75	45.755	45.5	45.67	2486620.0
2015-06-25 15:00:00	MSFT	Stock	45.67	45.79	45.64	45.65	5239995.0
2015-06-25 16:00:00	MSFT	Stock	45.66	45.73	45.36	45.4	1872963.0
2015-06-25 17:00:00	MSFT	Stock	45.43	45.47	45.43	45.47	400.0
2015-06-25 18:00:00	MSFT	Stock	45.55	45.6	45.55	45.6	5464.0
2015-06-25 19:00:00	MSFT	Stock	45.56	45.56	45.55	45.55	300.0
2015-06-25 08:00:00	NVDA	Stock	0.522	0.522	0.522	0.522	40000.0
2015-06-25 09:00:00	NVDA	Stock	0.5275	0.5312	0.5253	0.5312	36878680.0
2015-06-25 10:00:00	NVDA	Stock	0.531	0.5325	0.5293	0.5295	29421160.0
2015-06-25 11:00:00	NVDA	Stock	0.5298	0.5318	0.5293	0.5312	26227600.0
2015-06-25 12:00:00	NVDA	Stock	0.5312	0.5315	0.5295	0.5298	20356240.0
2015-06-25 13:00:00	NVDA	Stock	0.5296	0.53	0.5282	0.5287	19007640.0
2015-06-25 14:00:00	NVDA	Stock	0.5285	0.5287	0.5262	0.5281	30209040.0
2015-06-25 15:00:00	NVDA	Stock	0.5281	0.5302	0.528	0.5293	52892160.0
2015-06-25 16:00:00	NVDA	Stock	0.5293	0.53	0.5272	0.5272	112104440.0
2015-06-25 17:00:00	NVDA	Stock	0.525	0.525	0.523	0.525	2048000.0
2015-06-25 19:00:00	NVDA	Stock	0.525	0.525	0.525	0.525	44000.0
2015-06-25 05:00:00	AMZN	Stock	22.1	22.1	21.9315	21.9315	69220.0
2015-06-25 06:00:00	AMZN	Stock	21.867	21.9375	21.867	21.9375	57740.0
2015-06-25 07:00:00	AMZN	Stock	21.9375	21.9375	21.9	21.9	60920.0
2015-06-25 08:00:00	AMZN	Stock	21.906	21.925	21.8625	21.9015	143580.0
2015-06-25 09:00:00	AMZN	Stock	21.8905	21.975	21.8195	21.8875	8542700.0
2015-06-25 10:00:00	AMZN	Stock	21.881	22.1125	21.845	22.1125	8810300.0
2015-06-25 11:00:00	AMZN	Stock	22.1038	22.1735	22.0575	22.1136	4689160.0
2015-06-25 12:00:00	AMZN	Stock	22.1195	22.1278	22.0288	22.0458	2988300.0
2015-06-25 13:00:00	AMZN	Stock	22.0445	22.058	22.003	22.04	3342260.0

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

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