PREVIEW / stock_1hour / 2021-09-30

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-09-30.parquet
  size:    1.4 MB
  rows:    65,429
  symbols: 2,751

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-09-30 04:00:00	AAPL	Stock	144.0	144.13	143.77	143.92	18155.0
2021-09-30 05:00:00	AAPL	Stock	143.98	143.98	143.51	143.7	7636.0
2021-09-30 06:00:00	AAPL	Stock	143.96	143.98	143.37	143.46	6015.0
2021-09-30 07:00:00	AAPL	Stock	143.57	143.64	143.25	143.45	57717.0
2021-09-30 08:00:00	AAPL	Stock	143.5497	143.65	143.187	143.58	330363.0
2021-09-30 09:00:00	AAPL	Stock	143.56	144.378	143.21	143.3501	8618114.0
2021-09-30 10:00:00	AAPL	Stock	143.3571	143.46	142.5035	142.63	10059150.0
2021-09-30 11:00:00	AAPL	Stock	142.62	143.11	141.9	142.11	9748166.0
2021-09-30 12:00:00	AAPL	Stock	142.12	142.17	141.28	141.7799	9892278.0
2021-09-30 13:00:00	AAPL	Stock	141.78	142.29	141.66	142.2701	6827026.0
2021-09-30 14:00:00	AAPL	Stock	142.272	143.0	142.23	142.45	7167366.0
2021-09-30 15:00:00	AAPL	Stock	142.45	143.06	141.3	141.32	16828409.0
2021-09-30 16:00:00	AAPL	Stock	141.35	142.8348	141.35	141.57	9906160.0
2021-09-30 17:00:00	AAPL	Stock	141.6	141.76	141.52	141.72	45012.0
2021-09-30 18:00:00	AAPL	Stock	141.73	141.85	141.62	141.74	53124.0
2021-09-30 19:00:00	AAPL	Stock	141.74	141.98	141.66	141.76	75743.0
2021-09-30 04:00:00	MSFT	Stock	286.0	286.29	285.72	286.29	1021.0
2021-09-30 05:00:00	MSFT	Stock	286.19	286.2	285.77	285.77	1680.0
2021-09-30 06:00:00	MSFT	Stock	285.6	285.6	285.18	285.18	482.0
2021-09-30 07:00:00	MSFT	Stock	285.34	285.5	284.81	284.98	5233.0
2021-09-30 08:00:00	MSFT	Stock	285.35	285.77	284.61	285.4	30567.0
2021-09-30 09:00:00	MSFT	Stock	285.42	287.36	284.8	286.47	2284412.0
2021-09-30 10:00:00	MSFT	Stock	286.47	287.83	285.86	285.9729	2823656.0
2021-09-30 11:00:00	MSFT	Stock	285.92	287.09	283.78	284.17	2837856.0
2021-09-30 12:00:00	MSFT	Stock	284.18	284.27	281.89	282.21	3103580.0
2021-09-30 13:00:00	MSFT	Stock	282.1771	283.83	282.02	283.478	1775884.0
2021-09-30 14:00:00	MSFT	Stock	283.47	284.9	283.4	283.69	2075413.0
2021-09-30 15:00:00	MSFT	Stock	283.7	284.8	281.62	281.75	4514207.0
2021-09-30 16:00:00	MSFT	Stock	281.92	284.1788	281.74	281.94	5204894.0
2021-09-30 17:00:00	MSFT	Stock	281.93	282.11	281.86	282.11	8492.0
2021-09-30 18:00:00	MSFT	Stock	282.11	282.69	281.94	282.2	10289.0
2021-09-30 19:00:00	MSFT	Stock	282.4	282.69	282.22	282.22	6677.0
2021-09-30 04:00:00	NVDA	Stock	20.745	20.781	20.732	20.732	10010.0
2021-09-30 05:00:00	NVDA	Stock	20.734	20.734	20.725	20.731	5460.0
2021-09-30 06:00:00	NVDA	Stock	20.67	20.67	20.65	20.65	5930.0
2021-09-30 07:00:00	NVDA	Stock	20.698	20.7	20.636	20.668	146190.0
2021-09-30 08:00:00	NVDA	Stock	20.6752	20.774	20.4658	20.725	832390.0
2021-09-30 09:00:00	NVDA	Stock	20.725	21.066	20.675	20.9155	28755230.0
2021-09-30 10:00:00	NVDA	Stock	20.908	21.0539	20.765	20.806	26406650.0
2021-09-30 11:00:00	NVDA	Stock	20.8	20.934	20.688	20.7645	20569340.0
2021-09-30 12:00:00	NVDA	Stock	20.765	20.849	20.695	20.809	17082210.0
2021-09-30 13:00:00	NVDA	Stock	20.806	20.865	20.742	20.83	11878510.0
2021-09-30 14:00:00	NVDA	Stock	20.832	20.963	20.8221	20.863	14776220.0
2021-09-30 15:00:00	NVDA	Stock	20.862	20.955	20.7	20.714	24595640.0
2021-09-30 16:00:00	NVDA	Stock	20.716	20.8929	20.7	20.732	18143800.0
2021-09-30 17:00:00	NVDA	Stock	20.718	20.76	20.718	20.76	43670.0
2021-09-30 18:00:00	NVDA	Stock	20.757	20.789	20.744	20.775	80020.0
2021-09-30 19:00:00	NVDA	Stock	20.774	20.798	20.765	20.798	70790.0
2021-09-30 07:00:00	AMZN	Stock	165.65	165.777	165.575	165.65	16900.0
2021-09-30 08:00:00	AMZN	Stock	166.1188	166.1188	165.7	165.8375	32720.0

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

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