PREVIEW / stock_1hour / 2013-03-21

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-03-21.parquet
  size:    961 KB
  rows:    44,870
  symbols: 3,462

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
2013-03-21 04:00:00	AAPL	Stock	16.0707	16.0707	16.0593	16.0593	7000.0
2013-03-21 05:00:00	AAPL	Stock	16.0718	16.0718	16.0718	16.0718	2800.0
2013-03-21 06:00:00	AAPL	Stock	16.0893	16.0893	16.0893	16.0893	8400.0
2013-03-21 07:00:00	AAPL	Stock	16.0729	16.1607	16.0729	16.15	347368.0
2013-03-21 08:00:00	AAPL	Stock	16.1429	16.1536	16.0929	16.1036	787948.0
2013-03-21 09:00:00	AAPL	Stock	16.0989	16.23	16.0714	16.1421	56777784.0
2013-03-21 10:00:00	AAPL	Stock	16.1475	16.1918	16.1029	16.1596	44350936.0
2013-03-21 11:00:00	AAPL	Stock	16.1604	16.1886	16.1357	16.1736	34473600.0
2013-03-21 12:00:00	AAPL	Stock	16.1739	16.3393	16.1361	16.3068	68360236.0
2013-03-21 13:00:00	AAPL	Stock	16.3071	16.3564	16.2593	16.2982	59571652.0
2013-03-21 14:00:00	AAPL	Stock	16.2939	16.2957	16.2082	16.2464	44414552.0
2013-03-21 15:00:00	AAPL	Stock	16.2489	16.2836	16.1247	16.1707	53025112.0
2013-03-21 16:00:00	AAPL	Stock	16.1689	16.301	16.1597	16.1786	10170104.0
2013-03-21 17:00:00	AAPL	Stock	16.1786	16.1936	16.1689	16.1864	222180.0
2013-03-21 18:00:00	AAPL	Stock	16.1857	16.301	16.1804	16.1825	1113840.0
2013-03-21 19:00:00	AAPL	Stock	16.1825	16.1896	16.1825	16.1896	165704.0
2013-03-21 06:00:00	MSFT	Stock	28.2	28.2	28.2	28.2	2000.0
2013-03-21 07:00:00	MSFT	Stock	28.18	28.18	28.18	28.18	2000.0
2013-03-21 08:00:00	MSFT	Stock	28.18	28.26	28.15	28.15	8038.0
2013-03-21 09:00:00	MSFT	Stock	28.15	28.36	28.06	28.36	3870221.0
2013-03-21 10:00:00	MSFT	Stock	28.35	28.36	28.11	28.17	5047309.0
2013-03-21 11:00:00	MSFT	Stock	28.17	28.22	28.13	28.18	3257883.0
2013-03-21 12:00:00	MSFT	Stock	28.182	28.19	28.11	28.15	2906845.0
2013-03-21 13:00:00	MSFT	Stock	28.14	28.15	28.07	28.095	4221017.0
2013-03-21 14:00:00	MSFT	Stock	28.09	28.15	28.05	28.105	4264487.0
2013-03-21 15:00:00	MSFT	Stock	28.11	28.19	28.1	28.11	6253667.0
2013-03-21 16:00:00	MSFT	Stock	28.11	28.532	28.09	28.13	4076552.0
2013-03-21 17:00:00	MSFT	Stock	28.11	28.11	28.09	28.09	19353.0
2013-03-21 18:00:00	MSFT	Stock	28.09	28.12	28.09	28.12	400.0
2013-03-21 19:00:00	MSFT	Stock	28.11	28.11	28.11	28.11	1105.0
2013-03-21 09:00:00	NVDA	Stock	0.3133	0.3143	0.3115	0.3125	22740960.0
2013-03-21 10:00:00	NVDA	Stock	0.3128	0.3136	0.31	0.3103	81457280.0
2013-03-21 11:00:00	NVDA	Stock	0.3104	0.3138	0.31	0.3125	57536360.0
2013-03-21 12:00:00	NVDA	Stock	0.3125	0.313	0.311	0.3125	23962280.0
2013-03-21 13:00:00	NVDA	Stock	0.3125	0.3128	0.3109	0.3113	34240120.0
2013-03-21 14:00:00	NVDA	Stock	0.3111	0.3118	0.3104	0.3108	40128160.0
2013-03-21 15:00:00	NVDA	Stock	0.3108	0.3115	0.3105	0.3105	61175640.0
2013-03-21 16:00:00	NVDA	Stock	0.3105	0.3113	0.31	0.3105	4331720.0
2013-03-21 17:00:00	NVDA	Stock	0.3105	0.3105	0.3105	0.3105	408520.0
2013-03-21 18:00:00	NVDA	Stock	0.31	0.31	0.31	0.31	8000.0
2013-03-21 05:00:00	AMZN	Stock	12.8455	12.8455	12.8455	12.8455	2000.0
2013-03-21 09:00:00	AMZN	Stock	12.8245	12.85	12.764	12.7912	6144640.0
2013-03-21 10:00:00	AMZN	Stock	12.795	12.823	12.743	12.754	8571400.0
2013-03-21 11:00:00	AMZN	Stock	12.757	12.7865	12.723	12.776	6348220.0
2013-03-21 12:00:00	AMZN	Stock	12.7775	12.8125	12.7665	12.767	4784920.0
2013-03-21 13:00:00	AMZN	Stock	12.7665	12.779	12.6715	12.7025	6374840.0
2013-03-21 14:00:00	AMZN	Stock	12.6985	12.7185	12.634	12.7155	5810200.0
2013-03-21 15:00:00	AMZN	Stock	12.7135	12.716	12.6435	12.667	10077940.0
2013-03-21 16:00:00	AMZN	Stock	12.6695	12.8782	12.661	12.687	6124000.0
2013-03-21 17:00:00	AMZN	Stock	12.6695	12.6755	12.6695	12.6695	109520.0

> showing 50 of 44,870 rows — these rows as CSV

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