PREVIEW / stock_1hour / 2019-02-28

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-02-28.parquet
  size:    1.1 MB
  rows:    50,234
  symbols: 2,666

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-02-28 04:00:00	AAPL	Stock	43.5625	43.5625	43.43	43.5025	7448.0
2019-02-28 05:00:00	AAPL	Stock	43.5075	43.5075	43.5	43.5	1900.0
2019-02-28 06:00:00	AAPL	Stock	43.5575	43.5875	43.5575	43.565	17952.0
2019-02-28 07:00:00	AAPL	Stock	43.62	43.6525	43.5625	43.6525	41188.0
2019-02-28 08:00:00	AAPL	Stock	43.6125	43.6875	43.575	43.6125	123368.0
2019-02-28 09:00:00	AAPL	Stock	43.62	43.7275	43.4875	43.5725	9942948.0
2019-02-28 10:00:00	AAPL	Stock	43.5712	43.5712	43.3975	43.43	11953036.0
2019-02-28 11:00:00	AAPL	Stock	43.4275	43.605	43.35	43.5425	7287488.0
2019-02-28 12:00:00	AAPL	Stock	43.545	43.5925	43.455	43.5725	5027052.0
2019-02-28 13:00:00	AAPL	Stock	43.57	43.5825	43.5125	43.555	3949668.0
2019-02-28 14:00:00	AAPL	Stock	43.555	43.5875	43.4775	43.5275	5736192.0
2019-02-28 15:00:00	AAPL	Stock	43.5262	43.5425	43.23	43.3	17310128.0
2019-02-28 16:00:00	AAPL	Stock	43.2875	43.3475	43.2775	43.3125	29841860.0
2019-02-28 17:00:00	AAPL	Stock	43.3125	43.325	43.2875	43.31	64236.0
2019-02-28 18:00:00	AAPL	Stock	43.32	43.32	43.27	43.2875	24816.0
2019-02-28 19:00:00	AAPL	Stock	43.3175	43.3675	43.3125	43.36	37448.0
2019-02-28 04:00:00	MSFT	Stock	111.99	111.99	111.85	111.85	3500.0
2019-02-28 05:00:00	MSFT	Stock	111.89	111.89	111.89	111.89	200.0
2019-02-28 06:00:00	MSFT	Stock	111.77	111.77	111.77	111.77	100.0
2019-02-28 07:00:00	MSFT	Stock	111.85	112.1	111.83	112.01	3375.0
2019-02-28 08:00:00	MSFT	Stock	111.95	112.236	111.8	112.02	13693.0
2019-02-28 09:00:00	MSFT	Stock	112.02	112.88	111.93	112.39	2538068.0
2019-02-28 10:00:00	MSFT	Stock	112.38	112.42	111.91	112.03	2595331.0
2019-02-28 11:00:00	MSFT	Stock	112.035	112.45	111.835	112.31	1683747.0
2019-02-28 12:00:00	MSFT	Stock	112.319	112.61	112.21	112.6	4197827.0
2019-02-28 13:00:00	MSFT	Stock	112.6	112.62	112.38	112.42	1420519.0
2019-02-28 14:00:00	MSFT	Stock	112.415	112.53	112.17	112.28	1378625.0
2019-02-28 15:00:00	MSFT	Stock	112.29	112.41	111.73	112.05	4519550.0
2019-02-28 16:00:00	MSFT	Stock	112.03	112.22	111.8	112.07	6819350.0
2019-02-28 17:00:00	MSFT	Stock	112.1	112.1	111.99	112.1	16812.0
2019-02-28 18:00:00	MSFT	Stock	112.1	112.1	112.0	112.08	3335.0
2019-02-28 19:00:00	MSFT	Stock	112.08	112.24	112.08	112.24	2490.0
2019-02-28 05:00:00	NVDA	Stock	3.8712	3.8712	3.8712	3.8712	8000.0
2019-02-28 06:00:00	NVDA	Stock	3.8628	3.8628	3.8628	3.8628	4000.0
2019-02-28 07:00:00	NVDA	Stock	3.877	3.8812	3.8695	3.875	274800.0
2019-02-28 08:00:00	NVDA	Stock	3.8763	3.8908	3.8675	3.8712	960960.0
2019-02-28 09:00:00	NVDA	Stock	3.8725	3.8975	3.8525	3.876	48537240.0
2019-02-28 10:00:00	NVDA	Stock	3.875	3.8775	3.834	3.8593	59134640.0
2019-02-28 11:00:00	NVDA	Stock	3.8588	3.884	3.8532	3.8798	41234920.0
2019-02-28 12:00:00	NVDA	Stock	3.8795	3.894	3.8632	3.867	31343560.0
2019-02-28 13:00:00	NVDA	Stock	3.8675	3.878	3.8612	3.8647	19846400.0
2019-02-28 14:00:00	NVDA	Stock	3.8653	3.8658	3.847	3.86	30498560.0
2019-02-28 15:00:00	NVDA	Stock	3.8603	3.864	3.8462	3.8572	49122200.0
2019-02-28 16:00:00	NVDA	Stock	3.857	3.8635	3.855	3.858	5847600.0
2019-02-28 17:00:00	NVDA	Stock	3.858	3.86	3.85	3.8562	265200.0
2019-02-28 18:00:00	NVDA	Stock	3.8595	3.861	3.8538	3.8562	114520.0
2019-02-28 19:00:00	NVDA	Stock	3.8562	3.865	3.8562	3.865	127080.0
2019-02-28 04:00:00	AMZN	Stock	81.7	81.7	81.7	81.7	8500.0
2019-02-28 05:00:00	AMZN	Stock	81.722	81.722	81.6875	81.6875	10420.0
2019-02-28 06:00:00	AMZN	Stock	81.795	81.795	81.795	81.795	9800.0

> showing 50 of 50,234 rows — these rows as CSV

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