PREVIEW / stock_1hour / 2018-02-08

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-02-08.parquet
  size:    1.1 MB
  rows:    50,060
  symbols: 2,880

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
2018-02-08 04:00:00	AAPL	Stock	39.95	39.9775	39.8875	39.9225	51876.0
2018-02-08 05:00:00	AAPL	Stock	39.8725	39.875	39.825	39.825	36408.0
2018-02-08 06:00:00	AAPL	Stock	39.815	39.875	39.725	39.775	88560.0
2018-02-08 07:00:00	AAPL	Stock	39.775	40.115	39.7725	40.025	262320.0
2018-02-08 08:00:00	AAPL	Stock	40.0375	40.2	39.7775	40.1825	568244.0
2018-02-08 09:00:00	AAPL	Stock	40.18	40.25	39.9075	40.04	18768528.0
2018-02-08 10:00:00	AAPL	Stock	40.04	40.2225	39.8925	40.0225	25234688.0
2018-02-08 11:00:00	AAPL	Stock	40.0225	40.25	39.87	40.1025	27993152.0
2018-02-08 12:00:00	AAPL	Stock	40.1025	40.1375	39.465	39.6975	26051148.0
2018-02-08 13:00:00	AAPL	Stock	39.6922	40.0675	39.605	39.9618	21302732.0
2018-02-08 14:00:00	AAPL	Stock	39.96	40.03	39.6175	39.7125	15699340.0
2018-02-08 15:00:00	AAPL	Stock	39.72	39.8458	38.7575	38.79	39450312.0
2018-02-08 16:00:00	AAPL	Stock	38.7875	39.235	38.7875	39.0825	14581856.0
2018-02-08 17:00:00	AAPL	Stock	39.0425	39.2225	38.7875	39.1125	497508.0
2018-02-08 18:00:00	AAPL	Stock	39.1125	39.1625	38.85	38.8875	316940.0
2018-02-08 19:00:00	AAPL	Stock	38.8875	39.1125	38.8775	39.0625	159196.0
2018-02-08 04:00:00	MSFT	Stock	89.47	89.47	89.47	89.47	100.0
2018-02-08 05:00:00	MSFT	Stock	89.32	89.32	89.32	89.32	600.0
2018-02-08 06:00:00	MSFT	Stock	89.41	89.41	89.01	89.1	1738.0
2018-02-08 07:00:00	MSFT	Stock	89.43	89.8	89.1	89.75	22818.0
2018-02-08 08:00:00	MSFT	Stock	89.3	90.5	89.3	89.95	61475.0
2018-02-08 09:00:00	MSFT	Stock	90.1	90.2	88.72	89.11	4081252.0
2018-02-08 10:00:00	MSFT	Stock	89.12	89.52	87.81	88.12	4693893.0
2018-02-08 11:00:00	MSFT	Stock	88.11	88.76	87.65	88.37	5056512.0
2018-02-08 12:00:00	MSFT	Stock	88.37	88.59	86.53	86.95	6317432.0
2018-02-08 13:00:00	MSFT	Stock	86.94	87.87	86.58	87.62	6341966.0
2018-02-08 14:00:00	MSFT	Stock	87.62	87.86	86.55	86.842	5017383.0
2018-02-08 15:00:00	MSFT	Stock	86.85	87.18	84.76	84.99	11740719.0
2018-02-08 16:00:00	MSFT	Stock	85.01	85.9	84.95	85.53	6738480.0
2018-02-08 17:00:00	MSFT	Stock	85.55	86.1	85.5	86.0	39735.0
2018-02-08 18:00:00	MSFT	Stock	86.0	86.01	85.65	85.65	40636.0
2018-02-08 19:00:00	MSFT	Stock	85.8	86.1	85.7	86.0	12815.0
2018-02-08 04:00:00	NVDA	Stock	5.7375	5.75	5.7375	5.75	22400.0
2018-02-08 05:00:00	NVDA	Stock	5.75	5.75	5.7262	5.7262	32000.0
2018-02-08 06:00:00	NVDA	Stock	5.736	5.8	5.736	5.7632	179160.0
2018-02-08 07:00:00	NVDA	Stock	5.7733	5.837	5.75	5.825	1455800.0
2018-02-08 08:00:00	NVDA	Stock	5.82	5.8618	5.736	5.84	3358280.0
2018-02-08 09:00:00	NVDA	Stock	5.84	5.8805	5.7688	5.8028	110354440.0
2018-02-08 10:00:00	NVDA	Stock	5.802	5.85	5.5542	5.6355	124584200.0
2018-02-08 11:00:00	NVDA	Stock	5.63	5.6962	5.5415	5.6432	113520240.0
2018-02-08 12:00:00	NVDA	Stock	5.6443	5.6583	5.5325	5.5565	86056880.0
2018-02-08 13:00:00	NVDA	Stock	5.5583	5.6838	5.5303	5.664	88435520.0
2018-02-08 14:00:00	NVDA	Stock	5.6608	5.666	5.55	5.5772	60175200.0
2018-02-08 15:00:00	NVDA	Stock	5.5792	5.6128	5.4378	5.4432	159525080.0
2018-02-08 16:00:00	NVDA	Stock	5.4412	6.1095	5.438	6.0312	145187880.0
2018-02-08 17:00:00	NVDA	Stock	6.0413	6.2185	5.9468	5.9593	67343920.0
2018-02-08 18:00:00	NVDA	Stock	5.9593	5.9612	5.7938	5.8253	19690000.0
2018-02-08 19:00:00	NVDA	Stock	5.8322	5.8875	5.825	5.8475	9806960.0
2018-02-08 04:00:00	AMZN	Stock	71.155	71.155	71.05	71.05	10000.0
2018-02-08 05:00:00	AMZN	Stock	71.065	71.341	70.916	71.341	28600.0

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

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