PREVIEW / stock_1hour / 2015-08-10

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-08-10.parquet
  size:    1.0 MB
  rows:    48,560
  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
2015-08-10 04:00:00	AAPL	Stock	28.9175	28.9725	28.9175	28.97	26808.0
2015-08-10 05:00:00	AAPL	Stock	28.97	29.02	28.9425	29.02	49896.0
2015-08-10 06:00:00	AAPL	Stock	29.0225	29.095	29.0025	29.025	27732.0
2015-08-10 07:00:00	AAPL	Stock	29.035	29.1	29.015	29.0525	225760.0
2015-08-10 08:00:00	AAPL	Stock	29.0625	29.21	29.0325	29.1458	1147296.0
2015-08-10 09:00:00	AAPL	Stock	29.155	29.4625	29.1325	29.35	34403620.0
2015-08-10 10:00:00	AAPL	Stock	29.3525	29.685	29.35	29.5988	40550668.0
2015-08-10 11:00:00	AAPL	Stock	29.6025	29.8025	29.5525	29.759	26526332.0
2015-08-10 12:00:00	AAPL	Stock	29.757	29.86	29.7225	29.855	23465904.0
2015-08-10 13:00:00	AAPL	Stock	29.8552	29.9375	29.8225	29.9062	18163472.0
2015-08-10 14:00:00	AAPL	Stock	29.9075	29.9975	29.8775	29.938	24364360.0
2015-08-10 15:00:00	AAPL	Stock	29.9375	29.9575	29.8875	29.93	28832296.0
2015-08-10 16:00:00	AAPL	Stock	29.93	29.94	29.7225	29.8875	8132068.0
2015-08-10 17:00:00	AAPL	Stock	29.8825	29.93	29.855	29.875	169596.0
2015-08-10 18:00:00	AAPL	Stock	29.875	29.925	29.875	29.9	147512.0
2015-08-10 19:00:00	AAPL	Stock	29.91	29.925	29.9025	29.9225	114460.0
2015-08-10 08:00:00	MSFT	Stock	46.8	47.13	46.8	47.1	42453.0
2015-08-10 09:00:00	MSFT	Stock	47.08	47.32	46.84	47.189	2532054.0
2015-08-10 10:00:00	MSFT	Stock	47.18	47.49	47.18	47.39	2933186.0
2015-08-10 11:00:00	MSFT	Stock	47.395	47.48	47.25	47.33	3192735.0
2015-08-10 12:00:00	MSFT	Stock	47.33	47.365	47.25	47.29	1813647.0
2015-08-10 13:00:00	MSFT	Stock	47.29	47.3	47.25	47.28	1437398.0
2015-08-10 14:00:00	MSFT	Stock	47.285	47.42	47.26	47.33	2339412.0
2015-08-10 15:00:00	MSFT	Stock	47.33	47.38	47.225	47.33	4177592.0
2015-08-10 16:00:00	MSFT	Stock	47.33	47.345	47.213	47.3	3252357.0
2015-08-10 17:00:00	MSFT	Stock	47.34	47.44	47.33	47.37	10986.0
2015-08-10 18:00:00	MSFT	Stock	47.42	47.42	47.36	47.36	660.0
2015-08-10 19:00:00	MSFT	Stock	47.38	47.4	47.36	47.36	1608.0
2015-08-10 04:00:00	NVDA	Stock	0.573	0.573	0.573	0.573	12000.0
2015-08-10 05:00:00	NVDA	Stock	0.5738	0.5738	0.5738	0.5738	4000.0
2015-08-10 08:00:00	NVDA	Stock	0.5758	0.5822	0.575	0.5788	128000.0
2015-08-10 09:00:00	NVDA	Stock	0.5788	0.5788	0.567	0.5745	89407720.0
2015-08-10 10:00:00	NVDA	Stock	0.5745	0.586	0.5745	0.586	124674040.0
2015-08-10 11:00:00	NVDA	Stock	0.5858	0.5923	0.5853	0.5918	107137520.0
2015-08-10 12:00:00	NVDA	Stock	0.5918	0.5988	0.5912	0.5956	84714320.0
2015-08-10 13:00:00	NVDA	Stock	0.5955	0.598	0.5925	0.5945	65856840.0
2015-08-10 14:00:00	NVDA	Stock	0.5946	0.597	0.5923	0.593	45991720.0
2015-08-10 15:00:00	NVDA	Stock	0.5931	0.5952	0.5923	0.5945	111376280.0
2015-08-10 16:00:00	NVDA	Stock	0.5945	0.5945	0.593	0.593	684120.0
2015-08-10 17:00:00	NVDA	Stock	0.5936	0.595	0.5936	0.595	129120.0
2015-08-10 19:00:00	NVDA	Stock	0.5945	0.595	0.5945	0.595	48000.0
2015-08-10 05:00:00	AMZN	Stock	26.153	26.23	26.153	26.23	10280.0
2015-08-10 06:00:00	AMZN	Stock	26.23	26.23	26.23	26.23	2120.0
2015-08-10 08:00:00	AMZN	Stock	26.2998	26.35	26.269	26.3345	104300.0
2015-08-10 09:00:00	AMZN	Stock	26.349	26.6138	26.3345	26.439	12754340.0
2015-08-10 10:00:00	AMZN	Stock	26.4405	26.455	26.201	26.2635	6107520.0
2015-08-10 11:00:00	AMZN	Stock	26.274	26.441	26.15	26.353	6580780.0
2015-08-10 12:00:00	AMZN	Stock	26.3675	26.4015	26.2545	26.2635	2990060.0
2015-08-10 13:00:00	AMZN	Stock	26.2653	26.3345	26.2525	26.3225	3119000.0
2015-08-10 14:00:00	AMZN	Stock	26.334	26.3425	26.2318	26.255	4856480.0

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

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