PREVIEW / stock_1hour / 2020-07-09

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-07-09.parquet
  size:    1.2 MB
  rows:    56,518
  symbols: 2,428

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-07-09 04:00:00	AAPL	Stock	95.695	95.795	95.6925	95.75	27168.0
2020-07-09 05:00:00	AAPL	Stock	95.7625	96.24	95.7375	96.2175	55948.0
2020-07-09 06:00:00	AAPL	Stock	96.205	96.225	95.905	95.9325	53832.0
2020-07-09 07:00:00	AAPL	Stock	95.9825	96.2175	95.9325	96.125	299288.0
2020-07-09 08:00:00	AAPL	Stock	96.1808	96.3475	95.58	96.21	590896.0
2020-07-09 09:00:00	AAPL	Stock	96.205	98.4775	95.575	96.0575	15542936.0
2020-07-09 10:00:00	AAPL	Stock	96.0625	96.2	94.905	94.9235	17265064.0
2020-07-09 11:00:00	AAPL	Stock	94.9175	95.4225	94.6725	95.3412	14110416.0
2020-07-09 12:00:00	AAPL	Stock	95.3175	95.8118	95.25	95.725	9456196.0
2020-07-09 13:00:00	AAPL	Stock	95.725	95.875	95.2875	95.3675	8045020.0
2020-07-09 14:00:00	AAPL	Stock	95.3692	95.7625	95.295	95.69	7495380.0
2020-07-09 15:00:00	AAPL	Stock	95.68	96.035	95.0	95.665	19386036.0
2020-07-09 16:00:00	AAPL	Stock	95.6625	95.7875	95.6275	95.65	5483856.0
2020-07-09 17:00:00	AAPL	Stock	95.6375	95.6875	95.525	95.5625	48796.0
2020-07-09 18:00:00	AAPL	Stock	95.565	95.6975	95.53	95.6275	53728.0
2020-07-09 19:00:00	AAPL	Stock	95.64	95.875	95.64	95.8725	123848.0
2020-07-09 04:00:00	MSFT	Stock	213.88	214.2	213.8	213.85	8034.0
2020-07-09 05:00:00	MSFT	Stock	213.86	214.6	213.75	214.55	7434.0
2020-07-09 06:00:00	MSFT	Stock	214.6	214.95	214.06	214.24	11850.0
2020-07-09 07:00:00	MSFT	Stock	214.4	215.86	214.1	215.66	90208.0
2020-07-09 08:00:00	MSFT	Stock	214.55	216.25	214.25	215.78	143249.0
2020-07-09 09:00:00	MSFT	Stock	215.8	216.4	214.406	215.62	4101973.0
2020-07-09 10:00:00	MSFT	Stock	215.64	215.72	211.93	212.04	4657931.0
2020-07-09 11:00:00	MSFT	Stock	212.02	213.11	211.47	212.79	3311784.0
2020-07-09 12:00:00	MSFT	Stock	212.78	214.18	212.54	213.648	2585749.0
2020-07-09 13:00:00	MSFT	Stock	213.63	214.34	212.98	213.2	2169921.0
2020-07-09 14:00:00	MSFT	Stock	213.21	214.3	212.99	214.147	2441270.0
2020-07-09 15:00:00	MSFT	Stock	214.14	214.65	212.92	214.4	4721950.0
2020-07-09 16:00:00	MSFT	Stock	214.4	214.4	213.53	214.0	2898178.0
2020-07-09 17:00:00	MSFT	Stock	214.06	214.1	213.95	213.99	8004.0
2020-07-09 18:00:00	MSFT	Stock	213.93	214.25	213.87	214.05	19822.0
2020-07-09 19:00:00	MSFT	Stock	214.05	214.5	213.93	214.46	35339.0
2020-07-09 04:00:00	NVDA	Stock	10.275	10.275	10.275	10.275	4720.0
2020-07-09 05:00:00	NVDA	Stock	10.321	10.329	10.321	10.3275	78840.0
2020-07-09 06:00:00	NVDA	Stock	10.3375	10.3528	10.322	10.3295	96960.0
2020-07-09 07:00:00	NVDA	Stock	10.33	10.3775	10.33	10.3775	841360.0
2020-07-09 08:00:00	NVDA	Stock	10.3472	10.3938	10.3228	10.3804	1732800.0
2020-07-09 09:00:00	NVDA	Stock	10.38	10.446	10.275	10.4353	59907080.0
2020-07-09 10:00:00	NVDA	Stock	10.4323	10.5172	10.2557	10.265	86167960.0
2020-07-09 11:00:00	NVDA	Stock	10.2642	10.3623	10.2335	10.3412	56065920.0
2020-07-09 12:00:00	NVDA	Stock	10.335	10.442	10.3166	10.4245	37686840.0
2020-07-09 13:00:00	NVDA	Stock	10.4265	10.4949	10.406	10.4225	36691960.0
2020-07-09 14:00:00	NVDA	Stock	10.4138	10.5165	10.4073	10.5117	29597080.0
2020-07-09 15:00:00	NVDA	Stock	10.51	10.57	10.4475	10.509	57004000.0
2020-07-09 16:00:00	NVDA	Stock	10.5098	10.52	10.489	10.5	20414360.0
2020-07-09 17:00:00	NVDA	Stock	10.498	10.5	10.4828	10.4875	101480.0
2020-07-09 18:00:00	NVDA	Stock	10.49	10.5	10.4825	10.5	107280.0
2020-07-09 19:00:00	NVDA	Stock	10.507	10.5472	10.5	10.5425	249240.0
2020-07-09 05:00:00	AMZN	Stock	155.156	155.5	155.0	155.5	24320.0
2020-07-09 06:00:00	AMZN	Stock	155.65	155.75	155.5395	155.5395	31140.0

> showing 50 of 56,518 rows — these rows as CSV

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