PREVIEW / stock_1hour / 2015-09-23

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-09-23.parquet
  size:    1.0 MB
  rows:    47,726
  symbols: 3,429

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-09-23 04:00:00	AAPL	Stock	27.775	28.465	27.775	28.4175	25800.0
2015-09-23 05:00:00	AAPL	Stock	28.4425	28.445	28.425	28.445	28136.0
2015-09-23 06:00:00	AAPL	Stock	28.445	28.5	28.425	28.4475	55332.0
2015-09-23 07:00:00	AAPL	Stock	28.4475	28.5125	28.4375	28.45	174072.0
2015-09-23 08:00:00	AAPL	Stock	28.455	28.5525	28.4375	28.4825	752700.0
2015-09-23 09:00:00	AAPL	Stock	28.485	28.5275	28.35	28.4672	19942904.0
2015-09-23 10:00:00	AAPL	Stock	28.4675	28.58	28.4325	28.535	20276676.0
2015-09-23 11:00:00	AAPL	Stock	28.5328	28.5425	28.325	28.385	16861008.0
2015-09-23 12:00:00	AAPL	Stock	28.385	28.4975	28.335	28.4875	13242456.0
2015-09-23 13:00:00	AAPL	Stock	28.485	28.5625	28.415	28.553	11578152.0
2015-09-23 14:00:00	AAPL	Stock	28.5525	28.6588	28.5125	28.545	19481444.0
2015-09-23 15:00:00	AAPL	Stock	28.5475	28.68	28.52	28.585	26937516.0
2015-09-23 16:00:00	AAPL	Stock	28.58	28.615	28.5375	28.5875	4955412.0
2015-09-23 17:00:00	AAPL	Stock	28.5825	28.6	28.5825	28.595	55072.0
2015-09-23 18:00:00	AAPL	Stock	28.5975	28.62	28.5875	28.6	70708.0
2015-09-23 19:00:00	AAPL	Stock	28.605	28.605	28.58	28.585	34912.0
2015-09-23 07:00:00	MSFT	Stock	44.11	44.11	44.11	44.11	2000.0
2015-09-23 08:00:00	MSFT	Stock	44.11	44.16	44.07	44.07	1900.0
2015-09-23 09:00:00	MSFT	Stock	44.13	44.13	43.77	43.97	1962845.0
2015-09-23 10:00:00	MSFT	Stock	43.97	44.17	43.91	44.02	2223031.0
2015-09-23 11:00:00	MSFT	Stock	44.03	44.057	43.55	43.659	2130128.0
2015-09-23 12:00:00	MSFT	Stock	43.66	43.75	43.51	43.73	1589281.0
2015-09-23 13:00:00	MSFT	Stock	43.724	43.95	43.7	43.855	1373871.0
2015-09-23 14:00:00	MSFT	Stock	43.85	44.01	43.785	43.9	1621730.0
2015-09-23 15:00:00	MSFT	Stock	43.895	44.08	43.83	43.88	4168736.0
2015-09-23 16:00:00	MSFT	Stock	43.87	43.97	43.87	43.95	1230227.0
2015-09-23 18:00:00	MSFT	Stock	43.95	43.95	43.95	43.95	200.0
2015-09-23 19:00:00	MSFT	Stock	43.95	43.95	43.94	43.95	1186.0
2015-09-23 09:00:00	NVDA	Stock	0.5732	0.5752	0.5705	0.5749	19655920.0
2015-09-23 10:00:00	NVDA	Stock	0.5749	0.5778	0.573	0.5775	35315520.0
2015-09-23 11:00:00	NVDA	Stock	0.5772	0.5785	0.5721	0.5735	22569440.0
2015-09-23 12:00:00	NVDA	Stock	0.5735	0.5745	0.5715	0.5742	13337360.0
2015-09-23 13:00:00	NVDA	Stock	0.574	0.5775	0.5738	0.5758	17430600.0
2015-09-23 14:00:00	NVDA	Stock	0.5758	0.5778	0.5735	0.574	16030160.0
2015-09-23 15:00:00	NVDA	Stock	0.5742	0.576	0.5735	0.575	25817960.0
2015-09-23 16:00:00	NVDA	Stock	0.575	0.575	0.575	0.575	470760.0
2015-09-23 04:00:00	AMZN	Stock	26.927	27.0225	26.927	27.0225	32200.0
2015-09-23 06:00:00	AMZN	Stock	26.9885	27.025	26.9885	27.025	6040.0
2015-09-23 07:00:00	AMZN	Stock	27.05	27.05	26.949	26.949	49260.0
2015-09-23 08:00:00	AMZN	Stock	26.9505	27.0225	26.92	26.9855	213440.0
2015-09-23 09:00:00	AMZN	Stock	26.99	27.0235	26.75	26.922	4924520.0
2015-09-23 10:00:00	AMZN	Stock	26.9	27.0605	26.791	27.0376	9824120.0
2015-09-23 11:00:00	AMZN	Stock	27.0475	27.05	26.755	26.7793	5811820.0
2015-09-23 12:00:00	AMZN	Stock	26.7875	26.8965	26.7	26.8835	3276660.0
2015-09-23 13:00:00	AMZN	Stock	26.8785	27.0025	26.811	26.9893	4791640.0
2015-09-23 14:00:00	AMZN	Stock	26.9825	27.038	26.816	26.849	4544140.0
2015-09-23 15:00:00	AMZN	Stock	26.834	26.93	26.785	26.8035	7933080.0
2015-09-23 16:00:00	AMZN	Stock	26.8035	26.875	26.8035	26.8245	94320.0
2015-09-23 17:00:00	AMZN	Stock	26.804	26.804	26.804	26.804	56000.0
2015-09-23 18:00:00	AMZN	Stock	26.809	26.8395	26.809	26.8395	16000.0

> showing 50 of 47,726 rows — these rows as CSV

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