PREVIEW / stock_1hour / 2019-04-16

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-04-16.parquet
  size:    1.1 MB
  rows:    49,803
  symbols: 2,624

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
2019-04-16 04:00:00	AAPL	Stock	49.8975	50.0175	49.8475	50.0175	11416.0
2019-04-16 05:00:00	AAPL	Stock	50.0225	50.025	50.0225	50.025	872.0
2019-04-16 06:00:00	AAPL	Stock	49.975	49.975	49.9675	49.9675	5300.0
2019-04-16 07:00:00	AAPL	Stock	49.9275	49.9875	49.915	49.9875	93364.0
2019-04-16 08:00:00	AAPL	Stock	49.97	50.0125	49.915	49.97	190140.0
2019-04-16 09:00:00	AAPL	Stock	49.9675	50.01	49.7525	49.9655	10509000.0
2019-04-16 10:00:00	AAPL	Stock	49.9675	50.3425	49.91	50.1625	20329880.0
2019-04-16 11:00:00	AAPL	Stock	50.1675	50.1825	49.945	49.98	9359940.0
2019-04-16 12:00:00	AAPL	Stock	49.9775	50.0225	49.8975	49.99	5642312.0
2019-04-16 13:00:00	AAPL	Stock	49.99	50.01	49.8388	49.93	6077016.0
2019-04-16 14:00:00	AAPL	Stock	49.93	49.9625	49.64	49.94	10175912.0
2019-04-16 15:00:00	AAPL	Stock	49.935	50.1325	49.693	49.8125	24670712.0
2019-04-16 16:00:00	AAPL	Stock	49.8125	49.8875	49.66	49.725	4761700.0
2019-04-16 17:00:00	AAPL	Stock	49.7425	49.85	49.7425	49.8	56124.0
2019-04-16 18:00:00	AAPL	Stock	49.775	49.8	49.7	49.77	28000.0
2019-04-16 19:00:00	AAPL	Stock	49.7325	49.775	49.6775	49.6825	30800.0
2019-04-16 04:00:00	MSFT	Stock	121.58	121.58	121.58	121.58	109.0
2019-04-16 05:00:00	MSFT	Stock	121.5	121.5	121.5	121.5	2002.0
2019-04-16 06:00:00	MSFT	Stock	121.5	121.5	121.5	121.5	632.0
2019-04-16 07:00:00	MSFT	Stock	121.69	121.8	121.65	121.8	24682.0
2019-04-16 08:00:00	MSFT	Stock	121.73	121.83	121.56	121.75	21867.0
2019-04-16 09:00:00	MSFT	Stock	121.652	121.75	120.94	121.26	1994275.0
2019-04-16 10:00:00	MSFT	Stock	121.25	121.54	121.015	121.148	1835169.0
2019-04-16 11:00:00	MSFT	Stock	121.15	121.315	121.01	121.12	1334902.0
2019-04-16 12:00:00	MSFT	Stock	121.12	121.2	120.97	121.18	1068890.0
2019-04-16 13:00:00	MSFT	Stock	121.175	121.22	121.04	121.12	708604.0
2019-04-16 14:00:00	MSFT	Stock	121.11	121.16	120.98	121.01	1094910.0
2019-04-16 15:00:00	MSFT	Stock	121.01	121.06	120.1	120.79	2758420.0
2019-04-16 16:00:00	MSFT	Stock	120.77	120.8	120.549	120.67	1749171.0
2019-04-16 17:00:00	MSFT	Stock	120.7	120.75	120.65	120.75	4530.0
2019-04-16 18:00:00	MSFT	Stock	120.66	120.66	120.61	120.64	2441.0
2019-04-16 19:00:00	MSFT	Stock	120.7	120.7	120.15	120.41	8694.0
2019-04-16 04:00:00	NVDA	Stock	4.6475	4.65	4.6475	4.65	24280.0
2019-04-16 05:00:00	NVDA	Stock	4.6548	4.6548	4.6548	4.6548	4000.0
2019-04-16 06:00:00	NVDA	Stock	4.657	4.66	4.657	4.6588	24880.0
2019-04-16 07:00:00	NVDA	Stock	4.656	4.659	4.645	4.6495	266480.0
2019-04-16 08:00:00	NVDA	Stock	4.6475	4.6678	4.629	4.6672	2277160.0
2019-04-16 09:00:00	NVDA	Stock	4.6667	4.6675	4.6241	4.665	62020320.0
2019-04-16 10:00:00	NVDA	Stock	4.6652	4.7095	4.6642	4.685	67609480.0
2019-04-16 11:00:00	NVDA	Stock	4.685	4.6938	4.664	4.678	37532120.0
2019-04-16 12:00:00	NVDA	Stock	4.6778	4.6962	4.6778	4.692	24732640.0
2019-04-16 13:00:00	NVDA	Stock	4.6915	4.7045	4.6868	4.697	22536440.0
2019-04-16 14:00:00	NVDA	Stock	4.6968	4.713	4.6908	4.7125	26031800.0
2019-04-16 15:00:00	NVDA	Stock	4.7115	4.7243	4.6865	4.707	73290240.0
2019-04-16 16:00:00	NVDA	Stock	4.7053	4.7053	4.687	4.6975	27971120.0
2019-04-16 17:00:00	NVDA	Stock	4.7	4.7053	4.6975	4.7038	754440.0
2019-04-16 18:00:00	NVDA	Stock	4.6962	4.7038	4.6962	4.7013	192960.0
2019-04-16 19:00:00	NVDA	Stock	4.697	4.703	4.6962	4.701	205680.0
2019-04-16 04:00:00	AMZN	Stock	92.544	92.682	92.5005	92.682	8000.0
2019-04-16 05:00:00	AMZN	Stock	92.6835	92.6835	92.6835	92.6835	4000.0

> showing 50 of 49,803 rows — these rows as CSV

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