PREVIEW / stock_1hour / 2014-09-16

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-09-16.parquet
  size:    1.0 MB
  rows:    48,571
  symbols: 3,575

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-09-16 04:00:00	AAPL	Stock	25.4625	25.485	25.41	25.41	25384.0
2014-09-16 05:00:00	AAPL	Stock	25.4425	25.4725	25.4425	25.4725	1200.0
2014-09-16 06:00:00	AAPL	Stock	25.4725	25.49	25.3325	25.375	67532.0
2014-09-16 07:00:00	AAPL	Stock	25.38	25.425	25.18	25.2	813048.0
2014-09-16 08:00:00	AAPL	Stock	25.225	25.4612	24.9	25.05	5390876.0
2014-09-16 09:00:00	AAPL	Stock	25.05	25.1325	24.7225	25.0225	58328000.0
2014-09-16 10:00:00	AAPL	Stock	25.0225	25.1	24.89	24.8975	46867500.0
2014-09-16 11:00:00	AAPL	Stock	24.895	25.06	24.8375	25.05	37883560.0
2014-09-16 12:00:00	AAPL	Stock	25.0475	25.0775	25.0125	25.04	20299656.0
2014-09-16 13:00:00	AAPL	Stock	25.0415	25.1375	25.04	25.0675	20554396.0
2014-09-16 14:00:00	AAPL	Stock	25.0658	25.2475	25.065	25.2175	19683824.0
2014-09-16 15:00:00	AAPL	Stock	25.22	25.315	25.2025	25.21	38335580.0
2014-09-16 16:00:00	AAPL	Stock	25.2125	25.2525	24.9532	25.1725	5174180.0
2014-09-16 17:00:00	AAPL	Stock	25.175	25.215	25.0825	25.1	332784.0
2014-09-16 18:00:00	AAPL	Stock	25.125	25.215	25.095	25.1	221132.0
2014-09-16 19:00:00	AAPL	Stock	25.095	25.12	25.095	25.11	127208.0
2014-09-16 07:00:00	MSFT	Stock	46.44	46.45	46.4	46.45	11700.0
2014-09-16 08:00:00	MSFT	Stock	46.4	46.48	46.37	46.38	4150.0
2014-09-16 09:00:00	MSFT	Stock	46.4	46.52	46.29	46.415	4599234.0
2014-09-16 10:00:00	MSFT	Stock	46.415	46.58	46.39	46.575	4491760.0
2014-09-16 11:00:00	MSFT	Stock	46.574	46.76	46.45	46.69	3557590.0
2014-09-16 12:00:00	MSFT	Stock	46.69	46.736	46.53	46.56	2606942.0
2014-09-16 13:00:00	MSFT	Stock	46.57	46.8	46.565	46.77	2164199.0
2014-09-16 14:00:00	MSFT	Stock	46.77	46.83	46.72	46.776	1813487.0
2014-09-16 15:00:00	MSFT	Stock	46.77	46.85	46.75	46.75	4759537.0
2014-09-16 16:00:00	MSFT	Stock	46.76	46.825	46.534	46.766	2517689.0
2014-09-16 17:00:00	MSFT	Stock	46.8	46.8	46.8	46.8	500.0
2014-09-16 18:00:00	MSFT	Stock	46.76	46.85	46.76	46.85	36778.0
2014-09-16 19:00:00	MSFT	Stock	46.83	46.83	46.62	46.65	7875.0
2014-09-16 08:00:00	NVDA	Stock	0.4715	0.4715	0.4715	0.4715	48000.0
2014-09-16 09:00:00	NVDA	Stock	0.471	0.4745	0.4688	0.4732	19790560.0
2014-09-16 10:00:00	NVDA	Stock	0.4732	0.476	0.4725	0.474	30587640.0
2014-09-16 11:00:00	NVDA	Stock	0.474	0.4785	0.4725	0.4778	32614720.0
2014-09-16 12:00:00	NVDA	Stock	0.4778	0.4782	0.4761	0.4765	27184320.0
2014-09-16 13:00:00	NVDA	Stock	0.4768	0.4798	0.4768	0.4798	22847000.0
2014-09-16 14:00:00	NVDA	Stock	0.4798	0.481	0.4778	0.4779	26037960.0
2014-09-16 15:00:00	NVDA	Stock	0.478	0.4798	0.4778	0.4784	46159560.0
2014-09-16 16:00:00	NVDA	Stock	0.4784	0.4785	0.4775	0.4784	8858520.0
2014-09-16 19:00:00	NVDA	Stock	0.4788	0.4788	0.4788	0.4788	4000.0
2014-09-16 08:00:00	AMZN	Stock	16.125	16.125	16.085	16.0895	229600.0
2014-09-16 09:00:00	AMZN	Stock	16.0895	16.2155	16.005	16.1635	11414860.0
2014-09-16 10:00:00	AMZN	Stock	16.1695	16.2925	16.137	16.246	11363020.0
2014-09-16 11:00:00	AMZN	Stock	16.2385	16.3455	16.169	16.3375	7305700.0
2014-09-16 12:00:00	AMZN	Stock	16.3358	16.384	16.2891	16.362	4061140.0
2014-09-16 13:00:00	AMZN	Stock	16.3615	16.4545	16.3602	16.4255	4763480.0
2014-09-16 14:00:00	AMZN	Stock	16.428	16.474	16.4085	16.433	7086040.0
2014-09-16 15:00:00	AMZN	Stock	16.4331	16.4725	16.3835	16.385	10641780.0
2014-09-16 16:00:00	AMZN	Stock	16.388	16.3913	16.3001	16.39	2022080.0
2014-09-16 17:00:00	AMZN	Stock	16.3755	16.376	16.3755	16.376	19800.0
2014-09-16 18:00:00	AMZN	Stock	16.388	16.39	16.301	16.319	69600.0

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

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