PREVIEW / stock_1hour / 2021-08-13

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-08-13.parquet
  size:    1.4 MB
  rows:    64,197
  symbols: 2,802

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-08-13 04:00:00	AAPL	Stock	148.99	149.25	148.88	149.21	23716.0
2021-08-13 05:00:00	AAPL	Stock	149.17	149.17	149.09	149.13	2435.0
2021-08-13 06:00:00	AAPL	Stock	149.13	149.22	149.0	149.05	17780.0
2021-08-13 07:00:00	AAPL	Stock	149.1	149.24	148.67	148.67	199976.0
2021-08-13 08:00:00	AAPL	Stock	149.0501	149.22	148.518	148.97	179981.0
2021-08-13 09:00:00	AAPL	Stock	148.98	149.39	148.32	149.13	10769424.0
2021-08-13 10:00:00	AAPL	Stock	149.13	149.4444	148.7	148.9	8942088.0
2021-08-13 11:00:00	AAPL	Stock	148.9	149.085	148.3201	148.365	5351358.0
2021-08-13 12:00:00	AAPL	Stock	148.3601	148.84	148.27	148.81	3914417.0
2021-08-13 13:00:00	AAPL	Stock	148.81	149.095	148.71	148.915	3864171.0
2021-08-13 14:00:00	AAPL	Stock	148.91	149.12	148.745	149.0916	3724698.0
2021-08-13 15:00:00	AAPL	Stock	149.095	149.12	148.88	149.1	6576455.0
2021-08-13 16:00:00	AAPL	Stock	149.1	149.1399	148.98	148.99	3321127.0
2021-08-13 17:00:00	AAPL	Stock	148.99	149.01	148.97	148.98	42351.0
2021-08-13 18:00:00	AAPL	Stock	148.97	148.98	148.8	148.86	17806.0
2021-08-13 19:00:00	AAPL	Stock	148.88	148.94	148.85	148.92	32796.0
2021-08-13 04:00:00	MSFT	Stock	289.79	289.82	289.79	289.82	1941.0
2021-08-13 05:00:00	MSFT	Stock	289.82	289.82	289.7	289.71	1949.0
2021-08-13 06:00:00	MSFT	Stock	289.63	289.63	289.56	289.56	1174.0
2021-08-13 07:00:00	MSFT	Stock	289.42	289.55	288.65	288.82	4329.0
2021-08-13 08:00:00	MSFT	Stock	288.81	289.61	288.81	289.25	7981.0
2021-08-13 09:00:00	MSFT	Stock	289.39	290.94	289.3	290.615	1689342.0
2021-08-13 10:00:00	MSFT	Stock	290.63	292.18	290.2	291.6832	2071204.0
2021-08-13 11:00:00	MSFT	Stock	291.69	291.96	290.87	291.01	1148296.0
2021-08-13 12:00:00	MSFT	Stock	291.0	291.6599	290.96	291.6	784798.0
2021-08-13 13:00:00	MSFT	Stock	291.595	291.92	291.52	291.8283	692072.0
2021-08-13 14:00:00	MSFT	Stock	291.82	292.035	291.7	292.03	833337.0
2021-08-13 15:00:00	MSFT	Stock	292.03	292.9	291.94	292.86	2202090.0
2021-08-13 16:00:00	MSFT	Stock	292.85	293.24	292.71	293.0	1898327.0
2021-08-13 17:00:00	MSFT	Stock	292.97	293.05	292.85	292.96	4585.0
2021-08-13 18:00:00	MSFT	Stock	292.9501	292.98	292.9	292.9001	3586.0
2021-08-13 19:00:00	MSFT	Stock	292.95	293.19	292.89	293.1	11286.0
2021-08-13 04:00:00	NVDA	Stock	19.989	20.049	19.905	20.049	31050.0
2021-08-13 05:00:00	NVDA	Stock	20.02	20.02	19.978	20.02	23140.0
2021-08-13 06:00:00	NVDA	Stock	20.0	20.0	20.0	20.0	3980.0
2021-08-13 07:00:00	NVDA	Stock	19.987	19.999	19.93	19.93	153230.0
2021-08-13 08:00:00	NVDA	Stock	19.971	19.999	19.911	19.99	197300.0
2021-08-13 09:00:00	NVDA	Stock	19.995	20.15	19.851	19.893	22452850.0
2021-08-13 10:00:00	NVDA	Stock	19.8958	20.17	19.889	20.1074	23738920.0
2021-08-13 11:00:00	NVDA	Stock	20.108	20.1515	20.032	20.062	10008340.0
2021-08-13 12:00:00	NVDA	Stock	20.063	20.149	20.005	20.139	15055810.0
2021-08-13 13:00:00	NVDA	Stock	20.1394	20.2138	20.091	20.128	15614450.0
2021-08-13 14:00:00	NVDA	Stock	20.127	20.1325	20.047	20.122	10434480.0
2021-08-13 15:00:00	NVDA	Stock	20.125	20.198	20.066	20.195	19799750.0
2021-08-13 16:00:00	NVDA	Stock	20.188	20.195	20.158	20.175	10583000.0
2021-08-13 17:00:00	NVDA	Stock	20.176	20.185	20.15	20.172	115820.0
2021-08-13 18:00:00	NVDA	Stock	20.17	20.175	20.16	20.165	146620.0
2021-08-13 19:00:00	NVDA	Stock	20.162	20.185	20.16	20.185	51890.0
2021-08-13 08:00:00	AMZN	Stock	165.0675	165.25	165.0675	165.25	13800.0
2021-08-13 09:00:00	AMZN	Stock	165.21	165.4	164.3	164.676	3537680.0

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

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