PREVIEW / stock_1hour / 2017-04-12

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-04-12.parquet
  size:    1.0 MB
  rows:    47,523
  symbols: 3,032

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
2017-04-12 04:00:00	AAPL	Stock	35.4825	35.5625	35.425	35.425	27712.0
2017-04-12 06:00:00	AAPL	Stock	35.4075	35.4075	35.3775	35.385	5500.0
2017-04-12 07:00:00	AAPL	Stock	35.3975	35.3975	35.35	35.35	15464.0
2017-04-12 08:00:00	AAPL	Stock	35.35	35.385	35.35	35.3675	46240.0
2017-04-12 09:00:00	AAPL	Stock	35.3625	35.5375	35.3375	35.4452	11657712.0
2017-04-12 10:00:00	AAPL	Stock	35.45	35.48	35.3275	35.3575	10813432.0
2017-04-12 11:00:00	AAPL	Stock	35.3575	35.405	35.2662	35.3375	7738792.0
2017-04-12 12:00:00	AAPL	Stock	35.34	35.371	35.2625	35.2828	5852012.0
2017-04-12 13:00:00	AAPL	Stock	35.285	35.425	35.2525	35.415	8007084.0
2017-04-12 14:00:00	AAPL	Stock	35.4138	35.45	35.3025	35.3875	9462660.0
2017-04-12 15:00:00	AAPL	Stock	35.385	35.4525	35.3325	35.4475	16414912.0
2017-04-12 16:00:00	AAPL	Stock	35.4475	35.4675	35.4275	35.4425	5101088.0
2017-04-12 17:00:00	AAPL	Stock	35.4425	35.4475	35.425	35.44	12432.0
2017-04-12 18:00:00	AAPL	Stock	35.4325	35.4525	35.4325	35.45	36916.0
2017-04-12 19:00:00	AAPL	Stock	35.4525	35.485	35.45	35.485	64664.0
2017-04-12 05:00:00	MSFT	Stock	65.6	65.6	65.6	65.6	254.0
2017-04-12 06:00:00	MSFT	Stock	65.6	65.6	65.6	65.6	2151.0
2017-04-12 07:00:00	MSFT	Stock	65.5	65.5	65.5	65.5	499.0
2017-04-12 08:00:00	MSFT	Stock	65.21	65.5	65.21	65.48	3373.0
2017-04-12 09:00:00	MSFT	Stock	65.42	65.51	65.24	65.36	1500054.0
2017-04-12 10:00:00	MSFT	Stock	65.36	65.49	65.245	65.25	2180378.0
2017-04-12 11:00:00	MSFT	Stock	65.255	65.37	65.115	65.18	2209084.0
2017-04-12 12:00:00	MSFT	Stock	65.18	65.31	65.13	65.18	1450864.0
2017-04-12 13:00:00	MSFT	Stock	65.18	65.36	65.15	65.335	1615727.0
2017-04-12 14:00:00	MSFT	Stock	65.35	65.37	65.11	65.19	2166667.0
2017-04-12 15:00:00	MSFT	Stock	65.2	65.32	65.17	65.22	3219547.0
2017-04-12 16:00:00	MSFT	Stock	65.21	65.32	65.2	65.2	1399221.0
2017-04-12 17:00:00	MSFT	Stock	65.19	65.2	65.19	65.2	500.0
2017-04-12 18:00:00	MSFT	Stock	65.2	65.23	65.2	65.23	479.0
2017-04-12 19:00:00	MSFT	Stock	65.29	65.29	65.27	65.27	300.0
2017-04-12 05:00:00	NVDA	Stock	2.475	2.475	2.475	2.475	4320.0
2017-04-12 06:00:00	NVDA	Stock	2.4625	2.4625	2.4625	2.4625	4000.0
2017-04-12 07:00:00	NVDA	Stock	2.4732	2.475	2.4628	2.4663	168720.0
2017-04-12 08:00:00	NVDA	Stock	2.459	2.4675	2.4548	2.4548	496960.0
2017-04-12 09:00:00	NVDA	Stock	2.4525	2.4605	2.4375	2.4545	48992000.0
2017-04-12 10:00:00	NVDA	Stock	2.455	2.4675	2.4542	2.4548	76868360.0
2017-04-12 11:00:00	NVDA	Stock	2.455	2.456	2.4375	2.4412	54972720.0
2017-04-12 12:00:00	NVDA	Stock	2.4412	2.4448	2.4275	2.4315	36603440.0
2017-04-12 13:00:00	NVDA	Stock	2.4315	2.4465	2.43	2.4458	33454000.0
2017-04-12 14:00:00	NVDA	Stock	2.4458	2.4498	2.4405	2.4445	32149800.0
2017-04-12 15:00:00	NVDA	Stock	2.4449	2.4451	2.43	2.4323	64282520.0
2017-04-12 16:00:00	NVDA	Stock	2.4328	2.4338	2.4302	2.4328	32099320.0
2017-04-12 17:00:00	NVDA	Stock	2.433	2.433	2.4305	2.432	43080.0
2017-04-12 18:00:00	NVDA	Stock	2.4318	2.432	2.4305	2.4305	121000.0
2017-04-12 19:00:00	NVDA	Stock	2.4305	2.4305	2.4262	2.4288	245160.0
2017-04-12 07:00:00	AMZN	Stock	45.15	45.15	45.13	45.146	12680.0
2017-04-12 08:00:00	AMZN	Stock	45.1065	45.151	45.1065	45.1315	48320.0
2017-04-12 09:00:00	AMZN	Stock	45.172	45.2045	45.0265	45.1495	7595840.0
2017-04-12 10:00:00	AMZN	Stock	45.142	45.195	45.067	45.1511	5746100.0
2017-04-12 11:00:00	AMZN	Stock	45.1475	45.1555	44.9365	45.0	6231280.0

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

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