PREVIEW / stock_1hour / 2020-09-03

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-09-03.parquet
  size:    1.3 MB
  rows:    58,318
  symbols: 2,474

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-09-03 04:00:00	AAPL	Stock	131.9	132.25	130.31	130.5	74154.0
2020-09-03 05:00:00	AAPL	Stock	130.79	130.79	128.32	128.32	133223.0
2020-09-03 06:00:00	AAPL	Stock	128.31	129.49	128.18	129.15	132272.0
2020-09-03 07:00:00	AAPL	Stock	129.1	129.7	127.7	128.4	739563.0
2020-09-03 08:00:00	AAPL	Stock	129.25	129.696	127.6	127.85	1890938.0
2020-09-03 09:00:00	AAPL	Stock	127.75	128.84	126.27	127.345	25648771.0
2020-09-03 10:00:00	AAPL	Stock	127.32	127.79	123.22	124.98	40078547.0
2020-09-03 11:00:00	AAPL	Stock	124.975	125.17	120.72	124.1	39132386.0
2020-09-03 12:00:00	AAPL	Stock	124.115	124.41	122.08	122.695	19950624.0
2020-09-03 13:00:00	AAPL	Stock	122.698	123.84	121.81	122.756	18747544.0
2020-09-03 14:00:00	AAPL	Stock	122.76	123.4	121.77	121.77	14964075.0
2020-09-03 15:00:00	AAPL	Stock	121.808	122.29	120.5	120.92	39627634.0
2020-09-03 16:00:00	AAPL	Stock	120.94	122.965	120.07	121.4	18447194.0
2020-09-03 17:00:00	AAPL	Stock	121.35	121.65	119.0	119.2	1357708.0
2020-09-03 18:00:00	AAPL	Stock	119.26	119.7	117.25	117.3	1331504.0
2020-09-03 19:00:00	AAPL	Stock	117.3	118.01	116.7	117.19	1295162.0
2020-09-03 04:00:00	MSFT	Stock	231.21	231.22	230.33	230.46	4418.0
2020-09-03 05:00:00	MSFT	Stock	230.33	230.6	229.52	229.52	20092.0
2020-09-03 06:00:00	MSFT	Stock	229.79	230.23	229.4	229.4	14704.0
2020-09-03 07:00:00	MSFT	Stock	229.5	229.98	228.97	229.35	63764.0
2020-09-03 08:00:00	MSFT	Stock	229.21	230.075	229.0	229.62	88067.0
2020-09-03 09:00:00	MSFT	Stock	229.63	230.2	226.0	226.63	3822781.0
2020-09-03 10:00:00	MSFT	Stock	226.59	226.8	221.82	223.02	5638681.0
2020-09-03 11:00:00	MSFT	Stock	222.99	223.12	218.351	220.12	6419301.0
2020-09-03 12:00:00	MSFT	Stock	220.1	220.8	218.02	218.24	3396740.0
2020-09-03 13:00:00	MSFT	Stock	218.22	219.71	217.05	217.94	3840964.0
2020-09-03 14:00:00	MSFT	Stock	217.94	218.92	216.33	216.33	3743987.0
2020-09-03 15:00:00	MSFT	Stock	216.362	218.4	214.96	217.3	10493022.0
2020-09-03 16:00:00	MSFT	Stock	217.3	218.79	216.72	217.47	7516452.0
2020-09-03 17:00:00	MSFT	Stock	217.54	217.54	215.39	216.1	92556.0
2020-09-03 18:00:00	MSFT	Stock	216.28	217.5	215.0	215.18	110028.0
2020-09-03 19:00:00	MSFT	Stock	215.3	215.38	213.32	213.98	88867.0
2020-09-03 04:00:00	NVDA	Stock	14.3185	14.3185	14.2325	14.2325	153160.0
2020-09-03 05:00:00	NVDA	Stock	14.175	14.2208	14.05	14.05	282000.0
2020-09-03 06:00:00	NVDA	Stock	14.025	14.125	14.0	14.1055	299800.0
2020-09-03 07:00:00	NVDA	Stock	14.1	14.15	14.0065	14.038	1612760.0
2020-09-03 08:00:00	NVDA	Stock	14.1235	14.145	13.9375	14.0018	3694400.0
2020-09-03 09:00:00	NVDA	Stock	14.0015	14.015	13.5125	13.6826	102129040.0
2020-09-03 10:00:00	NVDA	Stock	13.6842	13.8022	13.05	13.3595	190581800.0
2020-09-03 11:00:00	NVDA	Stock	13.3576	13.365	12.8788	13.2615	146105840.0
2020-09-03 12:00:00	NVDA	Stock	13.2618	13.311	13.0	13.0138	69572360.0
2020-09-03 13:00:00	NVDA	Stock	13.0162	13.1548	12.9335	13.0788	64518840.0
2020-09-03 14:00:00	NVDA	Stock	13.0758	13.1312	12.9625	12.9628	52011560.0
2020-09-03 15:00:00	NVDA	Stock	12.9673	13.0486	12.9	13.0188	108969000.0
2020-09-03 16:00:00	NVDA	Stock	13.0155	13.0442	12.875	12.8963	30254720.0
2020-09-03 17:00:00	NVDA	Stock	12.9035	13.0155	12.5375	12.6125	4789240.0
2020-09-03 18:00:00	NVDA	Stock	12.6	12.6	12.2778	12.3	6423920.0
2020-09-03 19:00:00	NVDA	Stock	12.3203	12.3723	12.2752	12.35	2660080.0
2020-09-03 04:00:00	AMZN	Stock	176.4	176.4	176.4	176.4	6180.0
2020-09-03 05:00:00	AMZN	Stock	176.0345	176.0345	175.25	175.25	7280.0

> showing 50 of 58,318 rows — these rows as CSV

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