PREVIEW / stock_1hour / 2020-06-01

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-06-01.parquet
  size:    1.2 MB
  rows:    56,582
  symbols: 2,380

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
2020-06-01 04:00:00	AAPL	Stock	79.75	79.75	78.575	79.125	59080.0
2020-06-01 05:00:00	AAPL	Stock	79.0875	79.25	78.95	79.0	14280.0
2020-06-01 06:00:00	AAPL	Stock	79.0	79.3725	78.95	79.2775	14404.0
2020-06-01 07:00:00	AAPL	Stock	79.35	79.625	79.3025	79.375	226676.0
2020-06-01 08:00:00	AAPL	Stock	79.55	79.625	79.125	79.2875	451072.0
2020-06-01 09:00:00	AAPL	Stock	79.28	80.1225	79.13	80.04	11201476.0
2020-06-01 10:00:00	AAPL	Stock	80.0475	80.4275	79.9625	80.185	14439224.0
2020-06-01 11:00:00	AAPL	Stock	80.1875	80.215	79.925	80.1725	6443856.0
2020-06-01 12:00:00	AAPL	Stock	80.175	80.2977	80.0625	80.225	5269988.0
2020-06-01 13:00:00	AAPL	Stock	80.2275	80.5875	80.225	80.4925	7223880.0
2020-06-01 14:00:00	AAPL	Stock	80.4925	80.5658	80.345	80.5575	5571140.0
2020-06-01 15:00:00	AAPL	Stock	80.565	80.5875	80.3275	80.44	10137152.0
2020-06-01 16:00:00	AAPL	Stock	80.4625	80.5	80.2255	80.5	3067460.0
2020-06-01 17:00:00	AAPL	Stock	80.5	80.5225	80.475	80.5125	34544.0
2020-06-01 18:00:00	AAPL	Stock	80.51	80.51	80.2525	80.2775	84856.0
2020-06-01 19:00:00	AAPL	Stock	80.2525	80.27	80.005	80.1875	114468.0
2020-06-01 04:00:00	MSFT	Stock	183.69	183.69	181.35	182.01	1622.0
2020-06-01 05:00:00	MSFT	Stock	182.5	182.55	182.22	182.22	2058.0
2020-06-01 06:00:00	MSFT	Stock	182.05	182.57	182.03	182.57	1226.0
2020-06-01 07:00:00	MSFT	Stock	182.28	183.08	182.28	182.77	20309.0
2020-06-01 08:00:00	MSFT	Stock	182.85	183.7	182.27	182.49	43305.0
2020-06-01 09:00:00	MSFT	Stock	182.45	182.79	181.46	182.45	3407999.0
2020-06-01 10:00:00	MSFT	Stock	182.5	182.92	181.75	182.325	3527273.0
2020-06-01 11:00:00	MSFT	Stock	182.33	182.42	181.78	182.35	2228985.0
2020-06-01 12:00:00	MSFT	Stock	182.35	183.0	182.071	182.69	1582412.0
2020-06-01 13:00:00	MSFT	Stock	182.7	183.0	182.3	182.44	1412300.0
2020-06-01 14:00:00	MSFT	Stock	182.45	182.65	182.18	182.47	1482628.0
2020-06-01 15:00:00	MSFT	Stock	182.48	182.9	181.8	182.86	3501602.0
2020-06-01 16:00:00	MSFT	Stock	182.86	182.9	182.6	182.85	2022937.0
2020-06-01 17:00:00	MSFT	Stock	182.91	182.91	182.83	182.83	6662.0
2020-06-01 18:00:00	MSFT	Stock	182.83	182.85	182.3	182.3	12120.0
2020-06-01 19:00:00	MSFT	Stock	182.3	182.45	182.07	182.11	26950.0
2020-06-01 04:00:00	NVDA	Stock	8.8875	8.8875	8.775	8.795	99160.0
2020-06-01 05:00:00	NVDA	Stock	8.825	8.825	8.825	8.825	8320.0
2020-06-01 06:00:00	NVDA	Stock	8.803	8.803	8.8	8.8	24840.0
2020-06-01 07:00:00	NVDA	Stock	8.8198	8.8463	8.8	8.812	1275920.0
2020-06-01 08:00:00	NVDA	Stock	8.8188	8.8494	8.7763	8.8062	2623000.0
2020-06-01 09:00:00	NVDA	Stock	8.8055	8.8408	8.6895	8.7548	79887400.0
2020-06-01 10:00:00	NVDA	Stock	8.7548	8.8175	8.732	8.7642	67718840.0
2020-06-01 11:00:00	NVDA	Stock	8.7618	8.7745	8.7078	8.7468	54470000.0
2020-06-01 12:00:00	NVDA	Stock	8.7457	8.7998	8.7343	8.7722	31365840.0
2020-06-01 13:00:00	NVDA	Stock	8.7718	8.8145	8.7718	8.8073	26609280.0
2020-06-01 14:00:00	NVDA	Stock	8.809	8.8365	8.7665	8.7744	35475200.0
2020-06-01 15:00:00	NVDA	Stock	8.775	8.8208	8.7635	8.8105	46841520.0
2020-06-01 16:00:00	NVDA	Stock	8.8062	8.8062	8.79	8.8	1964560.0
2020-06-01 17:00:00	NVDA	Stock	8.8	8.8022	8.7938	8.7938	135200.0
2020-06-01 18:00:00	NVDA	Stock	8.7968	8.8	8.7855	8.7925	106080.0
2020-06-01 19:00:00	NVDA	Stock	8.78	8.7838	8.7375	8.75	376080.0
2020-06-01 05:00:00	AMZN	Stock	121.75	121.75	121.75	121.75	2000.0
2020-06-01 06:00:00	AMZN	Stock	121.84	122.0	121.84	122.0	29680.0

> showing 50 of 56,582 rows — these rows as CSV

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