PREVIEW / stock_1hour / 2017-03-31

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-03-31.parquet
  size:    1.0 MB
  rows:    48,319
  symbols: 3,076

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-03-31 04:00:00	AAPL	Stock	35.88	35.88	35.88	35.88	1908.0
2017-03-31 05:00:00	AAPL	Stock	35.8825	35.8825	35.8825	35.8825	1220.0
2017-03-31 06:00:00	AAPL	Stock	35.8775	35.9225	35.8775	35.92	13220.0
2017-03-31 07:00:00	AAPL	Stock	35.89	35.925	35.88	35.925	28556.0
2017-03-31 08:00:00	AAPL	Stock	35.9	35.975	35.9	35.95	57136.0
2017-03-31 09:00:00	AAPL	Stock	35.9475	35.975	35.7525	35.945	11399912.0
2017-03-31 10:00:00	AAPL	Stock	35.9462	36.0675	35.94	35.996	11491856.0
2017-03-31 11:00:00	AAPL	Stock	35.995	36.0422	35.95	35.96	5856072.0
2017-03-31 12:00:00	AAPL	Stock	35.9605	36.0175	35.95	36.0162	4129688.0
2017-03-31 13:00:00	AAPL	Stock	36.0175	36.03	35.9325	35.9325	4516640.0
2017-03-31 14:00:00	AAPL	Stock	35.9308	35.95	35.8775	35.9135	6862092.0
2017-03-31 15:00:00	AAPL	Stock	35.915	36.0127	35.91	35.9175	14938208.0
2017-03-31 16:00:00	AAPL	Stock	35.92	35.9565	35.9025	35.9275	12195844.0
2017-03-31 17:00:00	AAPL	Stock	35.925	35.9375	35.915	35.9225	23604.0
2017-03-31 18:00:00	AAPL	Stock	35.915	35.925	35.915	35.915	12656.0
2017-03-31 19:00:00	AAPL	Stock	35.915	35.915	35.9025	35.9025	18120.0
2017-03-31 07:00:00	MSFT	Stock	65.5	65.5	65.5	65.5	500.0
2017-03-31 08:00:00	MSFT	Stock	65.65	65.78	65.65	65.78	2765.0
2017-03-31 09:00:00	MSFT	Stock	65.71	65.75	65.45	65.66	1634026.0
2017-03-31 10:00:00	MSFT	Stock	65.665	65.81	65.65	65.76	1708739.0
2017-03-31 11:00:00	MSFT	Stock	65.764	66.0	65.75	65.96	2025221.0
2017-03-31 12:00:00	MSFT	Stock	65.96	66.09	65.95	66.075	1463713.0
2017-03-31 13:00:00	MSFT	Stock	66.08	66.19	66.02	66.02	1555389.0
2017-03-31 14:00:00	MSFT	Stock	66.02	66.03	65.87	65.91	1864704.0
2017-03-31 15:00:00	MSFT	Stock	65.911	66.155	65.85	65.87	5102191.0
2017-03-31 16:00:00	MSFT	Stock	65.84	65.97	65.84	65.96	4197605.0
2017-03-31 17:00:00	MSFT	Stock	65.88	65.93	65.88	65.93	1899.0
2017-03-31 18:00:00	MSFT	Stock	65.88	65.88	65.88	65.88	650.0
2017-03-31 19:00:00	MSFT	Stock	65.87	65.9	65.87	65.88	770.0
2017-03-31 04:00:00	NVDA	Stock	2.7325	2.7325	2.7325	2.7325	8000.0
2017-03-31 05:00:00	NVDA	Stock	2.7312	2.7312	2.7312	2.7312	76000.0
2017-03-31 06:00:00	NVDA	Stock	2.7232	2.7232	2.7188	2.7188	32440.0
2017-03-31 07:00:00	NVDA	Stock	2.72	2.7288	2.7188	2.7225	47920.0
2017-03-31 08:00:00	NVDA	Stock	2.7288	2.7438	2.7288	2.7413	1159920.0
2017-03-31 09:00:00	NVDA	Stock	2.74	2.74	2.7163	2.7205	56196720.0
2017-03-31 10:00:00	NVDA	Stock	2.72	2.7348	2.7105	2.7105	79660200.0
2017-03-31 11:00:00	NVDA	Stock	2.7105	2.725	2.7101	2.7189	39515040.0
2017-03-31 12:00:00	NVDA	Stock	2.7192	2.7293	2.7188	2.7261	27037040.0
2017-03-31 13:00:00	NVDA	Stock	2.7258	2.7473	2.7258	2.7318	53798040.0
2017-03-31 14:00:00	NVDA	Stock	2.7315	2.7338	2.7195	2.7258	57430440.0
2017-03-31 15:00:00	NVDA	Stock	2.7258	2.7338	2.7232	2.7232	70118720.0
2017-03-31 16:00:00	NVDA	Stock	2.7232	2.726	2.7225	2.725	23854000.0
2017-03-31 17:00:00	NVDA	Stock	2.7238	2.725	2.7225	2.7232	183520.0
2017-03-31 18:00:00	NVDA	Stock	2.7202	2.7202	2.7202	2.7202	50000.0
2017-03-31 19:00:00	NVDA	Stock	2.7212	2.7212	2.7175	2.7175	132640.0
2017-03-31 05:00:00	AMZN	Stock	43.756	43.756	43.756	43.756	6900.0
2017-03-31 06:00:00	AMZN	Stock	43.755	43.755	43.755	43.755	4000.0
2017-03-31 07:00:00	AMZN	Stock	43.75	43.7735	43.75	43.7735	6420.0
2017-03-31 08:00:00	AMZN	Stock	43.798	43.92	43.798	43.875	122080.0
2017-03-31 09:00:00	AMZN	Stock	43.8585	44.304	43.8325	44.1936	13974300.0

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

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