PREVIEW / stock_1hour / 2014-08-20

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-08-20.parquet
  size:    1.0 MB
  rows:    48,066
  symbols: 3,569

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
2014-08-20 04:00:00	AAPL	Stock	25.1075	25.245	25.1075	25.2	84688.0
2014-08-20 05:00:00	AAPL	Stock	25.2025	25.245	25.2	25.21	70988.0
2014-08-20 06:00:00	AAPL	Stock	25.215	25.2375	25.1975	25.2175	113160.0
2014-08-20 07:00:00	AAPL	Stock	25.2075	25.2075	25.1575	25.1775	322768.0
2014-08-20 08:00:00	AAPL	Stock	25.1875	25.22	25.0625	25.085	1116172.0
2014-08-20 09:00:00	AAPL	Stock	25.08	25.1925	25.0625	25.11	33083208.0
2014-08-20 10:00:00	AAPL	Stock	25.1125	25.1175	24.9875	25.1	37740428.0
2014-08-20 11:00:00	AAPL	Stock	25.0988	25.2175	25.08	25.1975	26646168.0
2014-08-20 12:00:00	AAPL	Stock	25.1975	25.2225	25.1475	25.22	16823952.0
2014-08-20 13:00:00	AAPL	Stock	25.2175	25.2725	25.1905	25.2275	19582788.0
2014-08-20 14:00:00	AAPL	Stock	25.23	25.235	25.17	25.215	21259464.0
2014-08-20 15:00:00	AAPL	Stock	25.2175	25.2475	25.1375	25.1425	31924208.0
2014-08-20 16:00:00	AAPL	Stock	25.1425	25.215	25.0758	25.0975	10281100.0
2014-08-20 17:00:00	AAPL	Stock	25.1	25.211	25.095	25.1	288432.0
2014-08-20 18:00:00	AAPL	Stock	25.1025	25.105	25.0925	25.1	135344.0
2014-08-20 19:00:00	AAPL	Stock	25.0975	25.1425	25.085	25.12	279940.0
2014-08-20 06:00:00	MSFT	Stock	45.37	45.37	45.37	45.37	300.0
2014-08-20 07:00:00	MSFT	Stock	45.37	45.4	45.3	45.3	5900.0
2014-08-20 08:00:00	MSFT	Stock	45.4	45.4	45.23	45.23	6577.0
2014-08-20 09:00:00	MSFT	Stock	45.3	45.4	45.08	45.115	2826980.0
2014-08-20 10:00:00	MSFT	Stock	45.12	45.17	45.02	45.15	3314041.0
2014-08-20 11:00:00	MSFT	Stock	45.145	45.25	45.015	45.11	2905764.0
2014-08-20 12:00:00	MSFT	Stock	45.11	45.15	45.03	45.07	1373947.0
2014-08-20 13:00:00	MSFT	Stock	45.075	45.08	44.95	45.0	3093116.0
2014-08-20 14:00:00	MSFT	Stock	44.995	45.04	44.9	45.001	3697760.0
2014-08-20 15:00:00	MSFT	Stock	45.005	45.015	44.91	44.94	4195463.0
2014-08-20 16:00:00	MSFT	Stock	44.95	45.086	44.93	44.955	1211355.0
2014-08-20 17:00:00	MSFT	Stock	44.987	44.987	44.92	44.92	5068.0
2014-08-20 18:00:00	MSFT	Stock	44.93	44.93	44.92	44.93	2472.0
2014-08-20 19:00:00	MSFT	Stock	44.93	44.95	44.93	44.93	19307.0
2014-08-20 09:00:00	NVDA	Stock	0.4825	0.4848	0.4815	0.4825	30135080.0
2014-08-20 10:00:00	NVDA	Stock	0.4828	0.4843	0.4822	0.4832	31543000.0
2014-08-20 11:00:00	NVDA	Stock	0.4832	0.4832	0.481	0.4815	21810400.0
2014-08-20 12:00:00	NVDA	Stock	0.4818	0.4825	0.4808	0.482	18467120.0
2014-08-20 13:00:00	NVDA	Stock	0.482	0.4826	0.4808	0.4808	15719000.0
2014-08-20 14:00:00	NVDA	Stock	0.4808	0.4822	0.4801	0.4818	29604560.0
2014-08-20 15:00:00	NVDA	Stock	0.4818	0.4822	0.4803	0.4812	51321800.0
2014-08-20 16:00:00	NVDA	Stock	0.4812	0.4821	0.4812	0.4814	14980520.0
2014-08-20 07:00:00	AMZN	Stock	16.7655	16.766	16.765	16.766	25960.0
2014-08-20 08:00:00	AMZN	Stock	16.766	16.777	16.7565	16.772	205420.0
2014-08-20 09:00:00	AMZN	Stock	16.753	16.858	16.7011	16.8265	6348560.0
2014-08-20 10:00:00	AMZN	Stock	16.825	16.8325	16.7585	16.7925	5975500.0
2014-08-20 11:00:00	AMZN	Stock	16.7925	16.839	16.77	16.824	3132760.0
2014-08-20 12:00:00	AMZN	Stock	16.8255	16.83	16.7725	16.777	2853080.0
2014-08-20 13:00:00	AMZN	Stock	16.7854	16.8202	16.766	16.775	2505380.0
2014-08-20 14:00:00	AMZN	Stock	16.7755	16.7965	16.735	16.781	4736700.0
2014-08-20 15:00:00	AMZN	Stock	16.7875	16.8245	16.7815	16.789	5884980.0
2014-08-20 16:00:00	AMZN	Stock	16.789	16.809	16.7795	16.7924	752060.0
2014-08-20 17:00:00	AMZN	Stock	16.8	16.8045	16.8	16.8045	14200.0
2014-08-20 18:00:00	AMZN	Stock	16.79	16.8	16.79	16.8	4000.0

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

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