PREVIEW / stock_1hour / 2021-05-19

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-05-19.parquet
  size:    1.4 MB
  rows:    65,205
  symbols: 2,957

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
2021-05-19 04:00:00	AAPL	Stock	123.83	123.83	123.16	123.44	52214.0
2021-05-19 05:00:00	AAPL	Stock	123.5	123.71	123.01	123.19	29343.0
2021-05-19 06:00:00	AAPL	Stock	123.1	123.48	123.06	123.41	16525.0
2021-05-19 07:00:00	AAPL	Stock	123.5	123.67	122.95	123.05	303699.0
2021-05-19 08:00:00	AAPL	Stock	123.52	125.162	122.85	123.0401	567347.0
2021-05-19 09:00:00	AAPL	Stock	123.06	124.07	122.86	123.35	11079315.0
2021-05-19 10:00:00	AAPL	Stock	123.345	124.05	123.1075	123.62	11940859.0
2021-05-19 11:00:00	AAPL	Stock	123.62	124.12	123.31	123.9001	9526390.0
2021-05-19 12:00:00	AAPL	Stock	123.8901	124.25	123.715	123.99	6883795.0
2021-05-19 13:00:00	AAPL	Stock	123.98	124.439	123.97	124.26	5830527.0
2021-05-19 14:00:00	AAPL	Stock	124.26	124.915	123.5	123.95	11390376.0
2021-05-19 15:00:00	AAPL	Stock	123.95	124.79	123.77	124.69	12284618.0
2021-05-19 16:00:00	AAPL	Stock	124.7	124.82	124.46	124.67	10022334.0
2021-05-19 17:00:00	AAPL	Stock	124.63	124.74	124.5501	124.68	30933.0
2021-05-19 18:00:00	AAPL	Stock	124.69	124.74	124.45	124.45	62976.0
2021-05-19 19:00:00	AAPL	Stock	124.47	124.48	124.22	124.3	62621.0
2021-05-19 04:00:00	MSFT	Stock	240.5	240.5	239.65	239.7	9426.0
2021-05-19 05:00:00	MSFT	Stock	239.95	241.0	239.11	239.21	5659.0
2021-05-19 06:00:00	MSFT	Stock	239.7	240.0	239.53	239.7	5930.0
2021-05-19 07:00:00	MSFT	Stock	240.28	240.28	238.9	239.1	34768.0
2021-05-19 08:00:00	MSFT	Stock	240.15	240.5	238.88	238.9001	73208.0
2021-05-19 09:00:00	MSFT	Stock	238.9	241.2126	238.32	239.9901	2803510.0
2021-05-19 10:00:00	MSFT	Stock	239.99	241.56	239.65	240.965	2862657.0
2021-05-19 11:00:00	MSFT	Stock	240.96	241.91	240.72	241.59	1629515.0
2021-05-19 12:00:00	MSFT	Stock	241.53	242.17	241.3	241.94	1409886.0
2021-05-19 13:00:00	MSFT	Stock	241.945	242.66	241.53	241.5517	1221412.0
2021-05-19 14:00:00	MSFT	Stock	241.57	243.06	240.42	241.31	2121192.0
2021-05-19 15:00:00	MSFT	Stock	241.33	243.23	240.87	243.14	2983046.0
2021-05-19 16:00:00	MSFT	Stock	243.04	243.13	242.51	242.8075	4691629.0
2021-05-19 17:00:00	MSFT	Stock	243.11	243.11	242.9	242.97	3093.0
2021-05-19 18:00:00	MSFT	Stock	243.09	243.09	242.53	242.79	8865.0
2021-05-19 19:00:00	MSFT	Stock	242.82	242.97	242.4	242.57	6052.0
2021-05-19 04:00:00	NVDA	Stock	13.7812	13.7812	13.745	13.745	49200.0
2021-05-19 05:00:00	NVDA	Stock	13.7998	13.8015	13.7998	13.8015	59440.0
2021-05-19 06:00:00	NVDA	Stock	13.7875	13.7998	13.7875	13.7998	8000.0
2021-05-19 07:00:00	NVDA	Stock	13.775	13.8192	13.625	13.665	886760.0
2021-05-19 08:00:00	NVDA	Stock	13.8248	13.8248	13.464	13.5173	1570320.0
2021-05-19 09:00:00	NVDA	Stock	13.5245	13.7885	13.4625	13.6611	39258760.0
2021-05-19 10:00:00	NVDA	Stock	13.653	13.8102	13.5778	13.7879	29899200.0
2021-05-19 11:00:00	NVDA	Stock	13.7866	13.9383	13.7485	13.8158	28757320.0
2021-05-19 12:00:00	NVDA	Stock	13.82	13.9998	13.795	13.9456	23652320.0
2021-05-19 13:00:00	NVDA	Stock	13.9423	14.047	13.9053	13.9537	21468080.0
2021-05-19 14:00:00	NVDA	Stock	13.9475	14.0787	13.8502	13.9042	26619160.0
2021-05-19 15:00:00	NVDA	Stock	13.904	14.0795	13.8652	14.066	28185080.0
2021-05-19 16:00:00	NVDA	Stock	14.0658	14.075	14.0402	14.0575	23986160.0
2021-05-19 17:00:00	NVDA	Stock	14.058	14.06	14.0502	14.0558	32880.0
2021-05-19 18:00:00	NVDA	Stock	14.058	14.0658	14.0288	14.0288	156840.0
2021-05-19 19:00:00	NVDA	Stock	14.0325	14.0325	13.975	13.9762	119840.0
2021-05-19 04:00:00	AMZN	Stock	160.742	160.947	160.742	160.947	8000.0
2021-05-19 07:00:00	AMZN	Stock	160.3425	160.3425	159.75	159.8575	46160.0

> showing 50 of 65,205 rows — these rows as CSV

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