PREVIEW / stock_1hour / 2015-01-16

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-01-16.parquet
  size:    1.0 MB
  rows:    48,877
  symbols: 3,521

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-01-16 04:00:00	AAPL	Stock	26.65	26.65	26.5	26.5	36928.0
2015-01-16 05:00:00	AAPL	Stock	26.53	26.595	26.425	26.5825	49176.0
2015-01-16 06:00:00	AAPL	Stock	26.5625	26.675	26.5625	26.675	102148.0
2015-01-16 07:00:00	AAPL	Stock	26.68	26.68	26.5725	26.6	133540.0
2015-01-16 08:00:00	AAPL	Stock	26.5625	26.7975	26.5625	26.76	748028.0
2015-01-16 09:00:00	AAPL	Stock	26.7625	26.895	26.4775	26.55	42283784.0
2015-01-16 10:00:00	AAPL	Stock	26.55	26.7218	26.4675	26.6175	36852620.0
2015-01-16 11:00:00	AAPL	Stock	26.6175	26.7175	26.3125	26.3762	32739504.0
2015-01-16 12:00:00	AAPL	Stock	26.3762	26.52	26.3	26.4575	28105984.0
2015-01-16 13:00:00	AAPL	Stock	26.4575	26.485	26.32	26.4625	19915108.0
2015-01-16 14:00:00	AAPL	Stock	26.4625	26.49	26.385	26.4512	23334340.0
2015-01-16 15:00:00	AAPL	Stock	26.45	26.5	26.325	26.495	48839056.0
2015-01-16 16:00:00	AAPL	Stock	26.4975	26.7688	26.4525	26.5	17275384.0
2015-01-16 17:00:00	AAPL	Stock	26.51	26.51	26.495	26.495	162532.0
2015-01-16 18:00:00	AAPL	Stock	26.4975	26.5075	26.495	26.5	90396.0
2015-01-16 19:00:00	AAPL	Stock	26.5	26.525	26.4975	26.5	74344.0
2015-01-16 04:00:00	MSFT	Stock	45.18	45.18	45.1	45.1	200.0
2015-01-16 05:00:00	MSFT	Stock	45.19	45.19	45.19	45.19	600.0
2015-01-16 06:00:00	MSFT	Stock	45.4	45.4	45.4	45.4	100.0
2015-01-16 07:00:00	MSFT	Stock	45.27	45.27	45.26	45.26	1794.0
2015-01-16 08:00:00	MSFT	Stock	45.22	45.47	45.17	45.4	10849.0
2015-01-16 09:00:00	MSFT	Stock	45.4	45.8	45.17	45.51	7068058.0
2015-01-16 10:00:00	MSFT	Stock	45.52	45.88	45.385	45.796	4671632.0
2015-01-16 11:00:00	MSFT	Stock	45.79	45.94	45.7	45.83	2878890.0
2015-01-16 12:00:00	MSFT	Stock	45.835	46.13	45.73	46.024	2841149.0
2015-01-16 13:00:00	MSFT	Stock	46.025	46.04	45.805	45.975	2346568.0
2015-01-16 14:00:00	MSFT	Stock	45.975	46.0	45.825	45.89	2686295.0
2015-01-16 15:00:00	MSFT	Stock	45.89	46.28	45.83	46.22	7522801.0
2015-01-16 16:00:00	MSFT	Stock	46.22	46.246	45.794	46.15	4041270.0
2015-01-16 17:00:00	MSFT	Stock	46.14	46.17	46.14	46.17	15180.0
2015-01-16 18:00:00	MSFT	Stock	46.17	46.17	46.17	46.17	990.0
2015-01-16 19:00:00	MSFT	Stock	46.16	46.18	46.16	46.18	800.0
2015-01-16 09:00:00	NVDA	Stock	0.4908	0.4931	0.4878	0.4905	22072960.0
2015-01-16 10:00:00	NVDA	Stock	0.4905	0.4982	0.49	0.4978	27109080.0
2015-01-16 11:00:00	NVDA	Stock	0.4975	0.4988	0.4948	0.496	17463600.0
2015-01-16 12:00:00	NVDA	Stock	0.496	0.4985	0.4952	0.4968	13015840.0
2015-01-16 13:00:00	NVDA	Stock	0.4968	0.4978	0.4952	0.497	14691920.0
2015-01-16 14:00:00	NVDA	Stock	0.497	0.497	0.495	0.4963	19161560.0
2015-01-16 15:00:00	NVDA	Stock	0.4963	0.4995	0.4952	0.499	48595920.0
2015-01-16 16:00:00	NVDA	Stock	0.499	0.4998	0.4888	0.4998	12677240.0
2015-01-16 17:00:00	NVDA	Stock	0.5	0.5	0.5	0.5	8000.0
2015-01-16 04:00:00	AMZN	Stock	14.349	14.349	14.349	14.349	2000.0
2015-01-16 06:00:00	AMZN	Stock	14.375	14.375	14.375	14.375	2000.0
2015-01-16 07:00:00	AMZN	Stock	14.3375	14.3375	14.3055	14.3055	14000.0
2015-01-16 08:00:00	AMZN	Stock	14.301	14.35	14.2935	14.3375	106240.0
2015-01-16 09:00:00	AMZN	Stock	14.335	14.492	14.2625	14.3885	11708580.0
2015-01-16 10:00:00	AMZN	Stock	14.3995	14.484	14.36	14.4475	8659080.0
2015-01-16 11:00:00	AMZN	Stock	14.4425	14.4767	14.3745	14.378	4933900.0
2015-01-16 12:00:00	AMZN	Stock	14.3825	14.4625	14.345	14.437	5475000.0
2015-01-16 13:00:00	AMZN	Stock	14.4415	14.481	14.3925	14.462	4766960.0

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

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