PREVIEW / stock_1hour / 2021-07-28

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-07-28.parquet
  size:    1.4 MB
  rows:    63,957
  symbols: 2,813

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-07-28 04:00:00	AAPL	Stock	144.54	145.76	144.4	145.6	131506.0
2021-07-28 05:00:00	AAPL	Stock	145.68	145.88	145.03	145.33	61924.0
2021-07-28 06:00:00	AAPL	Stock	145.31	145.32	144.57	145.09	65348.0
2021-07-28 07:00:00	AAPL	Stock	144.92	146.0	144.32	145.3	557914.0
2021-07-28 08:00:00	AAPL	Stock	145.33	146.34	144.28	145.33	1296733.0
2021-07-28 09:00:00	AAPL	Stock	145.33	146.7384	142.54	144.5601	21061700.0
2021-07-28 10:00:00	AAPL	Stock	144.57	146.97	144.415	146.28	20280124.0
2021-07-28 11:00:00	AAPL	Stock	146.28	146.49	144.42	144.755	10819652.0
2021-07-28 12:00:00	AAPL	Stock	144.76	145.44	144.62	144.895	7879628.0
2021-07-28 13:00:00	AAPL	Stock	144.91	145.0	143.88	144.48	7647015.0
2021-07-28 14:00:00	AAPL	Stock	144.4999	145.44	143.94	145.025	10091714.0
2021-07-28 15:00:00	AAPL	Stock	145.03	145.5099	144.91	144.98	10182324.0
2021-07-28 16:00:00	AAPL	Stock	144.98	146.0	144.89	145.2	3905235.0
2021-07-28 17:00:00	AAPL	Stock	145.2	145.26	144.98	145.08	86334.0
2021-07-28 18:00:00	AAPL	Stock	145.1	145.29	145.05	145.07	47560.0
2021-07-28 19:00:00	AAPL	Stock	145.08	145.15	145.0	145.14	53195.0
2021-07-28 04:00:00	MSFT	Stock	289.05	289.05	288.0	288.0	9275.0
2021-07-28 05:00:00	MSFT	Stock	287.81	288.0	287.3	287.79	7892.0
2021-07-28 06:00:00	MSFT	Stock	287.8	288.27	287.02	287.75	16340.0
2021-07-28 07:00:00	MSFT	Stock	287.75	291.4	287.4	290.1	309392.0
2021-07-28 08:00:00	MSFT	Stock	290.1	291.85	287.5101	290.18	373485.0
2021-07-28 09:00:00	MSFT	Stock	290.1	290.55	283.8303	287.825	6196705.0
2021-07-28 10:00:00	MSFT	Stock	287.8	290.15	286.8	288.93	4957877.0
2021-07-28 11:00:00	MSFT	Stock	288.93	289.37	286.875	287.4812	2298444.0
2021-07-28 12:00:00	MSFT	Stock	287.4801	287.68	286.35	286.73	2081283.0
2021-07-28 13:00:00	MSFT	Stock	286.74	286.8149	285.91	286.1999	1910590.0
2021-07-28 14:00:00	MSFT	Stock	286.2	287.11	285.35	286.05	2483024.0
2021-07-28 15:00:00	MSFT	Stock	286.04	286.93	285.69	286.22	2890909.0
2021-07-28 16:00:00	MSFT	Stock	286.22	287.0	285.9	286.72	1959549.0
2021-07-28 17:00:00	MSFT	Stock	286.45	286.69	286.35	286.45	5736.0
2021-07-28 18:00:00	MSFT	Stock	286.22	286.54	286.22	286.35	10893.0
2021-07-28 19:00:00	MSFT	Stock	286.36	286.49	286.0601	286.4	7729.0
2021-07-28 04:00:00	NVDA	Stock	19.137	19.328	19.137	19.26	85550.0
2021-07-28 05:00:00	NVDA	Stock	19.282	19.282	19.205	19.23	11840.0
2021-07-28 06:00:00	NVDA	Stock	19.234	19.234	19.164	19.2	17250.0
2021-07-28 07:00:00	NVDA	Stock	19.205	19.333	19.19	19.311	291870.0
2021-07-28 08:00:00	NVDA	Stock	19.313	19.339	19.2	19.3	524340.0
2021-07-28 09:00:00	NVDA	Stock	19.3	19.389	18.995	19.253	24193770.0
2021-07-28 10:00:00	NVDA	Stock	19.255	19.527	19.231	19.427	30767150.0
2021-07-28 11:00:00	NVDA	Stock	19.426	19.559	19.37	19.524	20391480.0
2021-07-28 12:00:00	NVDA	Stock	19.523	19.646	19.508	19.518	17843040.0
2021-07-28 13:00:00	NVDA	Stock	19.52	19.557	19.3921	19.4385	10601360.0
2021-07-28 14:00:00	NVDA	Stock	19.443	19.595	19.353	19.536	15763070.0
2021-07-28 15:00:00	NVDA	Stock	19.537	19.592	19.496	19.502	15301560.0
2021-07-28 16:00:00	NVDA	Stock	19.503	19.503	19.465	19.48	12430570.0
2021-07-28 17:00:00	NVDA	Stock	19.479	19.5	19.47	19.489	110850.0
2021-07-28 18:00:00	NVDA	Stock	19.503	19.508	19.49	19.49	153790.0
2021-07-28 19:00:00	NVDA	Stock	19.487	19.5	19.476	19.494	188450.0
2021-07-28 04:00:00	AMZN	Stock	181.8	181.8	181.75	181.8	6920.0
2021-07-28 07:00:00	AMZN	Stock	181.4	182.4	181.4	181.9	28440.0

> showing 50 of 63,957 rows — these rows as CSV

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