PREVIEW / stock_1hour / 2018-06-20

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-06-20.parquet
  size:    1.1 MB
  rows:    49,772
  symbols: 2,825

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-06-20 04:00:00	AAPL	Stock	46.65	46.65	46.5	46.62	1576.0
2018-06-20 05:00:00	AAPL	Stock	46.62	46.6875	46.575	46.675	15192.0
2018-06-20 06:00:00	AAPL	Stock	46.625	46.65	46.6225	46.625	4480.0
2018-06-20 07:00:00	AAPL	Stock	46.675	46.735	46.6375	46.65	209628.0
2018-06-20 08:00:00	AAPL	Stock	46.665	46.75	46.635	46.675	381096.0
2018-06-20 09:00:00	AAPL	Stock	46.685	46.7425	46.525	46.686	11667156.0
2018-06-20 10:00:00	AAPL	Stock	46.685	46.7175	46.4325	46.5928	10975640.0
2018-06-20 11:00:00	AAPL	Stock	46.595	46.6275	46.455	46.5012	6748008.0
2018-06-20 12:00:00	AAPL	Stock	46.5025	46.74	46.488	46.7112	7391832.0
2018-06-20 13:00:00	AAPL	Stock	46.71	46.8	46.6475	46.7775	6033052.0
2018-06-20 14:00:00	AAPL	Stock	46.7812	46.7825	46.5792	46.6038	6478060.0
2018-06-20 15:00:00	AAPL	Stock	46.605	46.7275	46.575	46.625	11335380.0
2018-06-20 16:00:00	AAPL	Stock	46.6188	46.645	46.6075	46.6375	12577720.0
2018-06-20 17:00:00	AAPL	Stock	46.6375	46.8	46.615	46.8	182580.0
2018-06-20 18:00:00	AAPL	Stock	46.8	46.9375	46.755	46.935	386100.0
2018-06-20 19:00:00	AAPL	Stock	46.9375	46.95	46.8775	46.8775	48088.0
2018-06-20 04:00:00	MSFT	Stock	101.3	101.3	101.08	101.08	460.0
2018-06-20 05:00:00	MSFT	Stock	101.23	101.39	101.23	101.39	400.0
2018-06-20 06:00:00	MSFT	Stock	101.39	101.39	101.23	101.23	1350.0
2018-06-20 07:00:00	MSFT	Stock	101.2	101.2	100.98	101.11	8006.0
2018-06-20 08:00:00	MSFT	Stock	101.23	101.32	101.05	101.24	15796.0
2018-06-20 09:00:00	MSFT	Stock	101.3	101.84	101.12	101.77	3361992.0
2018-06-20 10:00:00	MSFT	Stock	101.77	101.97	101.35	101.733	3659840.0
2018-06-20 11:00:00	MSFT	Stock	101.74	101.92	101.514	101.915	2257664.0
2018-06-20 12:00:00	MSFT	Stock	101.92	102.41	101.9	102.24	2408802.0
2018-06-20 13:00:00	MSFT	Stock	102.235	102.345	101.975	102.345	1412804.0
2018-06-20 14:00:00	MSFT	Stock	102.34	102.52	101.75	101.825	2689447.0
2018-06-20 15:00:00	MSFT	Stock	101.825	102.04	101.69	101.95	4207977.0
2018-06-20 16:00:00	MSFT	Stock	101.87	102.0	101.81	101.9	3534562.0
2018-06-20 17:00:00	MSFT	Stock	101.9	102.0	101.9	101.91	1782.0
2018-06-20 18:00:00	MSFT	Stock	102.0	102.0	101.9	102.0	300.0
2018-06-20 19:00:00	MSFT	Stock	102.0	102.07	102.0	102.07	1322.0
2018-06-20 04:00:00	NVDA	Stock	6.5425	6.55	6.5425	6.5425	34160.0
2018-06-20 05:00:00	NVDA	Stock	6.5425	6.5655	6.5425	6.5655	30920.0
2018-06-20 07:00:00	NVDA	Stock	6.5495	6.5498	6.5325	6.5475	519680.0
2018-06-20 08:00:00	NVDA	Stock	6.545	6.573	6.5372	6.57	2625160.0
2018-06-20 09:00:00	NVDA	Stock	6.5713	6.575	6.5165	6.5309	60669880.0
2018-06-20 10:00:00	NVDA	Stock	6.5312	6.5895	6.507	6.5766	84217880.0
2018-06-20 11:00:00	NVDA	Stock	6.5782	6.6015	6.5562	6.6015	39317360.0
2018-06-20 12:00:00	NVDA	Stock	6.6018	6.6112	6.5798	6.5798	34490160.0
2018-06-20 13:00:00	NVDA	Stock	6.5794	6.583	6.5598	6.5779	27863400.0
2018-06-20 14:00:00	NVDA	Stock	6.5776	6.5776	6.555	6.56	19421080.0
2018-06-20 15:00:00	NVDA	Stock	6.56	6.5735	6.5452	6.5572	47969840.0
2018-06-20 16:00:00	NVDA	Stock	6.5578	6.565	6.5498	6.5582	9649440.0
2018-06-20 17:00:00	NVDA	Stock	6.5558	6.575	6.5558	6.5718	2937080.0
2018-06-20 18:00:00	NVDA	Stock	6.5678	6.57	6.567	6.5675	71280.0
2018-06-20 19:00:00	NVDA	Stock	6.5675	6.57	6.5652	6.57	312720.0
2018-06-20 04:00:00	AMZN	Stock	87.15	87.22	87.15	87.22	19140.0
2018-06-20 05:00:00	AMZN	Stock	87.25	87.35	87.25	87.35	8000.0
2018-06-20 06:00:00	AMZN	Stock	87.3	87.3	87.175	87.175	23280.0

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

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