PREVIEW / stock_1hour / 2020-02-19

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-02-19.parquet
  size:    1.2 MB
  rows:    51,722
  symbols: 2,443

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-02-19 04:00:00	AAPL	Stock	80.0375	80.2475	80.0375	80.075	35832.0
2020-02-19 05:00:00	AAPL	Stock	80.1375	80.3375	80.1375	80.2	19808.0
2020-02-19 06:00:00	AAPL	Stock	80.175	80.175	80.0125	80.1475	27732.0
2020-02-19 07:00:00	AAPL	Stock	80.1125	80.32	80.1	80.32	173752.0
2020-02-19 08:00:00	AAPL	Stock	80.1475	80.3325	80.075	80.105	575996.0
2020-02-19 09:00:00	AAPL	Stock	80.105	80.745	79.75	80.6775	15505660.0
2020-02-19 10:00:00	AAPL	Stock	80.6775	80.9062	80.485	80.8908	12235440.0
2020-02-19 11:00:00	AAPL	Stock	80.8975	81.1425	80.8775	80.99	9347060.0
2020-02-19 12:00:00	AAPL	Stock	80.9875	81.14	80.9	81.102	5664940.0
2020-02-19 13:00:00	AAPL	Stock	81.105	81.11	80.8875	80.9842	4269652.0
2020-02-19 14:00:00	AAPL	Stock	80.9822	81.075	80.9125	80.998	4435288.0
2020-02-19 15:00:00	AAPL	Stock	81.0	81.0425	80.73	80.905	11071520.0
2020-02-19 16:00:00	AAPL	Stock	80.905	80.965	80.815	80.85	11760784.0
2020-02-19 17:00:00	AAPL	Stock	80.87	80.92	80.8275	80.9125	94320.0
2020-02-19 18:00:00	AAPL	Stock	80.92	80.9675	80.8775	80.965	46556.0
2020-02-19 19:00:00	AAPL	Stock	80.9825	81.12	80.975	81.055	117160.0
2020-02-19 04:00:00	MSFT	Stock	186.76	187.64	186.76	187.64	13115.0
2020-02-19 05:00:00	MSFT	Stock	187.68	187.8	187.53	187.53	15853.0
2020-02-19 06:00:00	MSFT	Stock	187.55	187.65	187.39	187.5	3341.0
2020-02-19 07:00:00	MSFT	Stock	187.62	187.75	187.5	187.75	45956.0
2020-02-19 08:00:00	MSFT	Stock	187.57	187.99	187.5	187.74	119462.0
2020-02-19 09:00:00	MSFT	Stock	187.84	188.24	186.47	187.36	3877366.0
2020-02-19 10:00:00	MSFT	Stock	187.35	187.505	186.67	187.035	3047224.0
2020-02-19 11:00:00	MSFT	Stock	187.04	187.66	186.94	187.252	2430594.0
2020-02-19 12:00:00	MSFT	Stock	187.254	187.44	186.955	187.33	1396712.0
2020-02-19 13:00:00	MSFT	Stock	187.33	187.466	187.22	187.39	1033648.0
2020-02-19 14:00:00	MSFT	Stock	187.381	187.67	187.23	187.45	1284254.0
2020-02-19 15:00:00	MSFT	Stock	187.46	187.74	186.9	187.28	3198149.0
2020-02-19 16:00:00	MSFT	Stock	187.28	187.39	187.1	187.28	6401512.0
2020-02-19 17:00:00	MSFT	Stock	187.28	187.39	187.05	187.36	15561.0
2020-02-19 18:00:00	MSFT	Stock	187.36	187.49	187.28	187.48	83960.0
2020-02-19 19:00:00	MSFT	Stock	187.5	187.85	187.5	187.74	22524.0
2020-02-19 04:00:00	NVDA	Stock	7.4892	7.5375	7.4875	7.5062	600600.0
2020-02-19 05:00:00	NVDA	Stock	7.5128	7.53	7.5128	7.5165	228480.0
2020-02-19 06:00:00	NVDA	Stock	7.515	7.5175	7.5108	7.515	126760.0
2020-02-19 07:00:00	NVDA	Stock	7.5082	7.5395	7.5025	7.535	2193560.0
2020-02-19 08:00:00	NVDA	Stock	7.5348	7.5475	7.3958	7.5438	3935720.0
2020-02-19 09:00:00	NVDA	Stock	7.543	7.7644	7.4142	7.752	182097840.0
2020-02-19 10:00:00	NVDA	Stock	7.754	7.795	7.7002	7.735	103359920.0
2020-02-19 11:00:00	NVDA	Stock	7.7345	7.7928	7.7325	7.7838	51308200.0
2020-02-19 12:00:00	NVDA	Stock	7.7838	7.8318	7.7775	7.8202	68304160.0
2020-02-19 13:00:00	NVDA	Stock	7.8195	7.83	7.7948	7.8004	32749840.0
2020-02-19 14:00:00	NVDA	Stock	7.8018	7.825	7.7862	7.8142	33669280.0
2020-02-19 15:00:00	NVDA	Stock	7.8142	7.8853	7.7942	7.8678	91980280.0
2020-02-19 16:00:00	NVDA	Stock	7.8675	7.91	7.8675	7.91	31263560.0
2020-02-19 17:00:00	NVDA	Stock	7.911	7.912	7.8675	7.895	1865240.0
2020-02-19 18:00:00	NVDA	Stock	7.897	7.8975	7.8675	7.875	1641360.0
2020-02-19 19:00:00	NVDA	Stock	7.8752	7.916	7.875	7.916	1075960.0
2020-02-19 06:00:00	AMZN	Stock	108.1235	108.1295	108.1235	108.1295	4000.0
2020-02-19 07:00:00	AMZN	Stock	108.1295	108.2535	108.0875	108.219	107360.0

> showing 50 of 51,722 rows — these rows as CSV

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