PREVIEW / stock_1hour / 2022-01-11

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-01-11.parquet
  size:    1.4 MB
  rows:    64,150
  symbols: 2,587

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
2022-01-11 04:00:00	AAPL	Stock	172.75	173.95	172.39	173.76	29314.0
2022-01-11 05:00:00	AAPL	Stock	173.79	174.08	173.6	173.93	14263.0
2022-01-11 06:00:00	AAPL	Stock	173.98	173.98	173.12	173.56	43793.0
2022-01-11 07:00:00	AAPL	Stock	173.56	173.65	173.02	173.05	73111.0
2022-01-11 08:00:00	AAPL	Stock	173.6299	173.65	172.34	172.47	448600.0
2022-01-11 09:00:00	AAPL	Stock	172.44	172.7	170.82	171.56	8700271.0
2022-01-11 10:00:00	AAPL	Stock	171.6	172.63	170.97	171.53	10261316.0
2022-01-11 11:00:00	AAPL	Stock	171.545	174.98	171.49	174.83	12436736.0
2022-01-11 12:00:00	AAPL	Stock	174.84	175.035	172.59	174.2599	6560253.0
2022-01-11 13:00:00	AAPL	Stock	174.26	174.77	173.74	174.485	4243289.0
2022-01-11 14:00:00	AAPL	Stock	174.4899	175.105	173.87	174.8399	5872338.0
2022-01-11 15:00:00	AAPL	Stock	174.8398	175.18	174.4	175.09	10462047.0
2022-01-11 16:00:00	AAPL	Stock	175.08	175.13	174.94	175.13	7297446.0
2022-01-11 17:00:00	AAPL	Stock	175.13	175.13	175.01	175.08	14487.0
2022-01-11 18:00:00	AAPL	Stock	175.04	175.12	175.0	175.1	24435.0
2022-01-11 19:00:00	AAPL	Stock	175.07	175.25	175.06	175.25	68222.0
2022-01-11 04:00:00	MSFT	Stock	314.0	316.36	314.0	316.36	10044.0
2022-01-11 05:00:00	MSFT	Stock	316.37	316.85	316.33	316.56	5672.0
2022-01-11 06:00:00	MSFT	Stock	316.5	316.5	316.06	316.48	3495.0
2022-01-11 07:00:00	MSFT	Stock	316.25	316.61	315.12	315.13	29039.0
2022-01-11 08:00:00	MSFT	Stock	316.4	316.6	314.0	314.21	62511.0
2022-01-11 09:00:00	MSFT	Stock	314.17	314.34	309.89	312.225	3022263.0
2022-01-11 10:00:00	MSFT	Stock	312.195	313.87	310.45	311.66	2650201.0
2022-01-11 11:00:00	MSFT	Stock	311.665	316.61	311.53	316.39	3229165.0
2022-01-11 12:00:00	MSFT	Stock	316.45	316.53	314.32	314.81	1825526.0
2022-01-11 13:00:00	MSFT	Stock	314.83	315.605	313.95	314.94	1701339.0
2022-01-11 14:00:00	MSFT	Stock	314.92	315.81	313.89	315.22	1641138.0
2022-01-11 15:00:00	MSFT	Stock	315.24	316.19	313.3	314.99	4276490.0
2022-01-11 16:00:00	MSFT	Stock	314.98	315.28	314.72	315.03	4042446.0
2022-01-11 17:00:00	MSFT	Stock	315.03	315.25	315.03	315.25	9470.0
2022-01-11 18:00:00	MSFT	Stock	315.28	315.38	314.84	315.0	9629.0
2022-01-11 19:00:00	MSFT	Stock	315.1	315.35	314.92	315.1001	5021.0
2022-01-11 04:00:00	NVDA	Stock	27.432	27.665	27.277	27.603	267530.0
2022-01-11 05:00:00	NVDA	Stock	27.61	27.692	27.55	27.621	130280.0
2022-01-11 06:00:00	NVDA	Stock	27.589	27.602	27.508	27.529	67350.0
2022-01-11 07:00:00	NVDA	Stock	27.55	27.64	27.53	27.56	559590.0
2022-01-11 08:00:00	NVDA	Stock	27.57	27.64	27.325	27.333	1887850.0
2022-01-11 09:00:00	NVDA	Stock	27.331	27.39	26.839	27.13	42390240.0
2022-01-11 10:00:00	NVDA	Stock	27.1395	27.565	26.95	27.133	53710560.0
2022-01-11 11:00:00	NVDA	Stock	27.122	28.065	27.122	27.917	56227860.0
2022-01-11 12:00:00	NVDA	Stock	27.918	27.986	27.555	27.586	33648290.0
2022-01-11 13:00:00	NVDA	Stock	27.5965	27.732	27.456	27.705	26957380.0
2022-01-11 14:00:00	NVDA	Stock	27.7058	27.85	27.542	27.723	29111670.0
2022-01-11 15:00:00	NVDA	Stock	27.725	27.899	27.6	27.818	41345470.0
2022-01-11 16:00:00	NVDA	Stock	27.817	27.822	27.4	27.77	18632830.0
2022-01-11 17:00:00	NVDA	Stock	27.77	27.785	27.752	27.77	84670.0
2022-01-11 18:00:00	NVDA	Stock	27.763	27.809	27.75	27.765	350230.0
2022-01-11 19:00:00	NVDA	Stock	27.765	27.85	27.765	27.819	333660.0
2022-01-11 05:00:00	AMZN	Stock	162.4995	162.4995	162.4995	162.4995	2000.0
2022-01-11 07:00:00	AMZN	Stock	162.244	162.25	161.933	161.933	34220.0

> showing 50 of 64,150 rows — these rows as CSV

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