PREVIEW / stock_1hour / 2016-07-18

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-07-18.parquet
  size:    1.0 MB
  rows:    48,302
  symbols: 3,276

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-07-18 04:00:00	AAPL	Stock	24.6925	24.75	24.6925	24.745	2780.0
2016-07-18 05:00:00	AAPL	Stock	24.7375	24.7375	24.7375	24.7375	400.0
2016-07-18 06:00:00	AAPL	Stock	24.7375	24.7375	24.7075	24.7125	11968.0
2016-07-18 07:00:00	AAPL	Stock	24.7225	24.755	24.7225	24.755	26416.0
2016-07-18 08:00:00	AAPL	Stock	24.7425	24.77	24.7125	24.745	277988.0
2016-07-18 09:00:00	AAPL	Stock	24.735	24.8725	24.65	24.8725	19151388.0
2016-07-18 10:00:00	AAPL	Stock	24.8725	25.02	24.8675	25.0062	30823024.0
2016-07-18 11:00:00	AAPL	Stock	25.006	25.0325	24.9525	24.9985	19294508.0
2016-07-18 12:00:00	AAPL	Stock	24.9975	25.0	24.9525	24.9628	11638000.0
2016-07-18 13:00:00	AAPL	Stock	24.9638	24.9912	24.945	24.966	10861556.0
2016-07-18 14:00:00	AAPL	Stock	24.965	24.99	24.905	24.985	15506940.0
2016-07-18 15:00:00	AAPL	Stock	24.985	24.9875	24.955	24.9575	20493024.0
2016-07-18 16:00:00	AAPL	Stock	24.9575	24.9925	24.915	24.94	7654816.0
2016-07-18 17:00:00	AAPL	Stock	24.935	24.9575	24.9125	24.92	119840.0
2016-07-18 18:00:00	AAPL	Stock	24.925	24.94	24.925	24.94	27628.0
2016-07-18 19:00:00	AAPL	Stock	24.94	24.9525	24.9325	24.945	11464.0
2016-07-18 06:00:00	MSFT	Stock	53.68	53.68	53.68	53.68	100.0
2016-07-18 07:00:00	MSFT	Stock	53.79	53.8	53.79	53.8	3303.0
2016-07-18 08:00:00	MSFT	Stock	53.7	53.95	53.7	53.79	10250.0
2016-07-18 09:00:00	MSFT	Stock	53.81	54.0	53.55	53.97	3018476.0
2016-07-18 10:00:00	MSFT	Stock	53.96	54.22	53.94	54.125	4027515.0
2016-07-18 11:00:00	MSFT	Stock	54.125	54.34	54.11	54.22	3463888.0
2016-07-18 12:00:00	MSFT	Stock	54.215	54.25	54.1	54.18	2021568.0
2016-07-18 13:00:00	MSFT	Stock	54.175	54.245	54.085	54.185	2127827.0
2016-07-18 14:00:00	MSFT	Stock	54.18	54.22	53.96	54.05	4027095.0
2016-07-18 15:00:00	MSFT	Stock	54.05	54.08	53.92	53.97	5711701.0
2016-07-18 16:00:00	MSFT	Stock	53.98	54.5	53.93	54.05	2757797.0
2016-07-18 17:00:00	MSFT	Stock	54.06	54.19	53.99	54.19	331253.0
2016-07-18 18:00:00	MSFT	Stock	54.15	54.19	54.15	54.19	14692.0
2016-07-18 19:00:00	MSFT	Stock	54.1	54.18	54.09	54.15	1127.0
2016-07-18 06:00:00	NVDA	Stock	1.327	1.335	1.327	1.335	22600.0
2016-07-18 07:00:00	NVDA	Stock	1.328	1.3308	1.328	1.3308	135000.0
2016-07-18 08:00:00	NVDA	Stock	1.3325	1.3348	1.3295	1.33	229240.0
2016-07-18 09:00:00	NVDA	Stock	1.33	1.3358	1.3193	1.324	40766720.0
2016-07-18 10:00:00	NVDA	Stock	1.3243	1.331	1.3238	1.3296	35703560.0
2016-07-18 11:00:00	NVDA	Stock	1.3296	1.3345	1.3292	1.3316	32313800.0
2016-07-18 12:00:00	NVDA	Stock	1.3315	1.3323	1.323	1.3235	18055880.0
2016-07-18 13:00:00	NVDA	Stock	1.3238	1.3252	1.3208	1.3249	22564320.0
2016-07-18 14:00:00	NVDA	Stock	1.325	1.3273	1.3232	1.325	26689400.0
2016-07-18 15:00:00	NVDA	Stock	1.3252	1.326	1.323	1.3245	43268400.0
2016-07-18 16:00:00	NVDA	Stock	1.3243	1.325	1.3243	1.3243	15038960.0
2016-07-18 17:00:00	NVDA	Stock	1.324	1.3243	1.324	1.3243	682040.0
2016-07-18 18:00:00	NVDA	Stock	1.3243	1.3243	1.3243	1.3243	20800.0
2016-07-18 19:00:00	NVDA	Stock	1.327	1.327	1.327	1.327	4000.0
2016-07-18 04:00:00	AMZN	Stock	36.994	37.0525	36.95	37.0525	57600.0
2016-07-18 05:00:00	AMZN	Stock	37.0555	37.075	37.0155	37.0445	17900.0
2016-07-18 06:00:00	AMZN	Stock	37.015	37.015	36.85	36.85	29500.0
2016-07-18 07:00:00	AMZN	Stock	36.9	36.94	36.899	36.94	50520.0
2016-07-18 08:00:00	AMZN	Stock	36.9	36.908	36.75	36.78	298160.0
2016-07-18 09:00:00	AMZN	Stock	36.794	36.8	36.436	36.564	9876700.0

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

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