PREVIEW / stock_1hour / 2018-06-26

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-06-26.parquet
  size:    1.1 MB
  rows:    48,837
  symbols: 2,823

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-26 04:00:00	AAPL	Stock	45.825	45.825	45.775	45.775	4480.0
2018-06-26 05:00:00	AAPL	Stock	45.725	45.755	45.695	45.6975	25124.0
2018-06-26 06:00:00	AAPL	Stock	45.755	45.755	45.655	45.7125	23952.0
2018-06-26 07:00:00	AAPL	Stock	45.6875	45.75	45.635	45.6725	65832.0
2018-06-26 08:00:00	AAPL	Stock	45.75	45.9	45.6375	45.805	300616.0
2018-06-26 09:00:00	AAPL	Stock	45.8225	46.14	45.635	46.095	13240492.0
2018-06-26 10:00:00	AAPL	Stock	46.095	46.2575	46.03	46.2025	15710308.0
2018-06-26 11:00:00	AAPL	Stock	46.2	46.305	46.115	46.2075	8176624.0
2018-06-26 12:00:00	AAPL	Stock	46.203	46.3725	46.1975	46.35	6683856.0
2018-06-26 13:00:00	AAPL	Stock	46.355	46.6175	46.335	46.6088	8523224.0
2018-06-26 14:00:00	AAPL	Stock	46.61	46.6325	46.3375	46.355	7274908.0
2018-06-26 15:00:00	AAPL	Stock	46.35	46.38	46.0	46.11	15911840.0
2018-06-26 16:00:00	AAPL	Stock	46.1075	46.269	46.0825	46.095	10539312.0
2018-06-26 17:00:00	AAPL	Stock	46.08	46.0975	46.075	46.075	33672.0
2018-06-26 18:00:00	AAPL	Stock	46.0725	46.125	46.0725	46.0875	26332.0
2018-06-26 19:00:00	AAPL	Stock	46.1125	46.1425	46.0775	46.1425	88508.0
2018-06-26 04:00:00	MSFT	Stock	98.6	98.85	98.6	98.85	992.0
2018-06-26 05:00:00	MSFT	Stock	98.65	98.65	98.65	98.65	1997.0
2018-06-26 07:00:00	MSFT	Stock	98.82	98.99	98.75	98.75	10052.0
2018-06-26 08:00:00	MSFT	Stock	98.75	99.5	98.7	99.1	47074.0
2018-06-26 09:00:00	MSFT	Stock	99.09	99.79	98.75	99.47	3509028.0
2018-06-26 10:00:00	MSFT	Stock	99.48	99.8	99.05	99.41	3617159.0
2018-06-26 11:00:00	MSFT	Stock	99.41	99.61	99.21	99.44	2097725.0
2018-06-26 12:00:00	MSFT	Stock	99.436	99.92	99.42	99.85	2077788.0
2018-06-26 13:00:00	MSFT	Stock	99.86	100.08	99.78	99.815	2017919.0
2018-06-26 14:00:00	MSFT	Stock	99.815	99.88	99.43	99.48	1857097.0
2018-06-26 15:00:00	MSFT	Stock	99.48	99.605	99.0	99.07	4316332.0
2018-06-26 16:00:00	MSFT	Stock	99.08	99.38	99.08	99.19	4522704.0
2018-06-26 17:00:00	MSFT	Stock	99.08	99.25	99.08	99.2	559.0
2018-06-26 18:00:00	MSFT	Stock	99.21	99.21	99.02	99.1	8490.0
2018-06-26 19:00:00	MSFT	Stock	99.1	99.18	99.06	99.18	5548.0
2018-06-26 04:00:00	NVDA	Stock	6.0285	6.0572	6.025	6.05	116600.0
2018-06-26 05:00:00	NVDA	Stock	6.0383	6.0383	6.0322	6.0325	74200.0
2018-06-26 06:00:00	NVDA	Stock	6.035	6.0443	6.0165	6.0365	121640.0
2018-06-26 07:00:00	NVDA	Stock	6.0375	6.0562	6.035	6.0488	955800.0
2018-06-26 08:00:00	NVDA	Stock	6.0475	6.0718	6.0375	6.0712	1876360.0
2018-06-26 09:00:00	NVDA	Stock	6.0742	6.1412	6.0548	6.0718	78470280.0
2018-06-26 10:00:00	NVDA	Stock	6.0738	6.1098	6.0138	6.0165	67997560.0
2018-06-26 11:00:00	NVDA	Stock	6.0153	6.049	5.9978	6.042	44703280.0
2018-06-26 12:00:00	NVDA	Stock	6.0413	6.0668	6.0318	6.052	35350040.0
2018-06-26 13:00:00	NVDA	Stock	6.0535	6.0963	6.0513	6.0811	31022760.0
2018-06-26 14:00:00	NVDA	Stock	6.0816	6.0843	6.0583	6.0595	17226440.0
2018-06-26 15:00:00	NVDA	Stock	6.0588	6.0875	6.0329	6.0493	53175120.0
2018-06-26 16:00:00	NVDA	Stock	6.0498	6.0593	6.0498	6.0505	18590480.0
2018-06-26 17:00:00	NVDA	Stock	6.0513	6.0828	6.0513	6.0625	227760.0
2018-06-26 18:00:00	NVDA	Stock	6.058	6.0725	6.058	6.07	169320.0
2018-06-26 19:00:00	NVDA	Stock	6.068	6.08	6.0498	6.0738	249280.0
2018-06-26 04:00:00	AMZN	Stock	83.4	83.723	83.375	83.723	24500.0
2018-06-26 05:00:00	AMZN	Stock	83.836	83.9	83.7	83.7	31220.0
2018-06-26 06:00:00	AMZN	Stock	83.655	83.68	83.5385	83.6625	41680.0

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

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