PREVIEW / stock_1hour / 2015-09-11

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-09-11.parquet
  size:    1.0 MB
  rows:    48,112
  symbols: 3,451

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-11 04:00:00	AAPL	Stock	28.045	28.045	27.95	27.95	7600.0
2015-09-11 05:00:00	AAPL	Stock	27.9375	27.9975	27.9375	27.9975	16516.0
2015-09-11 06:00:00	AAPL	Stock	28.0	28.0125	27.95	27.95	29332.0
2015-09-11 07:00:00	AAPL	Stock	27.9375	28.035	27.9375	27.9825	105324.0
2015-09-11 08:00:00	AAPL	Stock	27.9775	28.095	27.9375	27.995	505020.0
2015-09-11 09:00:00	AAPL	Stock	27.9925	28.115	27.92	28.0	25302440.0
2015-09-11 10:00:00	AAPL	Stock	28.0	28.15	27.9575	28.08	24422988.0
2015-09-11 11:00:00	AAPL	Stock	28.08	28.15	27.995	28.13	18096164.0
2015-09-11 12:00:00	AAPL	Stock	28.1325	28.3275	28.1275	28.31	22544980.0
2015-09-11 13:00:00	AAPL	Stock	28.31	28.3575	28.2	28.3212	18179908.0
2015-09-11 14:00:00	AAPL	Stock	28.32	28.525	28.265	28.45	30867620.0
2015-09-11 15:00:00	AAPL	Stock	28.4512	28.55	28.4512	28.55	36689504.0
2015-09-11 16:00:00	AAPL	Stock	28.55	28.5525	28.4875	28.5175	10500860.0
2015-09-11 17:00:00	AAPL	Stock	28.52	28.54	28.5	28.53	245212.0
2015-09-11 18:00:00	AAPL	Stock	28.54	28.56	28.52	28.5575	112440.0
2015-09-11 19:00:00	AAPL	Stock	28.5525	28.575	28.5375	28.5725	205984.0
2015-09-11 08:00:00	MSFT	Stock	43.1	43.15	43.05	43.1	7351.0
2015-09-11 09:00:00	MSFT	Stock	43.1	43.29	42.94	43.12	2648926.0
2015-09-11 10:00:00	MSFT	Stock	43.12	43.33	43.07	43.085	2955139.0
2015-09-11 11:00:00	MSFT	Stock	43.09	43.38	43.05	43.33	2341755.0
2015-09-11 12:00:00	MSFT	Stock	43.33	43.58	43.3	43.55	2147417.0
2015-09-11 13:00:00	MSFT	Stock	43.555	43.59	43.26	43.37	1801658.0
2015-09-11 14:00:00	MSFT	Stock	43.364	43.52	43.3	43.42	1928263.0
2015-09-11 15:00:00	MSFT	Stock	43.42	43.48	43.28	43.48	6372397.0
2015-09-11 16:00:00	MSFT	Stock	43.48	43.5	43.39	43.5	5090862.0
2015-09-11 17:00:00	MSFT	Stock	43.5	43.5	43.46	43.46	1500.0
2015-09-11 19:00:00	MSFT	Stock	43.49	43.52	43.49	43.52	1144.0
2015-09-11 09:00:00	NVDA	Stock	0.5582	0.5631	0.5578	0.558	16024760.0
2015-09-11 10:00:00	NVDA	Stock	0.5578	0.559	0.5559	0.558	30053440.0
2015-09-11 11:00:00	NVDA	Stock	0.5578	0.5638	0.557	0.5632	29473080.0
2015-09-11 12:00:00	NVDA	Stock	0.5632	0.5688	0.563	0.5675	66452760.0
2015-09-11 13:00:00	NVDA	Stock	0.5675	0.5688	0.5648	0.5668	23368800.0
2015-09-11 14:00:00	NVDA	Stock	0.5668	0.57	0.5658	0.5676	19860960.0
2015-09-11 15:00:00	NVDA	Stock	0.5678	0.5684	0.565	0.5662	52205040.0
2015-09-11 16:00:00	NVDA	Stock	0.5662	0.5665	0.5662	0.5662	14607800.0
2015-09-11 18:00:00	NVDA	Stock	0.5725	0.5725	0.5725	0.5725	7000.0
2015-09-11 07:00:00	AMZN	Stock	26.0435	26.0465	26.041	26.0465	10000.0
2015-09-11 08:00:00	AMZN	Stock	25.92	26.101	25.92	26.024	226900.0
2015-09-11 09:00:00	AMZN	Stock	26.0155	26.34	26.0	26.2399	9583740.0
2015-09-11 10:00:00	AMZN	Stock	26.225	26.315	26.1865	26.2353	5576940.0
2015-09-11 11:00:00	AMZN	Stock	26.226	26.33	26.2	26.2948	5902740.0
2015-09-11 12:00:00	AMZN	Stock	26.2866	26.4	26.2785	26.3628	5022920.0
2015-09-11 13:00:00	AMZN	Stock	26.3655	26.375	26.2505	26.3025	3692260.0
2015-09-11 14:00:00	AMZN	Stock	26.2995	26.3885	26.264	26.3758	5174660.0
2015-09-11 15:00:00	AMZN	Stock	26.3758	26.4715	26.35	26.4715	16224040.0
2015-09-11 16:00:00	AMZN	Stock	26.4535	26.4945	26.2974	26.471	2361260.0
2015-09-11 17:00:00	AMZN	Stock	26.485	26.485	26.477	26.485	65420.0
2015-09-11 18:00:00	AMZN	Stock	26.489	26.495	26.4825	26.4825	17540.0
2015-09-11 19:00:00	AMZN	Stock	26.49	26.5005	26.49	26.5005	17280.0
2015-09-11 07:00:00	GOOGL	Stock	32.491	32.6475	32.491	32.491	26600.0

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

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