PREVIEW / stock_1hour / 2021-12-06

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-12-06.parquet
  size:    1.5 MB
  rows:    67,591
  symbols: 2,700

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-12-06 04:00:00	AAPL	Stock	163.29	164.25	162.8	163.2	129903.0
2021-12-06 05:00:00	AAPL	Stock	163.18	163.8	161.84	162.12	73141.0
2021-12-06 06:00:00	AAPL	Stock	162.09	163.2	162.09	163.2	40354.0
2021-12-06 07:00:00	AAPL	Stock	163.13	163.65	162.02	163.51	322367.0
2021-12-06 08:00:00	AAPL	Stock	162.3102	164.08	161.436	163.95	910696.0
2021-12-06 09:00:00	AAPL	Stock	163.95	167.16	163.51	167.12	19744071.0
2021-12-06 10:00:00	AAPL	Stock	167.1	167.8799	165.28	165.9999	19502577.0
2021-12-06 11:00:00	AAPL	Stock	165.99	166.24	164.9028	165.61	8774679.0
2021-12-06 12:00:00	AAPL	Stock	165.61	166.44	165.6	166.2899	5760404.0
2021-12-06 13:00:00	AAPL	Stock	166.3	166.42	165.57	166.195	5713179.0
2021-12-06 14:00:00	AAPL	Stock	166.195	166.5	165.29	165.55	6087975.0
2021-12-06 15:00:00	AAPL	Stock	165.54	165.83	164.99	165.29	10950416.0
2021-12-06 16:00:00	AAPL	Stock	165.32	165.32	164.89	165.29	15083051.0
2021-12-06 17:00:00	AAPL	Stock	165.31	165.32	165.04	165.1	708194.0
2021-12-06 18:00:00	AAPL	Stock	165.15	165.2	165.02	165.09	22162.0
2021-12-06 19:00:00	AAPL	Stock	165.08	165.1	164.83	165.1	56098.0
2021-12-06 04:00:00	MSFT	Stock	323.02	325.15	322.75	322.99	13941.0
2021-12-06 05:00:00	MSFT	Stock	323.25	323.34	321.05	321.05	6670.0
2021-12-06 06:00:00	MSFT	Stock	320.9	322.19	320.9	321.47	3368.0
2021-12-06 07:00:00	MSFT	Stock	322.7	322.72	321.99	322.2	93569.0
2021-12-06 08:00:00	MSFT	Stock	322.55	323.817	322.01	323.38	44281.0
2021-12-06 09:00:00	MSFT	Stock	323.44	324.85	319.23	320.39	2489725.0
2021-12-06 10:00:00	MSFT	Stock	320.38	323.51	319.25	322.47	2769644.0
2021-12-06 11:00:00	MSFT	Stock	322.48	323.175	321.55	322.17	1517784.0
2021-12-06 12:00:00	MSFT	Stock	322.185	324.0899	321.87	323.96	1414288.0
2021-12-06 13:00:00	MSFT	Stock	323.97	325.63	323.75	325.335	1514554.0
2021-12-06 14:00:00	MSFT	Stock	325.32	327.45	324.44	325.43	3233381.0
2021-12-06 15:00:00	MSFT	Stock	325.42	327.29	325.39	326.47	3336711.0
2021-12-06 16:00:00	MSFT	Stock	326.19	326.2	325.5	326.13	5636684.0
2021-12-06 17:00:00	MSFT	Stock	326.02	326.19	326.0	326.1	56948.0
2021-12-06 18:00:00	MSFT	Stock	326.15	326.3	326.1	326.1	13539.0
2021-12-06 19:00:00	MSFT	Stock	326.28	326.29	325.25	326.19	13223.0
2021-12-06 04:00:00	NVDA	Stock	30.687	30.82	29.101	29.13	799610.0
2021-12-06 05:00:00	NVDA	Stock	29.151	29.642	29.137	29.25	397990.0
2021-12-06 06:00:00	NVDA	Stock	29.281	29.7	29.215	29.7	347210.0
2021-12-06 07:00:00	NVDA	Stock	29.749	29.765	29.3	29.4	1218750.0
2021-12-06 08:00:00	NVDA	Stock	29.5	30.0	29.27	29.85	2971000.0
2021-12-06 09:00:00	NVDA	Stock	29.87	30.0597	28.075	28.77	104220190.0
2021-12-06 10:00:00	NVDA	Stock	28.784	29.323	28.038	29.141	108373380.0
2021-12-06 11:00:00	NVDA	Stock	29.15	29.471	28.87	29.239	62508660.0
2021-12-06 12:00:00	NVDA	Stock	29.252	29.425	29.062	29.3878	38796470.0
2021-12-06 13:00:00	NVDA	Stock	29.381	29.988	29.325	29.8921	48733900.0
2021-12-06 14:00:00	NVDA	Stock	29.892	30.134	29.79	29.9857	48844440.0
2021-12-06 15:00:00	NVDA	Stock	29.984	30.241	29.901	30.033	58839380.0
2021-12-06 16:00:00	NVDA	Stock	30.033	30.693	29.96	30.032	24438820.0
2021-12-06 17:00:00	NVDA	Stock	30.011	30.099	30.0	30.07	194570.0
2021-12-06 18:00:00	NVDA	Stock	30.05	30.12	30.05	30.059	127310.0
2021-12-06 19:00:00	NVDA	Stock	30.059	30.072	29.93	29.932	327570.0
2021-12-06 04:00:00	AMZN	Stock	170.21	170.21	169.2	169.2	6000.0
2021-12-06 05:00:00	AMZN	Stock	168.0005	168.25	167.6	167.6	24760.0

> showing 50 of 67,591 rows — these rows as CSV

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