PREVIEW / stock_1hour / 2016-04-25

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-04-25.parquet
  size:    1.0 MB
  rows:    47,894
  symbols: 3,320

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
2016-04-25 04:00:00	AAPL	Stock	26.305	26.375	26.305	26.375	6016.0
2016-04-25 05:00:00	AAPL	Stock	26.3025	26.37	26.3025	26.37	8204.0
2016-04-25 06:00:00	AAPL	Stock	26.375	26.375	26.36	26.3625	44612.0
2016-04-25 07:00:00	AAPL	Stock	26.3625	26.365	26.19	26.2425	153032.0
2016-04-25 08:00:00	AAPL	Stock	26.2275	26.3625	26.2175	26.2675	234656.0
2016-04-25 09:00:00	AAPL	Stock	26.27	26.4125	26.2	26.2582	14736176.0
2016-04-25 10:00:00	AAPL	Stock	26.26	26.285	26.145	26.163	16580224.0
2016-04-25 11:00:00	AAPL	Stock	26.1625	26.2575	26.1275	26.2235	12877812.0
2016-04-25 12:00:00	AAPL	Stock	26.2238	26.2825	26.1975	26.2725	10653012.0
2016-04-25 13:00:00	AAPL	Stock	26.275	26.345	26.24	26.3375	12025348.0
2016-04-25 14:00:00	AAPL	Stock	26.3398	26.3475	26.2695	26.2925	9911248.0
2016-04-25 15:00:00	AAPL	Stock	26.295	26.3075	26.22	26.27	19188732.0
2016-04-25 16:00:00	AAPL	Stock	26.27	26.3325	26.2258	26.29	7317492.0
2016-04-25 17:00:00	AAPL	Stock	26.2925	26.31	26.2875	26.29	48040.0
2016-04-25 18:00:00	AAPL	Stock	26.3125	26.3125	26.2875	26.2875	16768.0
2016-04-25 19:00:00	AAPL	Stock	26.2875	26.2975	26.275	26.2775	41956.0
2016-04-25 04:00:00	MSFT	Stock	51.78	51.78	51.6	51.7	699.0
2016-04-25 06:00:00	MSFT	Stock	51.76	51.88	51.76	51.88	2048.0
2016-04-25 07:00:00	MSFT	Stock	51.69	51.78	51.61	51.61	12275.0
2016-04-25 08:00:00	MSFT	Stock	51.67	51.74	51.49	51.65	81643.0
2016-04-25 09:00:00	MSFT	Stock	51.65	52.0	51.5	52.0	4850457.0
2016-04-25 10:00:00	MSFT	Stock	51.995	52.1	51.6	51.83	6409757.0
2016-04-25 11:00:00	MSFT	Stock	51.829	51.97	51.7	51.84	3752438.0
2016-04-25 12:00:00	MSFT	Stock	51.841	52.015	51.78	51.944	2879109.0
2016-04-25 13:00:00	MSFT	Stock	51.95	51.96	51.84	51.88	2407832.0
2016-04-25 14:00:00	MSFT	Stock	51.88	52.02	51.8	51.985	3212524.0
2016-04-25 15:00:00	MSFT	Stock	51.99	52.13	51.87	52.12	5781701.0
2016-04-25 16:00:00	MSFT	Stock	52.11	52.17	52.05	52.1	1576783.0
2016-04-25 17:00:00	MSFT	Stock	52.12	52.12	52.05	52.11	59509.0
2016-04-25 18:00:00	MSFT	Stock	52.1	52.11	52.06	52.11	5876.0
2016-04-25 19:00:00	MSFT	Stock	52.11	52.13	52.1	52.13	2561.0
2016-04-25 07:00:00	NVDA	Stock	0.904	0.904	0.904	0.904	4000.0
2016-04-25 08:00:00	NVDA	Stock	0.9065	0.91	0.9065	0.91	12000.0
2016-04-25 09:00:00	NVDA	Stock	0.9025	0.9162	0.9025	0.913	14541200.0
2016-04-25 10:00:00	NVDA	Stock	0.9133	0.9145	0.9085	0.9105	25938640.0
2016-04-25 11:00:00	NVDA	Stock	0.9102	0.9118	0.9085	0.91	15441000.0
2016-04-25 12:00:00	NVDA	Stock	0.91	0.914	0.9082	0.912	17547520.0
2016-04-25 13:00:00	NVDA	Stock	0.9121	0.914	0.9115	0.9123	12798600.0
2016-04-25 14:00:00	NVDA	Stock	0.9125	0.913	0.9082	0.9126	20154480.0
2016-04-25 15:00:00	NVDA	Stock	0.9128	0.9135	0.9095	0.9113	56913320.0
2016-04-25 16:00:00	NVDA	Stock	0.9113	0.9135	0.9113	0.9135	2589600.0
2016-04-25 17:00:00	NVDA	Stock	0.9195	0.9195	0.9195	0.9195	4000.0
2016-04-25 07:00:00	AMZN	Stock	31.023	31.023	31.023	31.023	4000.0
2016-04-25 08:00:00	AMZN	Stock	30.95	30.95	30.9005	30.9395	51460.0
2016-04-25 09:00:00	AMZN	Stock	30.925	31.0929	30.8126	30.9775	5750400.0
2016-04-25 10:00:00	AMZN	Stock	30.966	31.05	30.837	30.838	6965060.0
2016-04-25 11:00:00	AMZN	Stock	30.8505	30.9975	30.84	30.9715	4413160.0
2016-04-25 12:00:00	AMZN	Stock	30.977	31.2875	30.961	31.2415	6509180.0
2016-04-25 13:00:00	AMZN	Stock	31.2359	31.349	31.1885	31.323	4476360.0
2016-04-25 14:00:00	AMZN	Stock	31.3206	31.3305	31.19	31.2445	3155340.0

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

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