PREVIEW / stock_1hour / 2021-04-23

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-04-23.parquet
  size:    1.4 MB
  rows:    63,908
  symbols: 2,963

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-04-23 04:00:00	AAPL	Stock	132.15	132.2	132.0	132.2	18153.0
2021-04-23 05:00:00	AAPL	Stock	132.15	132.15	132.0	132.0	12483.0
2021-04-23 06:00:00	AAPL	Stock	132.03	132.28	132.02	132.27	5944.0
2021-04-23 07:00:00	AAPL	Stock	132.2	132.41	132.05	132.25	117761.0
2021-04-23 08:00:00	AAPL	Stock	132.1599	132.41	132.05	132.15	255177.0
2021-04-23 09:00:00	AAPL	Stock	132.14	133.38	132.09	133.175	7970520.0
2021-04-23 10:00:00	AAPL	Stock	133.17	133.78	133.01	133.74	10061992.0
2021-04-23 11:00:00	AAPL	Stock	133.74	134.58	133.62	134.38	9452795.0
2021-04-23 12:00:00	AAPL	Stock	134.375	134.6	134.1	134.59	7520591.0
2021-04-23 13:00:00	AAPL	Stock	134.59	135.12	134.49	134.621	8707394.0
2021-04-23 14:00:00	AAPL	Stock	134.62	135.1	134.6	134.8501	7148471.0
2021-04-23 15:00:00	AAPL	Stock	134.86	134.99	134.2	134.3	11445526.0
2021-04-23 16:00:00	AAPL	Stock	134.3	134.3414	134.17	134.21	7010328.0
2021-04-23 17:00:00	AAPL	Stock	134.21	134.32	134.17	134.25	107166.0
2021-04-23 18:00:00	AAPL	Stock	134.26	134.31	134.23	134.26	58363.0
2021-04-23 19:00:00	AAPL	Stock	134.26	134.3	134.22	134.29	36709.0
2021-04-23 04:00:00	MSFT	Stock	257.69	258.23	257.69	258.13	3852.0
2021-04-23 05:00:00	MSFT	Stock	258.1	258.1	257.73	257.74	2584.0
2021-04-23 06:00:00	MSFT	Stock	257.74	258.2	257.62	258.01	6352.0
2021-04-23 07:00:00	MSFT	Stock	257.76	258.0	257.68	257.8	14016.0
2021-04-23 08:00:00	MSFT	Stock	257.8499	258.0	257.17	257.88	54765.0
2021-04-23 09:00:00	MSFT	Stock	257.9	258.67	257.27	258.5	1447211.0
2021-04-23 10:00:00	MSFT	Stock	258.45	259.85	257.96	259.81	1757995.0
2021-04-23 11:00:00	MSFT	Stock	259.82	260.81	259.31	260.47	1968771.0
2021-04-23 12:00:00	MSFT	Stock	260.48	261.41	260.36	261.1	1451462.0
2021-04-23 13:00:00	MSFT	Stock	261.11	261.18	260.2	260.81	1136416.0
2021-04-23 14:00:00	MSFT	Stock	260.8	261.21	260.67	261.02	1197037.0
2021-04-23 15:00:00	MSFT	Stock	261.0299	261.51	260.686	261.14	3722640.0
2021-04-23 16:00:00	MSFT	Stock	261.14	261.5	260.6	260.8	3912370.0
2021-04-23 17:00:00	MSFT	Stock	260.8	261.94	260.8	261.56	40746.0
2021-04-23 18:00:00	MSFT	Stock	261.58	261.78	261.35	261.7	19634.0
2021-04-23 19:00:00	MSFT	Stock	261.7	261.98	261.59	261.59	15231.0
2021-04-23 04:00:00	NVDA	Stock	14.871	14.871	14.871	14.871	5440.0
2021-04-23 05:00:00	NVDA	Stock	14.9068	14.9068	14.871	14.871	16680.0
2021-04-23 06:00:00	NVDA	Stock	14.875	14.875	14.871	14.871	14040.0
2021-04-23 07:00:00	NVDA	Stock	14.8982	14.9245	14.8875	14.9	154960.0
2021-04-23 08:00:00	NVDA	Stock	14.8805	14.9083	14.875	14.9083	376880.0
2021-04-23 09:00:00	NVDA	Stock	14.9	15.129	14.87	15.121	27512760.0
2021-04-23 10:00:00	NVDA	Stock	15.1252	15.1475	15.0461	15.0932	16191640.0
2021-04-23 11:00:00	NVDA	Stock	15.0942	15.195	15.0658	15.1577	15101000.0
2021-04-23 12:00:00	NVDA	Stock	15.1575	15.2345	15.1558	15.2152	10703640.0
2021-04-23 13:00:00	NVDA	Stock	15.2155	15.245	15.1912	15.225	6900720.0
2021-04-23 14:00:00	NVDA	Stock	15.2232	15.2648	15.1925	15.2485	11722240.0
2021-04-23 15:00:00	NVDA	Stock	15.2485	15.3349	15.2325	15.2655	30678360.0
2021-04-23 16:00:00	NVDA	Stock	15.2653	15.2685	15.2375	15.25	20627000.0
2021-04-23 17:00:00	NVDA	Stock	15.245	15.25	15.24	15.25	133400.0
2021-04-23 18:00:00	NVDA	Stock	15.24	15.25	15.24	15.25	56640.0
2021-04-23 19:00:00	NVDA	Stock	15.2525	15.2525	15.24	15.25	102760.0
2021-04-23 05:00:00	AMZN	Stock	165.7485	165.7485	165.7485	165.7485	2000.0
2021-04-23 07:00:00	AMZN	Stock	165.9	165.9	165.7	165.8	12780.0

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

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