PREVIEW / stock_1hour / 2020-07-21

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-07-21.parquet
  size:    1.3 MB
  rows:    57,608
  symbols: 2,454

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-07-21 04:00:00	AAPL	Stock	99.25	99.5	99.25	99.2775	38120.0
2020-07-21 05:00:00	AAPL	Stock	99.295	99.3225	99.2425	99.3225	6316.0
2020-07-21 06:00:00	AAPL	Stock	99.27	99.31	99.0875	99.225	30908.0
2020-07-21 07:00:00	AAPL	Stock	99.0775	99.2425	98.9475	99.1375	293608.0
2020-07-21 08:00:00	AAPL	Stock	98.9875	99.2288	98.91	98.9895	395496.0
2020-07-21 09:00:00	AAPL	Stock	98.95	99.2975	98.1175	98.6125	14317816.0
2020-07-21 10:00:00	AAPL	Stock	98.6125	98.67	97.835	98.0952	12178680.0
2020-07-21 11:00:00	AAPL	Stock	98.0875	98.1555	97.3825	97.5725	8807384.0
2020-07-21 12:00:00	AAPL	Stock	97.5625	97.7125	97.3125	97.5775	8741244.0
2020-07-21 13:00:00	AAPL	Stock	97.573	98.035	97.2775	97.9075	6538220.0
2020-07-21 14:00:00	AAPL	Stock	97.92	98.21	97.7875	97.8925	6590096.0
2020-07-21 15:00:00	AAPL	Stock	97.8975	97.9275	96.7425	97.0	15994744.0
2020-07-21 16:00:00	AAPL	Stock	97.0	97.1325	97.0	97.09	7859420.0
2020-07-21 17:00:00	AAPL	Stock	97.115	97.13	97.0	97.035	96544.0
2020-07-21 18:00:00	AAPL	Stock	97.05	97.25	97.0125	97.225	102456.0
2020-07-21 19:00:00	AAPL	Stock	97.21	97.25	97.1375	97.175	62292.0
2020-07-21 04:00:00	MSFT	Stock	213.8	214.55	213.8	214.22	10639.0
2020-07-21 05:00:00	MSFT	Stock	214.28	214.6	214.28	214.59	10500.0
2020-07-21 06:00:00	MSFT	Stock	214.5	214.75	214.15	214.17	16007.0
2020-07-21 07:00:00	MSFT	Stock	214.37	214.55	213.6	214.0	129724.0
2020-07-21 08:00:00	MSFT	Stock	214.2	214.46	212.12	213.5	203610.0
2020-07-21 09:00:00	MSFT	Stock	213.375	213.99	210.06	211.87	6407242.0
2020-07-21 10:00:00	MSFT	Stock	211.84	212.49	210.38	210.69	4105932.0
2020-07-21 11:00:00	MSFT	Stock	210.69	210.99	208.8	209.33	3424465.0
2020-07-21 12:00:00	MSFT	Stock	209.337	210.12	208.47	210.073	2512348.0
2020-07-21 13:00:00	MSFT	Stock	210.07	210.95	209.4	210.83	2466571.0
2020-07-21 14:00:00	MSFT	Stock	210.83	211.73	210.62	210.73	2375438.0
2020-07-21 15:00:00	MSFT	Stock	210.72	210.85	208.03	208.75	5857366.0
2020-07-21 16:00:00	MSFT	Stock	208.75	209.84	208.58	209.6	4425560.0
2020-07-21 17:00:00	MSFT	Stock	209.6	209.63	209.4	209.47	36569.0
2020-07-21 18:00:00	MSFT	Stock	209.57	210.7	209.57	210.55	58747.0
2020-07-21 19:00:00	MSFT	Stock	210.38	210.75	210.25	210.68	33676.0
2020-07-21 04:00:00	NVDA	Stock	10.6052	10.668	10.6052	10.668	112400.0
2020-07-21 05:00:00	NVDA	Stock	10.6502	10.675	10.6375	10.675	210960.0
2020-07-21 06:00:00	NVDA	Stock	10.6655	10.6655	10.6535	10.6648	65880.0
2020-07-21 07:00:00	NVDA	Stock	10.6128	10.6422	10.6075	10.62	780400.0
2020-07-21 08:00:00	NVDA	Stock	10.6168	10.65	10.5845	10.6022	1015320.0
2020-07-21 09:00:00	NVDA	Stock	10.601	10.6125	10.3762	10.4448	51462080.0
2020-07-21 10:00:00	NVDA	Stock	10.4442	10.4642	10.3265	10.3661	55692000.0
2020-07-21 11:00:00	NVDA	Stock	10.364	10.4073	10.2888	10.3174	33797000.0
2020-07-21 12:00:00	NVDA	Stock	10.3173	10.3538	10.2868	10.3538	25756840.0
2020-07-21 13:00:00	NVDA	Stock	10.351	10.4141	10.3128	10.405	22383160.0
2020-07-21 14:00:00	NVDA	Stock	10.41	10.45	10.3972	10.4171	24642280.0
2020-07-21 15:00:00	NVDA	Stock	10.4185	10.4185	10.2893	10.329	45954360.0
2020-07-21 16:00:00	NVDA	Stock	10.3285	10.3825	10.3285	10.35	4573040.0
2020-07-21 17:00:00	NVDA	Stock	10.3533	10.357	10.35	10.354	69080.0
2020-07-21 18:00:00	NVDA	Stock	10.355	10.371	10.354	10.3675	248520.0
2020-07-21 19:00:00	NVDA	Stock	10.3638	10.3732	10.3625	10.3688	194000.0
2020-07-21 04:00:00	AMZN	Stock	161.305	162.25	161.305	162.2	19020.0
2020-07-21 05:00:00	AMZN	Stock	162.05	162.2	162.05	162.2	37520.0

> showing 50 of 57,608 rows — these rows as CSV

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