PREVIEW / stock_1hour / 2020-11-05

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-11-05.parquet
  size:    1.3 MB
  rows:    59,043
  symbols: 2,524

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-11-05 04:00:00	AAPL	Stock	117.7	118.4	117.5	118.1	98579.0
2020-11-05 05:00:00	AAPL	Stock	118.22	119.0	117.96	118.65	106477.0
2020-11-05 06:00:00	AAPL	Stock	118.65	118.95	118.13	118.21	71927.0
2020-11-05 07:00:00	AAPL	Stock	118.17	118.4	117.57	118.21	527797.0
2020-11-05 08:00:00	AAPL	Stock	117.98	118.29	115.23	117.989	1002104.0
2020-11-05 09:00:00	AAPL	Stock	117.98	119.62	116.869	118.77	22421736.0
2020-11-05 10:00:00	AAPL	Stock	118.761	119.24	117.58	118.4	20846365.0
2020-11-05 11:00:00	AAPL	Stock	118.39	118.59	117.92	118.11	10580535.0
2020-11-05 12:00:00	AAPL	Stock	118.12	118.38	117.41	117.98	10341179.0
2020-11-05 13:00:00	AAPL	Stock	117.98	118.47	117.84	118.41	7899778.0
2020-11-05 14:00:00	AAPL	Stock	118.4	119.27	118.345	119.163	12194446.0
2020-11-05 15:00:00	AAPL	Stock	119.16	119.3	118.455	118.99	17122997.0
2020-11-05 16:00:00	AAPL	Stock	119.03	119.3	118.96	119.2	10248909.0
2020-11-05 17:00:00	AAPL	Stock	119.18	119.25	119.15	119.17	124762.0
2020-11-05 18:00:00	AAPL	Stock	119.16	119.2	118.5	118.72	287163.0
2020-11-05 19:00:00	AAPL	Stock	118.7	118.72	117.98	118.0	362680.0
2020-11-05 04:00:00	MSFT	Stock	220.63	222.28	220.63	222.03	17723.0
2020-11-05 05:00:00	MSFT	Stock	222.47	223.49	222.0	222.5	25769.0
2020-11-05 06:00:00	MSFT	Stock	222.51	222.86	221.79	222.04	45091.0
2020-11-05 07:00:00	MSFT	Stock	222.04	222.9	221.5	222.26	125975.0
2020-11-05 08:00:00	MSFT	Stock	222.15	222.8	221.5	222.0	178531.0
2020-11-05 09:00:00	MSFT	Stock	221.95	223.6	221.15	222.85	5252905.0
2020-11-05 10:00:00	MSFT	Stock	222.84	224.0	221.5	223.23	4795350.0
2020-11-05 11:00:00	MSFT	Stock	223.22	223.34	221.78	221.98	2658602.0
2020-11-05 12:00:00	MSFT	Stock	221.99	222.95	221.52	222.75	2456250.0
2020-11-05 13:00:00	MSFT	Stock	222.77	223.48	222.69	223.285	2054216.0
2020-11-05 14:00:00	MSFT	Stock	223.31	224.12	223.16	224.01	2646953.0
2020-11-05 15:00:00	MSFT	Stock	224.01	224.09	222.01	223.29	4583829.0
2020-11-05 16:00:00	MSFT	Stock	223.29	224.0	223.26	223.8	4568811.0
2020-11-05 17:00:00	MSFT	Stock	223.8	223.86	223.57	223.67	9310.0
2020-11-05 18:00:00	MSFT	Stock	223.6	223.74	222.35	222.7	25528.0
2020-11-05 19:00:00	MSFT	Stock	222.78	222.96	222.21	222.27	24663.0
2020-11-05 04:00:00	NVDA	Stock	14.0028	14.1523	14.0028	14.1523	440760.0
2020-11-05 05:00:00	NVDA	Stock	14.1718	14.1785	14.16	14.1725	345800.0
2020-11-05 06:00:00	NVDA	Stock	14.1725	14.1885	14.1128	14.1128	135880.0
2020-11-05 07:00:00	NVDA	Stock	14.1312	14.175	14.0502	14.175	2485520.0
2020-11-05 08:00:00	NVDA	Stock	14.0553	14.206	13.8285	14.1925	2598200.0
2020-11-05 09:00:00	NVDA	Stock	14.175	14.2952	14.013	14.2524	65841400.0
2020-11-05 10:00:00	NVDA	Stock	14.2548	14.339	14.0538	14.1646	52816720.0
2020-11-05 11:00:00	NVDA	Stock	14.1668	14.195	14.0738	14.0818	26591840.0
2020-11-05 12:00:00	NVDA	Stock	14.09	14.1382	13.991	14.0494	23829480.0
2020-11-05 13:00:00	NVDA	Stock	14.0542	14.1285	14.0465	14.0935	12288240.0
2020-11-05 14:00:00	NVDA	Stock	14.0946	14.1712	14.0852	14.1685	18444560.0
2020-11-05 15:00:00	NVDA	Stock	14.1655	14.1885	14.0695	14.1602	34372840.0
2020-11-05 16:00:00	NVDA	Stock	14.16	14.217	14.1586	14.2125	2975480.0
2020-11-05 17:00:00	NVDA	Stock	14.2	14.2025	14.1725	14.1725	177400.0
2020-11-05 18:00:00	NVDA	Stock	14.1668	14.175	14.103	14.125	347280.0
2020-11-05 19:00:00	NVDA	Stock	14.1125	14.1278	13.8803	13.925	895800.0
2020-11-05 04:00:00	AMZN	Stock	165.111	165.827	165.111	165.827	8440.0
2020-11-05 06:00:00	AMZN	Stock	166.45	166.95	166.023	166.023	22140.0

> showing 50 of 59,043 rows — these rows as CSV

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