PREVIEW / stock_1hour / 2015-09-14

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-09-14.parquet
  size:    1022 KB
  rows:    47,762
  symbols: 3,435

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-14 04:00:00	AAPL	Stock	28.5725	28.75	28.5725	28.6625	27228.0
2015-09-14 05:00:00	AAPL	Stock	28.675	28.7125	28.6625	28.6875	13440.0
2015-09-14 06:00:00	AAPL	Stock	28.685	28.8475	28.685	28.8425	328712.0
2015-09-14 07:00:00	AAPL	Stock	28.83	29.03	28.825	28.9375	955420.0
2015-09-14 08:00:00	AAPL	Stock	28.9325	29.2675	28.6875	29.2025	5290948.0
2015-09-14 09:00:00	AAPL	Stock	29.2075	29.3125	28.915	28.9838	52378480.0
2015-09-14 10:00:00	AAPL	Stock	28.975	29.14	28.8425	28.9425	41950428.0
2015-09-14 11:00:00	AAPL	Stock	28.945	29.005	28.8275	28.865	22342928.0
2015-09-14 12:00:00	AAPL	Stock	28.865	28.9025	28.715	28.7722	23681340.0
2015-09-14 13:00:00	AAPL	Stock	28.77	28.945	28.7425	28.9312	16645144.0
2015-09-14 14:00:00	AAPL	Stock	28.9312	28.9525	28.8278	28.8612	17003768.0
2015-09-14 15:00:00	AAPL	Stock	28.8612	28.935	28.765	28.8345	29878024.0
2015-09-14 16:00:00	AAPL	Stock	28.825	28.8688	28.8	28.8125	7440252.0
2015-09-14 17:00:00	AAPL	Stock	28.825	28.845	28.8125	28.8275	200808.0
2015-09-14 18:00:00	AAPL	Stock	28.815	28.8275	28.795	28.815	98304.0
2015-09-14 19:00:00	AAPL	Stock	28.815	28.8325	28.8025	28.83	103768.0
2015-09-14 07:00:00	MSFT	Stock	43.5	43.5	43.5	43.5	5900.0
2015-09-14 08:00:00	MSFT	Stock	43.4	43.5	43.21	43.4	1770.0
2015-09-14 09:00:00	MSFT	Stock	43.35	43.5	42.86	42.91	2244057.0
2015-09-14 10:00:00	MSFT	Stock	42.911	43.13	42.89	43.05	2604923.0
2015-09-14 11:00:00	MSFT	Stock	43.05	43.12	42.875	42.945	2115609.0
2015-09-14 12:00:00	MSFT	Stock	42.95	43.05	42.88	42.975	1996735.0
2015-09-14 13:00:00	MSFT	Stock	42.97	43.09	42.92	43.07	2013704.0
2015-09-14 14:00:00	MSFT	Stock	43.07	43.096	42.9	43.04	3217889.0
2015-09-14 15:00:00	MSFT	Stock	43.03	43.07	42.91	43.03	5041504.0
2015-09-14 16:00:00	MSFT	Stock	43.04	43.08	42.933	43.01	3461577.0
2015-09-14 18:00:00	MSFT	Stock	43.01	43.01	43.01	43.01	1500.0
2015-09-14 08:00:00	NVDA	Stock	0.572	0.5725	0.5678	0.5678	28000.0
2015-09-14 09:00:00	NVDA	Stock	0.569	0.5708	0.5645	0.5648	15180760.0
2015-09-14 10:00:00	NVDA	Stock	0.565	0.5702	0.5649	0.569	31255720.0
2015-09-14 11:00:00	NVDA	Stock	0.569	0.5698	0.5652	0.5664	29298120.0
2015-09-14 12:00:00	NVDA	Stock	0.5662	0.5672	0.5642	0.566	21494800.0
2015-09-14 13:00:00	NVDA	Stock	0.566	0.5688	0.5652	0.567	17559720.0
2015-09-14 14:00:00	NVDA	Stock	0.567	0.5675	0.5658	0.5669	20569640.0
2015-09-14 15:00:00	NVDA	Stock	0.5668	0.5678	0.565	0.5672	30836120.0
2015-09-14 16:00:00	NVDA	Stock	0.5672	0.5672	0.5656	0.5662	11393440.0
2015-09-14 07:00:00	AMZN	Stock	26.5135	26.5135	26.4565	26.4565	45900.0
2015-09-14 08:00:00	AMZN	Stock	26.451	26.4745	26.415	26.474	161560.0
2015-09-14 09:00:00	AMZN	Stock	26.4625	26.6225	26.181	26.238	9866000.0
2015-09-14 10:00:00	AMZN	Stock	26.2255	26.3248	26.106	26.14	7778380.0
2015-09-14 11:00:00	AMZN	Stock	26.143	26.161	25.929	26.03	9897080.0
2015-09-14 12:00:00	AMZN	Stock	26.0105	26.1135	26.0	26.05	4484320.0
2015-09-14 13:00:00	AMZN	Stock	26.047	26.099	25.9375	26.0902	8555820.0
2015-09-14 14:00:00	AMZN	Stock	26.0915	26.1085	26.015	26.0552	5541320.0
2015-09-14 15:00:00	AMZN	Stock	26.0522	26.1045	25.9765	26.0585	9494920.0
2015-09-14 16:00:00	AMZN	Stock	26.069	26.069	26.025	26.0495	97780.0
2015-09-14 17:00:00	AMZN	Stock	26.0655	26.0655	26.0655	26.0655	3560.0
2015-09-14 18:00:00	AMZN	Stock	26.0575	26.075	26.0575	26.075	6000.0
2015-09-14 07:00:00	GOOGL	Stock	32.828	32.828	32.828	32.828	2000.0
2015-09-14 08:00:00	GOOGL	Stock	32.8145	32.8145	32.72	32.7775	87520.0

> showing 50 of 47,762 rows — these rows as CSV

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