PREVIEW / stock_1hour / 2015-09-25

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-09-25.parquet
  size:    1.0 MB
  rows:    48,464
  symbols: 3,460

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-09-25 04:00:00	AAPL	Stock	28.935	29.05	28.935	29.05	57104.0
2015-09-25 05:00:00	AAPL	Stock	29.0275	29.1125	29.0275	29.0975	34628.0
2015-09-25 06:00:00	AAPL	Stock	29.075	29.1025	29.0075	29.05	119432.0
2015-09-25 07:00:00	AAPL	Stock	29.055	29.1225	29.05	29.075	377288.0
2015-09-25 08:00:00	AAPL	Stock	29.1	29.125	29.04	29.0675	1564088.0
2015-09-25 09:00:00	AAPL	Stock	29.0625	29.1725	28.9288	29.02	30677828.0
2015-09-25 10:00:00	AAPL	Stock	29.0225	29.04	28.8125	28.9425	31321308.0
2015-09-25 11:00:00	AAPL	Stock	28.9425	28.9925	28.8	28.8525	19094932.0
2015-09-25 12:00:00	AAPL	Stock	28.8548	28.8832	28.675	28.855	21726664.0
2015-09-25 13:00:00	AAPL	Stock	28.8575	29.004	28.7825	28.8075	19990768.0
2015-09-25 14:00:00	AAPL	Stock	28.81	28.8775	28.57	28.715	29285556.0
2015-09-25 15:00:00	AAPL	Stock	28.715	28.81	28.505	28.6875	44637540.0
2015-09-25 16:00:00	AAPL	Stock	28.6775	28.7025	28.6625	28.6775	10921356.0
2015-09-25 17:00:00	AAPL	Stock	28.6775	28.6875	28.63	28.66	76648.0
2015-09-25 18:00:00	AAPL	Stock	28.66	28.685	28.5	28.645	80004.0
2015-09-25 19:00:00	AAPL	Stock	28.6375	28.69	28.6375	28.68	89096.0
2015-09-25 05:00:00	MSFT	Stock	44.49	44.49	44.49	44.49	100.0
2015-09-25 06:00:00	MSFT	Stock	44.24	44.24	44.24	44.24	700.0
2015-09-25 07:00:00	MSFT	Stock	44.21	44.4	44.21	44.4	400.0
2015-09-25 08:00:00	MSFT	Stock	44.42	44.42	44.32	44.33	6054.0
2015-09-25 09:00:00	MSFT	Stock	44.32	44.73	44.26	44.65	3508839.0
2015-09-25 10:00:00	MSFT	Stock	44.65	44.71	44.48	44.704	3648803.0
2015-09-25 11:00:00	MSFT	Stock	44.7	44.73	44.47	44.584	3022553.0
2015-09-25 12:00:00	MSFT	Stock	44.58	44.58	44.37	44.57	1645489.0
2015-09-25 13:00:00	MSFT	Stock	44.57	44.68	44.288	44.46	2819190.0
2015-09-25 14:00:00	MSFT	Stock	44.46	44.58	43.965	44.08	3448292.0
2015-09-25 15:00:00	MSFT	Stock	44.08	44.135	43.76	43.96	7069806.0
2015-09-25 16:00:00	MSFT	Stock	43.94	44.0	43.92	43.93	2623216.0
2015-09-25 17:00:00	MSFT	Stock	43.93	43.93	43.92	43.92	3823.0
2015-09-25 18:00:00	MSFT	Stock	43.94	43.94	43.94	43.94	250.0
2015-09-25 19:00:00	MSFT	Stock	43.94	43.94	43.84	43.84	2570.0
2015-09-25 08:00:00	NVDA	Stock	0.594	0.594	0.594	0.594	20000.0
2015-09-25 09:00:00	NVDA	Stock	0.593	0.6004	0.5918	0.6001	60746120.0
2015-09-25 10:00:00	NVDA	Stock	0.6	0.6008	0.5923	0.5982	51875520.0
2015-09-25 11:00:00	NVDA	Stock	0.5983	0.6018	0.5973	0.6015	54639800.0
2015-09-25 12:00:00	NVDA	Stock	0.6015	0.6015	0.5958	0.5968	23051680.0
2015-09-25 13:00:00	NVDA	Stock	0.5968	0.6	0.5961	0.5965	20444960.0
2015-09-25 14:00:00	NVDA	Stock	0.5968	0.5988	0.5865	0.5893	56457040.0
2015-09-25 15:00:00	NVDA	Stock	0.5895	0.5919	0.5845	0.5903	67829200.0
2015-09-25 16:00:00	NVDA	Stock	0.5903	0.5908	0.5903	0.5908	22695200.0
2015-09-25 18:00:00	NVDA	Stock	0.591	0.591	0.591	0.591	8000.0
2015-09-25 04:00:00	AMZN	Stock	27.0	27.1	26.995	27.1	27340.0
2015-09-25 05:00:00	AMZN	Stock	27.1	27.1	27.1	27.1	2000.0
2015-09-25 07:00:00	AMZN	Stock	26.968	27.025	26.968	27.025	14820.0
2015-09-25 08:00:00	AMZN	Stock	27.05	27.1	27.046	27.05	305900.0
2015-09-25 09:00:00	AMZN	Stock	27.025	27.14	26.9605	26.9825	10377520.0
2015-09-25 10:00:00	AMZN	Stock	26.982	26.9995	26.817	26.9625	8637360.0
2015-09-25 11:00:00	AMZN	Stock	26.955	26.97	26.801	26.8465	6003120.0
2015-09-25 12:00:00	AMZN	Stock	26.8515	26.95	26.7375	26.7835	4419540.0
2015-09-25 13:00:00	AMZN	Stock	26.794	26.8605	26.7535	26.771	6044500.0

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

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