PREVIEW / stock_1hour / 2015-06-24

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-06-24.parquet
  size:    1.1 MB
  rows:    51,233
  symbols: 3,512

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-06-24 04:00:00	AAPL	Stock	31.75	31.7875	31.7475	31.7875	2400.0
2015-06-24 05:00:00	AAPL	Stock	31.75	31.75	31.6975	31.6975	30296.0
2015-06-24 06:00:00	AAPL	Stock	31.6975	31.72	31.6725	31.69	25072.0
2015-06-24 07:00:00	AAPL	Stock	31.6875	31.725	31.6575	31.7	45536.0
2015-06-24 08:00:00	AAPL	Stock	31.6975	31.79	31.675	31.78	492260.0
2015-06-24 09:00:00	AAPL	Stock	31.7875	32.14	31.78	32.115	33932612.0
2015-06-24 10:00:00	AAPL	Stock	32.1162	32.45	32.1025	32.3475	49408536.0
2015-06-24 11:00:00	AAPL	Stock	32.345	32.3775	32.27	32.31	28660532.0
2015-06-24 12:00:00	AAPL	Stock	32.3125	32.3177	32.1825	32.2475	23264364.0
2015-06-24 13:00:00	AAPL	Stock	32.2425	32.3525	32.1075	32.1778	22757608.0
2015-06-24 14:00:00	AAPL	Stock	32.1775	32.2	32.055	32.1125	17922080.0
2015-06-24 15:00:00	AAPL	Stock	32.1123	32.1175	31.9925	32.04	25928164.0
2015-06-24 16:00:00	AAPL	Stock	32.0425	32.2905	32.0275	32.0875	7417688.0
2015-06-24 17:00:00	AAPL	Stock	32.1	32.15	32.1	32.1075	194204.0
2015-06-24 18:00:00	AAPL	Stock	32.105	32.11	32.0275	32.1	629356.0
2015-06-24 19:00:00	AAPL	Stock	32.1	32.11	32.095	32.105	23012.0
2015-06-24 05:00:00	MSFT	Stock	45.8	45.8	45.8	45.8	300.0
2015-06-24 06:00:00	MSFT	Stock	45.78	45.78	45.78	45.78	200.0
2015-06-24 08:00:00	MSFT	Stock	45.75	45.91	45.663	45.72	6269.0
2015-06-24 09:00:00	MSFT	Stock	45.75	45.84	45.55	45.8	3556443.0
2015-06-24 10:00:00	MSFT	Stock	45.78	46.245	45.78	46.23	4105197.0
2015-06-24 11:00:00	MSFT	Stock	46.23	46.24	45.91	46.01	2484569.0
2015-06-24 12:00:00	MSFT	Stock	46.005	46.025	45.85	46.02	1689882.0
2015-06-24 13:00:00	MSFT	Stock	46.02	46.145	45.8	45.9	2125274.0
2015-06-24 14:00:00	MSFT	Stock	45.905	45.95	45.79	45.88	1833721.0
2015-06-24 15:00:00	MSFT	Stock	45.88	45.91	45.63	45.63	5072398.0
2015-06-24 16:00:00	MSFT	Stock	45.635	45.83	45.63	45.7	6838851.0
2015-06-24 17:00:00	MSFT	Stock	45.7	45.7	45.65	45.65	572.0
2015-06-24 18:00:00	MSFT	Stock	45.635	45.77	45.635	45.77	40700.0
2015-06-24 19:00:00	MSFT	Stock	45.71	45.71	45.7	45.7	690.0
2015-06-24 08:00:00	NVDA	Stock	0.5305	0.5305	0.5305	0.5305	10080.0
2015-06-24 09:00:00	NVDA	Stock	0.5298	0.5325	0.5265	0.532	28391920.0
2015-06-24 10:00:00	NVDA	Stock	0.532	0.5322	0.5285	0.5295	22785800.0
2015-06-24 11:00:00	NVDA	Stock	0.5295	0.53	0.528	0.5281	20546840.0
2015-06-24 12:00:00	NVDA	Stock	0.528	0.5282	0.5258	0.5266	20052440.0
2015-06-24 13:00:00	NVDA	Stock	0.5268	0.5268	0.5238	0.524	15102920.0
2015-06-24 14:00:00	NVDA	Stock	0.524	0.5251	0.5235	0.5245	14811240.0
2015-06-24 15:00:00	NVDA	Stock	0.5245	0.5255	0.5228	0.5253	81611760.0
2015-06-24 16:00:00	NVDA	Stock	0.5247	0.5253	0.5242	0.5253	3049800.0
2015-06-24 17:00:00	NVDA	Stock	0.525	0.525	0.525	0.525	10000.0
2015-06-24 19:00:00	NVDA	Stock	0.5258	0.5258	0.5258	0.5258	4000.0
2015-06-24 05:00:00	AMZN	Stock	22.256	22.256	22.256	22.256	3000.0
2015-06-24 07:00:00	AMZN	Stock	22.256	22.256	22.2085	22.2085	8000.0
2015-06-24 08:00:00	AMZN	Stock	22.247	22.2995	22.2085	22.257	64860.0
2015-06-24 09:00:00	AMZN	Stock	22.24	22.3125	22.175	22.2368	8092860.0
2015-06-24 10:00:00	AMZN	Stock	22.2375	22.3235	22.189	22.2025	8783980.0
2015-06-24 11:00:00	AMZN	Stock	22.2055	22.223	22.1165	22.1465	6101920.0
2015-06-24 12:00:00	AMZN	Stock	22.16	22.16	22.0705	22.0912	4255240.0
2015-06-24 13:00:00	AMZN	Stock	22.0889	22.1152	22.044	22.051	3366020.0
2015-06-24 14:00:00	AMZN	Stock	22.053	22.1215	22.0115	22.0955	4874580.0

> showing 50 of 51,233 rows — these rows as CSV

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