PREVIEW / stock_1hour / 2015-08-26

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-08-26.parquet
  size:    1.1 MB
  rows:    50,040
  symbols: 3,479

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-08-26 04:00:00	AAPL	Stock	26.2625	26.55	26.25	26.5125	78768.0
2015-08-26 05:00:00	AAPL	Stock	26.5	26.52	26.4375	26.4375	49000.0
2015-08-26 06:00:00	AAPL	Stock	26.41	26.6075	26.325	26.5975	158948.0
2015-08-26 07:00:00	AAPL	Stock	26.54	26.76	26.51	26.6575	583640.0
2015-08-26 08:00:00	AAPL	Stock	26.65	26.77	26.375	26.6	2536136.0
2015-08-26 09:00:00	AAPL	Stock	26.61	27.0825	26.465	26.7645	56556104.0
2015-08-26 10:00:00	AAPL	Stock	26.765	26.92	26.5	26.68	54583468.0
2015-08-26 11:00:00	AAPL	Stock	26.6775	26.7225	26.285	26.495	38737832.0
2015-08-26 12:00:00	AAPL	Stock	26.495	26.6175	26.2625	26.4875	31445952.0
2015-08-26 13:00:00	AAPL	Stock	26.49	26.96	26.465	26.8625	39687952.0
2015-08-26 14:00:00	AAPL	Stock	26.865	27.075	26.5625	26.86	44437484.0
2015-08-26 15:00:00	AAPL	Stock	26.8575	27.4725	26.81	27.425	71581612.0
2015-08-26 16:00:00	AAPL	Stock	27.425	27.4725	26.8388	27.47	24305892.0
2015-08-26 17:00:00	AAPL	Stock	27.455	27.4725	27.455	27.455	206248.0
2015-08-26 18:00:00	AAPL	Stock	27.4625	27.485	27.45	27.475	213076.0
2015-08-26 19:00:00	AAPL	Stock	27.4875	27.6	27.4725	27.6	221460.0
2015-08-26 05:00:00	MSFT	Stock	41.25	41.25	40.73	41.0	3226.0
2015-08-26 06:00:00	MSFT	Stock	41.01	41.4	41.0	41.35	26299.0
2015-08-26 07:00:00	MSFT	Stock	41.34	41.6	41.25	41.4	47255.0
2015-08-26 08:00:00	MSFT	Stock	41.4	41.86	41.16	41.75	88034.0
2015-08-26 09:00:00	MSFT	Stock	41.75	42.02	41.33	41.65	6794436.0
2015-08-26 10:00:00	MSFT	Stock	41.65	41.82	41.17	41.43	9594211.0
2015-08-26 11:00:00	MSFT	Stock	41.43	41.51	41.06	41.31	5778746.0
2015-08-26 12:00:00	MSFT	Stock	41.31	41.45	41.1	41.35	4610442.0
2015-08-26 13:00:00	MSFT	Stock	41.34	41.54	41.12	41.42	8033974.0
2015-08-26 14:00:00	MSFT	Stock	41.43	41.76	41.18	41.69	7694519.0
2015-08-26 15:00:00	MSFT	Stock	41.7	42.84	41.5	42.73	13467336.0
2015-08-26 16:00:00	MSFT	Stock	42.73	42.79	42.64	42.77	4453355.0
2015-08-26 17:00:00	MSFT	Stock	42.71	42.8	42.71	42.8	43978.0
2015-08-26 18:00:00	MSFT	Stock	42.8	42.8	42.75	42.753	1736.0
2015-08-26 19:00:00	MSFT	Stock	42.86	42.86	42.8	42.84	2651.0
2015-08-26 08:00:00	NVDA	Stock	0.5072	0.525	0.5072	0.525	15080.0
2015-08-26 09:00:00	NVDA	Stock	0.5235	0.5272	0.5195	0.525	56861960.0
2015-08-26 10:00:00	NVDA	Stock	0.525	0.5294	0.5205	0.5246	85568080.0
2015-08-26 11:00:00	NVDA	Stock	0.5247	0.5268	0.5204	0.526	49093520.0
2015-08-26 12:00:00	NVDA	Stock	0.526	0.5278	0.5228	0.527	46199760.0
2015-08-26 13:00:00	NVDA	Stock	0.5272	0.5352	0.5258	0.535	71905680.0
2015-08-26 14:00:00	NVDA	Stock	0.535	0.5418	0.5342	0.539	80559640.0
2015-08-26 15:00:00	NVDA	Stock	0.5388	0.5458	0.5372	0.5455	172738480.0
2015-08-26 16:00:00	NVDA	Stock	0.5455	0.547	0.5452	0.547	2535440.0
2015-08-26 17:00:00	NVDA	Stock	0.5488	0.5488	0.5488	0.5488	4000.0
2015-08-26 19:00:00	NVDA	Stock	0.5475	0.5495	0.5475	0.549	139800.0
2015-08-26 04:00:00	AMZN	Stock	23.96	23.96	23.905	23.905	4520.0
2015-08-26 06:00:00	AMZN	Stock	23.854	24.05	23.854	24.05	22000.0
2015-08-26 07:00:00	AMZN	Stock	24.0245	24.129	24.0	24.0	76720.0
2015-08-26 08:00:00	AMZN	Stock	24.0005	24.2875	23.9665	24.207	678580.0
2015-08-26 09:00:00	AMZN	Stock	24.211	24.4	24.065	24.2468	19012900.0
2015-08-26 10:00:00	AMZN	Stock	24.286	24.624	23.9476	24.395	23123160.0
2015-08-26 11:00:00	AMZN	Stock	24.395	24.396	23.975	24.1755	13584780.0
2015-08-26 12:00:00	AMZN	Stock	24.1696	24.278	23.938	24.1395	8084780.0

> showing 50 of 50,040 rows — these rows as CSV

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