PREVIEW / stock_1hour / 2017-12-12

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-12-12.parquet
  size:    1.1 MB
  rows:    49,091
  symbols: 2,944

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-12-12 04:00:00	AAPL	Stock	43.065	43.1125	43.065	43.1125	996.0
2017-12-12 05:00:00	AAPL	Stock	43.075	43.075	43.0075	43.065	5264.0
2017-12-12 06:00:00	AAPL	Stock	43.08	43.0875	43.08	43.08	4880.0
2017-12-12 07:00:00	AAPL	Stock	43.0975	43.15	43.0975	43.1375	36676.0
2017-12-12 08:00:00	AAPL	Stock	43.1425	43.17	43.075	43.11	153428.0
2017-12-12 09:00:00	AAPL	Stock	43.0875	43.1	42.8653	42.9875	14028236.0
2017-12-12 10:00:00	AAPL	Stock	42.99	43.0425	42.9	42.985	10497056.0
2017-12-12 11:00:00	AAPL	Stock	42.985	43.0588	42.9575	42.9975	6908352.0
2017-12-12 12:00:00	AAPL	Stock	42.995	43.0475	42.915	43.005	5874276.0
2017-12-12 13:00:00	AAPL	Stock	43.0075	43.0375	42.91	42.9588	5255880.0
2017-12-12 14:00:00	AAPL	Stock	42.9575	43.0175	42.915	42.9775	5408920.0
2017-12-12 15:00:00	AAPL	Stock	42.98	43.01	42.9	42.9325	11345656.0
2017-12-12 16:00:00	AAPL	Stock	42.925	42.9375	42.8975	42.9125	8549900.0
2017-12-12 17:00:00	AAPL	Stock	42.9325	42.95	42.9125	42.945	19688.0
2017-12-12 18:00:00	AAPL	Stock	42.9375	42.9375	42.89	42.8925	34688.0
2017-12-12 19:00:00	AAPL	Stock	42.89	42.9175	42.8875	42.8875	14816.0
2017-12-12 04:00:00	MSFT	Stock	85.59	85.62	85.59	85.62	824.0
2017-12-12 07:00:00	MSFT	Stock	85.4	85.7	85.4	85.59	6018.0
2017-12-12 08:00:00	MSFT	Stock	85.55	85.65	85.45	85.5	17777.0
2017-12-12 09:00:00	MSFT	Stock	85.49	85.91	85.08	85.91	3002774.0
2017-12-12 10:00:00	MSFT	Stock	85.91	86.05	85.37	85.401	3427931.0
2017-12-12 11:00:00	MSFT	Stock	85.405	85.74	85.395	85.67	1973548.0
2017-12-12 12:00:00	MSFT	Stock	85.665	85.69	85.415	85.535	1647713.0
2017-12-12 13:00:00	MSFT	Stock	85.535	85.58	85.24	85.315	1883752.0
2017-12-12 14:00:00	MSFT	Stock	85.31	85.67	85.23	85.615	1913116.0
2017-12-12 15:00:00	MSFT	Stock	85.61	85.769	85.44	85.62	3979877.0
2017-12-12 16:00:00	MSFT	Stock	85.62	85.68	85.5	85.52	4494182.0
2017-12-12 17:00:00	MSFT	Stock	85.65	85.65	85.6	85.6	481.0
2017-12-12 18:00:00	MSFT	Stock	85.52	85.65	85.52	85.65	1450.0
2017-12-12 19:00:00	MSFT	Stock	85.65	85.65	85.57	85.57	1000.0
2017-12-12 04:00:00	NVDA	Stock	4.869	4.869	4.8642	4.8642	8000.0
2017-12-12 06:00:00	NVDA	Stock	4.851	4.851	4.8375	4.8495	128440.0
2017-12-12 07:00:00	NVDA	Stock	4.85	4.8575	4.85	4.8502	146480.0
2017-12-12 08:00:00	NVDA	Stock	4.85	4.8612	4.7688	4.8123	5054280.0
2017-12-12 09:00:00	NVDA	Stock	4.8198	4.846	4.7768	4.7962	80784160.0
2017-12-12 10:00:00	NVDA	Stock	4.7968	4.8088	4.7678	4.7968	81831520.0
2017-12-12 11:00:00	NVDA	Stock	4.797	4.8168	4.7875	4.8068	39838520.0
2017-12-12 12:00:00	NVDA	Stock	4.8076	4.822	4.7905	4.7958	30103200.0
2017-12-12 13:00:00	NVDA	Stock	4.7958	4.8048	4.7563	4.7625	38636680.0
2017-12-12 14:00:00	NVDA	Stock	4.7621	4.7862	4.7472	4.7818	42804600.0
2017-12-12 15:00:00	NVDA	Stock	4.7833	4.7875	4.761	4.7702	49900280.0
2017-12-12 16:00:00	NVDA	Stock	4.771	4.771	4.765	4.7662	3335960.0
2017-12-12 17:00:00	NVDA	Stock	4.7688	4.775	4.7658	4.771	305960.0
2017-12-12 18:00:00	NVDA	Stock	4.7748	4.778	4.7675	4.77	848600.0
2017-12-12 19:00:00	NVDA	Stock	4.771	4.771	4.7653	4.7655	325440.0
2017-12-12 04:00:00	AMZN	Stock	58.499	58.499	58.325	58.325	19420.0
2017-12-12 06:00:00	AMZN	Stock	58.4335	58.4335	58.4335	58.4335	2400.0
2017-12-12 07:00:00	AMZN	Stock	58.409	58.463	58.409	58.463	20460.0
2017-12-12 08:00:00	AMZN	Stock	58.4725	58.4835	58.395	58.413	94040.0
2017-12-12 09:00:00	AMZN	Stock	58.385	58.5495	58.225	58.5495	5432940.0

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

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