PREVIEW / stock_1hour / 2015-12-22

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-12-22.parquet
  size:    1.0 MB
  rows:    48,554
  symbols: 3,416

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-12-22 04:00:00	AAPL	Stock	26.925	26.925	26.7625	26.7625	17460.0
2015-12-22 05:00:00	AAPL	Stock	26.7625	26.8525	26.7625	26.8525	42880.0
2015-12-22 06:00:00	AAPL	Stock	26.8375	26.8475	26.7725	26.7725	18536.0
2015-12-22 07:00:00	AAPL	Stock	26.81	26.81	26.75	26.79	68788.0
2015-12-22 08:00:00	AAPL	Stock	26.7875	26.7975	26.705	26.75	294300.0
2015-12-22 09:00:00	AAPL	Stock	26.7575	26.87	26.6525	26.665	16883868.0
2015-12-22 10:00:00	AAPL	Stock	26.665	26.8075	26.6128	26.63	21377636.0
2015-12-22 11:00:00	AAPL	Stock	26.6295	26.84	26.6295	26.81	15808636.0
2015-12-22 12:00:00	AAPL	Stock	26.81	26.93	26.74	26.845	15792432.0
2015-12-22 13:00:00	AAPL	Stock	26.845	26.8675	26.7525	26.8615	10556472.0
2015-12-22 14:00:00	AAPL	Stock	26.8625	26.8675	26.7975	26.855	9939028.0
2015-12-22 15:00:00	AAPL	Stock	26.855	26.875	26.755	26.8025	21150900.0
2015-12-22 16:00:00	AAPL	Stock	26.8075	26.8475	26.79	26.8225	9171828.0
2015-12-22 17:00:00	AAPL	Stock	26.8125	26.825	26.81	26.81	68400.0
2015-12-22 18:00:00	AAPL	Stock	26.8325	26.8475	26.8075	26.83	41324.0
2015-12-22 19:00:00	AAPL	Stock	26.83	26.83	26.8075	26.83	76544.0
2015-12-22 07:00:00	MSFT	Stock	54.85	55.09	54.85	55.09	3398.0
2015-12-22 08:00:00	MSFT	Stock	55.0	55.05	54.84	54.92	6008.0
2015-12-22 09:00:00	MSFT	Stock	54.97	55.12	54.5	54.85	3449138.0
2015-12-22 10:00:00	MSFT	Stock	54.85	55.14	54.71	54.83	4481130.0
2015-12-22 11:00:00	MSFT	Stock	54.835	55.2	54.77	55.055	3454232.0
2015-12-22 12:00:00	MSFT	Stock	55.06	55.18	54.96	55.1	2498840.0
2015-12-22 13:00:00	MSFT	Stock	55.1	55.25	54.89	55.21	2879973.0
2015-12-22 14:00:00	MSFT	Stock	55.21	55.247	55.09	55.235	2211316.0
2015-12-22 15:00:00	MSFT	Stock	55.24	55.48	55.18	55.35	5498985.0
2015-12-22 16:00:00	MSFT	Stock	55.35	55.45	55.35	55.45	2206773.0
2015-12-22 17:00:00	MSFT	Stock	55.35	55.35	55.35	55.35	1500.0
2015-12-22 19:00:00	MSFT	Stock	55.47	55.55	55.47	55.55	1270.0
2015-12-22 07:00:00	NVDA	Stock	0.8262	0.8262	0.8262	0.8262	39960.0
2015-12-22 08:00:00	NVDA	Stock	0.8262	0.8262	0.825	0.825	84000.0
2015-12-22 09:00:00	NVDA	Stock	0.8224	0.831	0.8224	0.8268	17569400.0
2015-12-22 10:00:00	NVDA	Stock	0.8268	0.8315	0.823	0.8235	16917480.0
2015-12-22 11:00:00	NVDA	Stock	0.8238	0.825	0.8203	0.8216	13035600.0
2015-12-22 12:00:00	NVDA	Stock	0.8218	0.8222	0.8182	0.822	10507200.0
2015-12-22 13:00:00	NVDA	Stock	0.822	0.8224	0.8185	0.8212	11053560.0
2015-12-22 14:00:00	NVDA	Stock	0.8211	0.8232	0.8205	0.8228	9061160.0
2015-12-22 15:00:00	NVDA	Stock	0.8229	0.8242	0.821	0.8232	30027800.0
2015-12-22 16:00:00	NVDA	Stock	0.8232	0.8245	0.8232	0.8234	469640.0
2015-12-22 17:00:00	NVDA	Stock	0.8232	0.8232	0.8175	0.8182	473760.0
2015-12-22 18:00:00	NVDA	Stock	0.817	0.8182	0.8165	0.8175	84000.0
2015-12-22 19:00:00	NVDA	Stock	0.823	0.823	0.819	0.819	8000.0
2015-12-22 04:00:00	AMZN	Stock	33.1775	33.1835	33.1775	33.1835	20000.0
2015-12-22 05:00:00	AMZN	Stock	33.1835	33.1835	33.1835	33.1835	5980.0
2015-12-22 07:00:00	AMZN	Stock	33.225	33.273	33.2225	33.273	16400.0
2015-12-22 08:00:00	AMZN	Stock	33.3	33.3	33.231	33.2845	45940.0
2015-12-22 09:00:00	AMZN	Stock	33.2845	33.4245	33.2615	33.279	4799160.0
2015-12-22 10:00:00	AMZN	Stock	33.279	33.3845	33.2	33.2815	6220940.0
2015-12-22 11:00:00	AMZN	Stock	33.272	33.347	33.1255	33.1575	4328800.0
2015-12-22 12:00:00	AMZN	Stock	33.16	33.1695	32.963	33.1065	6942040.0
2015-12-22 13:00:00	AMZN	Stock	33.1103	33.132	32.975	33.0744	5181660.0

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

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