PREVIEW / stock_1hour / 2020-04-21

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-04-21.parquet
  size:    1.2 MB
  rows:    54,142
  symbols: 2,369

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
2020-04-21 04:00:00	AAPL	Stock	68.72	68.845	68.69	68.75	24916.0
2020-04-21 05:00:00	AAPL	Stock	68.77	68.775	68.45	68.4725	11620.0
2020-04-21 06:00:00	AAPL	Stock	68.4725	68.475	67.875	68.0175	39076.0
2020-04-21 07:00:00	AAPL	Stock	68.215	68.325	67.955	68.0375	213720.0
2020-04-21 08:00:00	AAPL	Stock	68.2275	69.62	67.8875	68.75	1775468.0
2020-04-21 09:00:00	AAPL	Stock	68.7125	69.3125	67.955	68.295	20976344.0
2020-04-21 10:00:00	AAPL	Stock	68.295	68.355	66.975	67.235	21964468.0
2020-04-21 11:00:00	AAPL	Stock	67.23	67.45	66.3575	66.93	19863584.0
2020-04-21 12:00:00	AAPL	Stock	66.93	66.98	66.5855	66.974	10628188.0
2020-04-21 13:00:00	AAPL	Stock	66.9738	67.5375	66.915	67.24	12470176.0
2020-04-21 14:00:00	AAPL	Stock	67.245	67.845	67.03	67.2125	14300088.0
2020-04-21 15:00:00	AAPL	Stock	67.2075	67.8142	67.005	67.09	26078712.0
2020-04-21 16:00:00	AAPL	Stock	67.111	67.2925	67.0875	67.1925	14162300.0
2020-04-21 17:00:00	AAPL	Stock	67.185	67.465	67.1305	67.395	76824.0
2020-04-21 18:00:00	AAPL	Stock	67.4325	67.575	67.0925	67.4025	114144.0
2020-04-21 19:00:00	AAPL	Stock	67.44	67.5625	67.25	67.5625	77264.0
2020-04-21 04:00:00	MSFT	Stock	174.6	174.6	173.89	174.42	5356.0
2020-04-21 05:00:00	MSFT	Stock	174.45	174.45	173.34	173.34	1351.0
2020-04-21 06:00:00	MSFT	Stock	173.43	173.52	172.3	172.7	16412.0
2020-04-21 07:00:00	MSFT	Stock	172.99	173.35	172.51	173.02	39410.0
2020-04-21 08:00:00	MSFT	Stock	172.95	175.49	172.34	172.52	155772.0
2020-04-21 09:00:00	MSFT	Stock	172.535	173.67	170.71	172.19	6096393.0
2020-04-21 10:00:00	MSFT	Stock	172.21	172.293	166.41	166.69	9349736.0
2020-04-21 11:00:00	MSFT	Stock	166.67	167.87	166.11	167.815	6324348.0
2020-04-21 12:00:00	MSFT	Stock	167.81	168.537	167.0	167.35	4132739.0
2020-04-21 13:00:00	MSFT	Stock	167.34	170.3	167.22	170.2	4684788.0
2020-04-21 14:00:00	MSFT	Stock	170.21	171.15	168.47	168.71	4189955.0
2020-04-21 15:00:00	MSFT	Stock	168.74	170.39	167.0	167.67	7242645.0
2020-04-21 16:00:00	MSFT	Stock	168.67	168.67	167.61	168.25	5101463.0
2020-04-21 17:00:00	MSFT	Stock	168.35	168.88	168.2	168.78	33041.0
2020-04-21 18:00:00	MSFT	Stock	168.95	169.55	167.82	169.33	42902.0
2020-04-21 19:00:00	MSFT	Stock	169.34	169.45	168.55	169.34	27461.0
2020-04-21 04:00:00	NVDA	Stock	7.13	7.13	7.1025	7.1025	22040.0
2020-04-21 05:00:00	NVDA	Stock	7.1282	7.1282	7.1102	7.1102	14280.0
2020-04-21 06:00:00	NVDA	Stock	7.1	7.1	7.0722	7.075	38400.0
2020-04-21 07:00:00	NVDA	Stock	7.0692	7.0995	7.0665	7.0888	872600.0
2020-04-21 08:00:00	NVDA	Stock	7.0972	7.0998	7.025	7.0572	1679920.0
2020-04-21 09:00:00	NVDA	Stock	7.0572	7.1192	7.0	7.0558	72826760.0
2020-04-21 10:00:00	NVDA	Stock	7.0558	7.072	6.7155	6.7195	146883360.0
2020-04-21 11:00:00	NVDA	Stock	6.7201	6.7887	6.6778	6.7692	119182040.0
2020-04-21 12:00:00	NVDA	Stock	6.7695	6.8025	6.7235	6.7885	61404000.0
2020-04-21 13:00:00	NVDA	Stock	6.7875	6.8685	6.7835	6.8445	55557760.0
2020-04-21 14:00:00	NVDA	Stock	6.8442	6.9	6.7819	6.7895	60508000.0
2020-04-21 15:00:00	NVDA	Stock	6.7895	6.8465	6.7148	6.729	113426240.0
2020-04-21 16:00:00	NVDA	Stock	6.7378	6.7812	6.7248	6.746	25996880.0
2020-04-21 17:00:00	NVDA	Stock	6.7328	6.7625	6.7328	6.7412	1263960.0
2020-04-21 18:00:00	NVDA	Stock	6.7468	6.7812	6.7468	6.7662	772000.0
2020-04-21 19:00:00	NVDA	Stock	6.7625	6.7625	6.7438	6.7612	446480.0
2020-04-21 04:00:00	AMZN	Stock	120.25	120.25	120.25	120.25	2000.0
2020-04-21 05:00:00	AMZN	Stock	119.928	119.928	119.928	119.928	2000.0

> showing 50 of 54,142 rows — these rows as CSV

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