PREVIEW / stock_1hour / 2021-01-13

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-01-13.parquet
  size:    1.4 MB
  rows:    66,029
  symbols: 2,694

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-01-13 04:00:00	AAPL	Stock	129.3	130.0	129.3	129.82	18994.0
2021-01-13 05:00:00	AAPL	Stock	129.78	130.0	129.45	129.7	45379.0
2021-01-13 06:00:00	AAPL	Stock	129.79	129.92	129.23	129.67	31234.0
2021-01-13 07:00:00	AAPL	Stock	129.73	129.8	128.66	128.9	394893.0
2021-01-13 08:00:00	AAPL	Stock	129.39	129.7	128.29	129.17	511138.0
2021-01-13 09:00:00	AAPL	Stock	129.16	130.2	128.49	129.83	12279851.0
2021-01-13 10:00:00	AAPL	Stock	129.83	131.26	129.32	131.03	15765546.0
2021-01-13 11:00:00	AAPL	Stock	131.031	131.45	130.721	131.15	11797667.0
2021-01-13 12:00:00	AAPL	Stock	131.16	131.19	130.41	131.13	9407663.0
2021-01-13 13:00:00	AAPL	Stock	131.12	131.29	130.77	130.855	5230775.0
2021-01-13 14:00:00	AAPL	Stock	130.855	131.2	130.731	131.0	5946459.0
2021-01-13 15:00:00	AAPL	Stock	131.01	131.13	130.6	130.89	9196508.0
2021-01-13 16:00:00	AAPL	Stock	131.18	131.18	130.75	130.83	8648903.0
2021-01-13 17:00:00	AAPL	Stock	130.79	130.93	130.76	130.93	48851.0
2021-01-13 18:00:00	AAPL	Stock	130.93	131.11	130.81	131.03	84919.0
2021-01-13 19:00:00	AAPL	Stock	130.95	131.28	130.95	131.28	113930.0
2021-01-13 04:00:00	MSFT	Stock	215.3	215.3	215.3	215.3	2000.0
2021-01-13 05:00:00	MSFT	Stock	215.64	215.98	215.2	215.2	6467.0
2021-01-13 06:00:00	MSFT	Stock	215.22	215.22	214.11	214.52	2852.0
2021-01-13 07:00:00	MSFT	Stock	214.69	214.8	213.75	213.75	25912.0
2021-01-13 08:00:00	MSFT	Stock	214.8	214.8	213.5	214.25	38848.0
2021-01-13 09:00:00	MSFT	Stock	214.25	215.58	213.9	214.79	2426039.0
2021-01-13 10:00:00	MSFT	Stock	214.74	215.83	214.12	215.79	2374503.0
2021-01-13 11:00:00	MSFT	Stock	215.79	216.13	214.92	215.95	1648780.0
2021-01-13 12:00:00	MSFT	Stock	215.95	216.18	215.09	215.805	1394662.0
2021-01-13 13:00:00	MSFT	Stock	215.8	216.14	215.65	216.1	1030859.0
2021-01-13 14:00:00	MSFT	Stock	216.1	216.61	215.73	216.35	1219347.0
2021-01-13 15:00:00	MSFT	Stock	216.36	216.76	216.2	216.41	2115254.0
2021-01-13 16:00:00	MSFT	Stock	216.34	216.86	216.308	216.55	3361452.0
2021-01-13 17:00:00	MSFT	Stock	216.56	216.7	216.56	216.7	8267.0
2021-01-13 18:00:00	MSFT	Stock	216.7	216.79	216.56	216.56	10041.0
2021-01-13 19:00:00	MSFT	Stock	216.56	216.98	216.5	216.97	10011.0
2021-01-13 04:00:00	NVDA	Stock	13.472	13.4815	13.472	13.4815	40000.0
2021-01-13 06:00:00	NVDA	Stock	13.4722	13.4722	13.4722	13.4722	12880.0
2021-01-13 07:00:00	NVDA	Stock	13.4635	13.4848	13.4	13.4	712400.0
2021-01-13 08:00:00	NVDA	Stock	13.4238	13.5183	13.3925	13.4375	634120.0
2021-01-13 09:00:00	NVDA	Stock	13.4262	13.625	13.3615	13.491	35087040.0
2021-01-13 10:00:00	NVDA	Stock	13.4964	13.525	13.385	13.4908	25854200.0
2021-01-13 11:00:00	NVDA	Stock	13.4882	13.5718	13.4156	13.5195	20860440.0
2021-01-13 12:00:00	NVDA	Stock	13.5198	13.522	13.4582	13.468	11262960.0
2021-01-13 13:00:00	NVDA	Stock	13.478	13.595	13.478	13.5712	16373600.0
2021-01-13 14:00:00	NVDA	Stock	13.5712	13.6048	13.547	13.6005	13823240.0
2021-01-13 15:00:00	NVDA	Stock	13.6028	13.6048	13.5065	13.5305	26328080.0
2021-01-13 16:00:00	NVDA	Stock	13.5318	13.5766	13.5062	13.5312	14984160.0
2021-01-13 17:00:00	NVDA	Stock	13.5238	13.5412	13.5238	13.5318	26240.0
2021-01-13 18:00:00	NVDA	Stock	13.5375	13.5415	13.535	13.5415	127760.0
2021-01-13 19:00:00	NVDA	Stock	13.5375	13.5818	13.5375	13.5725	233040.0
2021-01-13 05:00:00	AMZN	Stock	156.304	156.304	156.304	156.304	2620.0
2021-01-13 06:00:00	AMZN	Stock	156.3	156.3	156.05	156.05	15260.0
2021-01-13 07:00:00	AMZN	Stock	156.382	156.4125	155.9155	155.9155	94740.0

> showing 50 of 66,029 rows — these rows as CSV

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