PREVIEW / stock_1hour / 2013-09-10

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-09-10.parquet
  size:    1.0 MB
  rows:    48,199
  symbols: 3,533

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-09-10 04:00:00	AAPL	Stock	18.0714	18.1929	18.0714	18.1929	149464.0
2013-09-10 05:00:00	AAPL	Stock	18.1714	18.1714	18.1304	18.1304	190820.0
2013-09-10 06:00:00	AAPL	Stock	18.1368	18.1732	18.1368	18.1607	169568.0
2013-09-10 07:00:00	AAPL	Stock	18.1468	18.1929	18.125	18.1804	1273104.0
2013-09-10 08:00:00	AAPL	Stock	18.1804	18.1943	18.0932	18.1214	4109000.0
2013-09-10 09:00:00	AAPL	Stock	18.13	18.13	17.8858	17.9234	77449876.0
2013-09-10 10:00:00	AAPL	Stock	17.9225	18.0036	17.9204	17.9661	42574560.0
2013-09-10 11:00:00	AAPL	Stock	17.9711	18.0214	17.9464	18.0086	27944868.0
2013-09-10 12:00:00	AAPL	Stock	18.0114	18.0161	17.815	17.9414	53025476.0
2013-09-10 13:00:00	AAPL	Stock	17.9407	18.1232	17.8618	17.9756	145511240.0
2013-09-10 14:00:00	AAPL	Stock	17.9721	18.0664	17.4821	17.7039	232546468.0
2013-09-10 15:00:00	AAPL	Stock	17.7029	17.8164	17.5671	17.6634	136645964.0
2013-09-10 16:00:00	AAPL	Stock	17.6661	17.9722	17.6114	17.6146	11939676.0
2013-09-10 17:00:00	AAPL	Stock	17.6211	17.6661	17.6143	17.6475	2024316.0
2013-09-10 18:00:00	AAPL	Stock	17.6493	17.65	17.6332	17.6364	471968.0
2013-09-10 19:00:00	AAPL	Stock	17.6368	17.6425	17.6175	17.6275	745780.0
2013-09-10 05:00:00	MSFT	Stock	31.83	31.95	31.83	31.94	3441.0
2013-09-10 06:00:00	MSFT	Stock	31.91	32.0	31.91	31.95	8371.0
2013-09-10 07:00:00	MSFT	Stock	31.95	31.95	31.9	31.9	58914.0
2013-09-10 08:00:00	MSFT	Stock	31.91	31.95	31.8	31.87	76330.0
2013-09-10 09:00:00	MSFT	Stock	31.87	32.37	31.79	32.3	7818555.0
2013-09-10 10:00:00	MSFT	Stock	32.3	32.34	32.105	32.165	8878894.0
2013-09-10 11:00:00	MSFT	Stock	32.17	32.34	32.15	32.225	6318545.0
2013-09-10 12:00:00	MSFT	Stock	32.225	32.27	32.17	32.2	3017509.0
2013-09-10 13:00:00	MSFT	Stock	32.195	32.35	32.14	32.329	4695962.0
2013-09-10 14:00:00	MSFT	Stock	32.32	32.35	32.22	32.31	8479934.0
2013-09-10 15:00:00	MSFT	Stock	32.31	32.4	32.27	32.38	9736363.0
2013-09-10 16:00:00	MSFT	Stock	32.38	32.44	31.685	32.38	3454556.0
2013-09-10 17:00:00	MSFT	Stock	32.41	32.41	32.38	32.4	241051.0
2013-09-10 18:00:00	MSFT	Stock	32.39	32.4	32.39	32.39	3403.0
2013-09-10 19:00:00	MSFT	Stock	32.39	32.39	32.38	32.38	2700.0
2013-09-10 08:00:00	NVDA	Stock	0.38	0.38	0.38	0.38	14000.0
2013-09-10 09:00:00	NVDA	Stock	0.381	0.3822	0.3793	0.3803	28976440.0
2013-09-10 10:00:00	NVDA	Stock	0.3805	0.3833	0.3803	0.382	50842040.0
2013-09-10 11:00:00	NVDA	Stock	0.3819	0.3845	0.3815	0.3841	27548080.0
2013-09-10 12:00:00	NVDA	Stock	0.3841	0.3854	0.3838	0.3844	32261280.0
2013-09-10 13:00:00	NVDA	Stock	0.3845	0.3855	0.3838	0.3853	20107720.0
2013-09-10 14:00:00	NVDA	Stock	0.3851	0.3855	0.384	0.3853	21215080.0
2013-09-10 15:00:00	NVDA	Stock	0.3851	0.3865	0.3848	0.3861	91176600.0
2013-09-10 16:00:00	NVDA	Stock	0.3862	0.3868	0.3834	0.3865	17731640.0
2013-09-10 17:00:00	NVDA	Stock	0.3858	0.3858	0.3858	0.3858	96840.0
2013-09-10 18:00:00	NVDA	Stock	0.385	0.385	0.385	0.385	8000.0
2013-09-10 19:00:00	NVDA	Stock	0.386	0.3865	0.386	0.3865	101720.0
2013-09-10 04:00:00	AMZN	Stock	15.0	15.0	15.0	15.0	6000.0
2013-09-10 06:00:00	AMZN	Stock	15.0495	15.075	15.0495	15.075	8000.0
2013-09-10 07:00:00	AMZN	Stock	15.1	15.1	15.075	15.0945	10120.0
2013-09-10 08:00:00	AMZN	Stock	15.059	15.061	15.05	15.05	75980.0
2013-09-10 09:00:00	AMZN	Stock	15.061	15.0625	14.935	14.97	6467240.0
2013-09-10 10:00:00	AMZN	Stock	14.979	15.03	14.957	14.975	5023080.0
2013-09-10 11:00:00	AMZN	Stock	14.9715	15.0	14.918	14.9333	3105340.0

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

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