PREVIEW / stock_1hour / 2022-04-13

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-04-13.parquet
  size:    1.4 MB
  rows:    63,048
  symbols: 2,500

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-04-13 04:00:00	AAPL	Stock	168.7	169.22	168.52	169.2	27739.0
2022-04-13 05:00:00	AAPL	Stock	169.14	169.21	168.38	168.38	13039.0
2022-04-13 06:00:00	AAPL	Stock	168.4	168.94	168.2	168.75	21436.0
2022-04-13 07:00:00	AAPL	Stock	168.78	169.17	168.03	168.12	93927.0
2022-04-13 08:00:00	AAPL	Stock	169.0	169.79	167.45	167.49	470188.0
2022-04-13 09:00:00	AAPL	Stock	167.49	168.5	166.77	167.87	8002936.0
2022-04-13 10:00:00	AAPL	Stock	167.88	169.04	167.62	168.61	8589340.0
2022-04-13 11:00:00	AAPL	Stock	168.61	170.215	168.61	169.8052	7931712.0
2022-04-13 12:00:00	AAPL	Stock	169.8	171.0	169.6001	170.665	7296644.0
2022-04-13 13:00:00	AAPL	Stock	170.67	170.99	169.95	170.29	5486477.0
2022-04-13 14:00:00	AAPL	Stock	170.295	170.5525	170.065	170.51	5028466.0
2022-04-13 15:00:00	AAPL	Stock	170.5175	171.04	170.115	170.4	10793300.0
2022-04-13 16:00:00	AAPL	Stock	170.36	170.41	170.13	170.16	5695463.0
2022-04-13 17:00:00	AAPL	Stock	170.1801	170.4	170.1	170.22	115042.0
2022-04-13 18:00:00	AAPL	Stock	170.25	170.35	170.15	170.35	22138.0
2022-04-13 19:00:00	AAPL	Stock	170.35	170.4	170.15	170.4	37993.0
2022-04-13 04:00:00	MSFT	Stock	285.0	285.0	284.2	284.3	4334.0
2022-04-13 05:00:00	MSFT	Stock	283.83	283.83	283.03	283.08	2796.0
2022-04-13 06:00:00	MSFT	Stock	283.0	284.71	282.87	284.71	3505.0
2022-04-13 07:00:00	MSFT	Stock	284.63	284.95	283.01	283.01	27263.0
2022-04-13 08:00:00	MSFT	Stock	284.7	284.8799	282.3106	282.75	55681.0
2022-04-13 09:00:00	MSFT	Stock	282.75	283.86	281.3	282.76	2297537.0
2022-04-13 10:00:00	MSFT	Stock	282.78	285.26	282.3586	283.6	2059185.0
2022-04-13 11:00:00	MSFT	Stock	283.64	286.1	283.615	285.67	1781786.0
2022-04-13 12:00:00	MSFT	Stock	285.66	286.62	285.23	286.085	1427713.0
2022-04-13 13:00:00	MSFT	Stock	286.1	286.86	285.28	285.9401	1304560.0
2022-04-13 14:00:00	MSFT	Stock	285.94	287.42	285.78	287.22	1380024.0
2022-04-13 15:00:00	MSFT	Stock	287.23	288.58	286.77	287.6	3201564.0
2022-04-13 16:00:00	MSFT	Stock	287.62	287.62	287.2521	287.59	3045562.0
2022-04-13 17:00:00	MSFT	Stock	287.42	287.62	287.35	287.58	13454.0
2022-04-13 18:00:00	MSFT	Stock	287.58	287.87	287.5	287.55	16693.0
2022-04-13 19:00:00	MSFT	Stock	287.76	287.89	287.51	287.8	11505.0
2022-04-13 04:00:00	NVDA	Stock	21.9	21.9	21.72	21.795	295710.0
2022-04-13 05:00:00	NVDA	Stock	21.8	21.838	21.653	21.66	101840.0
2022-04-13 06:00:00	NVDA	Stock	21.658	21.8	21.658	21.8	142160.0
2022-04-13 07:00:00	NVDA	Stock	21.781	21.89	21.688	21.7	1303560.0
2022-04-13 08:00:00	NVDA	Stock	21.86	22.099	21.48	21.556	10885960.0
2022-04-13 09:00:00	NVDA	Stock	21.5657	22.123	21.455	21.7165	69834060.0
2022-04-13 10:00:00	NVDA	Stock	21.7195	22.228	21.69	22.011	74918840.0
2022-04-13 11:00:00	NVDA	Stock	22.009	22.5	22.008	22.1655	47736520.0
2022-04-13 12:00:00	NVDA	Stock	22.167	22.167	22.014	22.126	34094680.0
2022-04-13 13:00:00	NVDA	Stock	22.129	22.167	21.884	21.964	29272060.0
2022-04-13 14:00:00	NVDA	Stock	21.9658	22.248	21.94	22.1877	37255010.0
2022-04-13 15:00:00	NVDA	Stock	22.1878	22.428	22.121	22.205	67840140.0
2022-04-13 16:00:00	NVDA	Stock	22.203	22.247	22.1203	22.229	19518440.0
2022-04-13 17:00:00	NVDA	Stock	22.215	22.23	22.19	22.2	293790.0
2022-04-13 18:00:00	NVDA	Stock	22.201	22.25	22.19	22.235	222810.0
2022-04-13 19:00:00	NVDA	Stock	22.243	22.27	22.2	22.205	443070.0
2022-04-13 04:00:00	AMZN	Stock	152.05	152.05	152.05	152.05	2000.0
2022-04-13 07:00:00	AMZN	Stock	151.651	151.651	151.3	151.3	4000.0

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

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