PREVIEW / stock_1hour / 2016-11-21

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-11-21.parquet
  size:    1.1 MB
  rows:    48,852
  symbols: 3,179

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-11-21 04:00:00	AAPL	Stock	27.55	27.55	27.52	27.5375	19200.0
2016-11-21 05:00:00	AAPL	Stock	27.5975	27.6	27.5975	27.6	1288.0
2016-11-21 06:00:00	AAPL	Stock	27.5525	27.6	27.5525	27.6	4360.0
2016-11-21 07:00:00	AAPL	Stock	27.6	27.6125	27.575	27.5775	30000.0
2016-11-21 08:00:00	AAPL	Stock	27.5775	27.6425	27.5625	27.58	282888.0
2016-11-21 09:00:00	AAPL	Stock	27.58	27.795	27.5	27.7875	17088364.0
2016-11-21 10:00:00	AAPL	Stock	27.7875	27.79	27.6175	27.725	12792716.0
2016-11-21 11:00:00	AAPL	Stock	27.7275	27.9725	27.7262	27.9225	16290032.0
2016-11-21 12:00:00	AAPL	Stock	27.9225	27.9725	27.8375	27.95	10168976.0
2016-11-21 13:00:00	AAPL	Stock	27.9515	27.985	27.8875	27.919	7651980.0
2016-11-21 14:00:00	AAPL	Stock	27.9175	27.925	27.865	27.875	7874360.0
2016-11-21 15:00:00	AAPL	Stock	27.8732	27.9975	27.8612	27.9325	20217244.0
2016-11-21 16:00:00	AAPL	Stock	27.9525	27.96	27.6365	27.9325	15915148.0
2016-11-21 17:00:00	AAPL	Stock	27.9475	27.9475	27.8875	27.915	101084.0
2016-11-21 18:00:00	AAPL	Stock	27.915	27.94	27.915	27.9375	29576.0
2016-11-21 19:00:00	AAPL	Stock	27.93	27.95	27.9275	27.95	140980.0
2016-11-21 04:00:00	MSFT	Stock	60.64	60.64	60.64	60.64	100.0
2016-11-21 07:00:00	MSFT	Stock	60.65	60.65	60.59	60.59	1318.0
2016-11-21 08:00:00	MSFT	Stock	60.63	60.65	60.52	60.6	3340.0
2016-11-21 09:00:00	MSFT	Stock	60.35	60.91	60.35	60.8	2427439.0
2016-11-21 10:00:00	MSFT	Stock	60.807	60.815	60.45	60.49	2552212.0
2016-11-21 11:00:00	MSFT	Stock	60.5	60.726	60.44	60.72	1955511.0
2016-11-21 12:00:00	MSFT	Stock	60.73	60.75	60.55	60.67	1664975.0
2016-11-21 13:00:00	MSFT	Stock	60.67	60.75	60.6	60.75	1091668.0
2016-11-21 14:00:00	MSFT	Stock	60.75	60.8	60.65	60.77	1822948.0
2016-11-21 15:00:00	MSFT	Stock	60.775	60.97	60.72	60.87	4013174.0
2016-11-21 16:00:00	MSFT	Stock	60.87	60.89	60.75	60.86	2802351.0
2016-11-21 17:00:00	MSFT	Stock	60.8	60.8	60.56	60.6	19867.0
2016-11-21 18:00:00	MSFT	Stock	60.61	60.61	60.61	60.61	500.0
2016-11-21 19:00:00	MSFT	Stock	60.79	60.86	60.79	60.86	2289.0
2016-11-21 04:00:00	NVDA	Stock	2.345	2.345	2.345	2.345	8000.0
2016-11-21 06:00:00	NVDA	Stock	2.3405	2.3405	2.34	2.34	21600.0
2016-11-21 07:00:00	NVDA	Stock	2.34	2.3438	2.34	2.3428	236160.0
2016-11-21 08:00:00	NVDA	Stock	2.3428	2.3532	2.3428	2.3482	1022960.0
2016-11-21 09:00:00	NVDA	Stock	2.3497	2.3588	2.323	2.3392	68808800.0
2016-11-21 10:00:00	NVDA	Stock	2.3396	2.3418	2.3158	2.3322	63659960.0
2016-11-21 11:00:00	NVDA	Stock	2.3318	2.3438	2.3205	2.341	51305800.0
2016-11-21 12:00:00	NVDA	Stock	2.341	2.3473	2.3278	2.3327	44198880.0
2016-11-21 13:00:00	NVDA	Stock	2.3322	2.3345	2.3175	2.3245	37216880.0
2016-11-21 14:00:00	NVDA	Stock	2.325	2.3262	2.31	2.3138	44182360.0
2016-11-21 15:00:00	NVDA	Stock	2.3138	2.3318	2.3128	2.3245	65879120.0
2016-11-21 16:00:00	NVDA	Stock	2.3245	2.3282	2.3192	2.3192	37327200.0
2016-11-21 17:00:00	NVDA	Stock	2.3192	2.3337	2.3192	2.331	328080.0
2016-11-21 18:00:00	NVDA	Stock	2.331	2.331	2.331	2.331	40000.0
2016-11-21 19:00:00	NVDA	Stock	2.33	2.33	2.3275	2.3275	105320.0
2016-11-21 07:00:00	AMZN	Stock	38.2	38.2485	38.194	38.194	58620.0
2016-11-21 08:00:00	AMZN	Stock	38.195	38.425	38.175	38.3425	411500.0
2016-11-21 09:00:00	AMZN	Stock	38.315	38.7475	38.2555	38.733	16010780.0
2016-11-21 10:00:00	AMZN	Stock	38.734	38.734	38.3615	38.6318	12559140.0
2016-11-21 11:00:00	AMZN	Stock	38.64	38.8025	38.615	38.787	8241760.0

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

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