PREVIEW / stock_1hour / 2021-03-17

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-03-17.parquet
  size:    1.5 MB
  rows:    68,058
  symbols: 2,904

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-03-17 04:00:00	AAPL	Stock	125.0	125.53	124.84	125.12	17505.0
2021-03-17 05:00:00	AAPL	Stock	125.05	125.12	124.63	124.63	14602.0
2021-03-17 06:00:00	AAPL	Stock	124.75	124.92	124.6	124.62	19457.0
2021-03-17 07:00:00	AAPL	Stock	124.66	124.84	123.52	123.8	366368.0
2021-03-17 08:00:00	AAPL	Stock	124.6201	125.883	123.54	124.15	555109.0
2021-03-17 09:00:00	AAPL	Stock	124.15	125.6265	122.82	123.2793	13918321.0
2021-03-17 10:00:00	AAPL	Stock	123.28	123.6299	122.79	123.04	12150610.0
2021-03-17 11:00:00	AAPL	Stock	123.04	123.058	122.47	122.66	10861500.0
2021-03-17 12:00:00	AAPL	Stock	122.665	122.9	122.39	122.4708	7552649.0
2021-03-17 13:00:00	AAPL	Stock	122.47	122.93	122.336	122.8264	6176463.0
2021-03-17 14:00:00	AAPL	Stock	122.83	125.39	122.83	125.365	20773197.0
2021-03-17 15:00:00	AAPL	Stock	125.36	125.8599	124.29	124.8	16919186.0
2021-03-17 16:00:00	AAPL	Stock	124.78	124.81	124.47	124.5	8161442.0
2021-03-17 17:00:00	AAPL	Stock	124.5	124.75	124.48	124.73	83797.0
2021-03-17 18:00:00	AAPL	Stock	124.73	124.86	124.65	124.72	124518.0
2021-03-17 19:00:00	AAPL	Stock	124.72	124.95	124.67	124.95	105422.0
2021-03-17 04:00:00	MSFT	Stock	237.69	237.71	237.4	237.4	947.0
2021-03-17 05:00:00	MSFT	Stock	237.46	237.46	237.24	237.3	3369.0
2021-03-17 06:00:00	MSFT	Stock	237.0	237.1	237.0	237.1	241.0
2021-03-17 07:00:00	MSFT	Stock	237.38	237.4	235.67	236.16	35342.0
2021-03-17 08:00:00	MSFT	Stock	236.85	237.5	235.59	236.3	31771.0
2021-03-17 09:00:00	MSFT	Stock	236.3	237.603	234.17	236.15	2110420.0
2021-03-17 10:00:00	MSFT	Stock	236.165	236.59	234.82	234.99	2011639.0
2021-03-17 11:00:00	MSFT	Stock	234.98	235.03	233.74	233.825	1868957.0
2021-03-17 12:00:00	MSFT	Stock	233.81	234.6	233.23	233.79	1932283.0
2021-03-17 13:00:00	MSFT	Stock	233.77	234.77	233.62	234.4573	1677604.0
2021-03-17 14:00:00	MSFT	Stock	234.48	238.14	234.48	237.94	3274555.0
2021-03-17 15:00:00	MSFT	Stock	237.93	238.55	236.44	237.19	3377878.0
2021-03-17 16:00:00	MSFT	Stock	237.04	237.37	236.57	236.57	4731177.0
2021-03-17 17:00:00	MSFT	Stock	236.7	237.04	236.65	237.04	7685.0
2021-03-17 18:00:00	MSFT	Stock	236.96	237.67	236.96	237.02	2210.0
2021-03-17 19:00:00	MSFT	Stock	237.04	237.4	237.0	237.26	3644.0
2021-03-17 04:00:00	NVDA	Stock	13.3	13.3	13.3	13.3	8000.0
2021-03-17 06:00:00	NVDA	Stock	13.1958	13.1962	13.1958	13.1962	11400.0
2021-03-17 07:00:00	NVDA	Stock	13.182	13.182	13.0428	13.05	352480.0
2021-03-17 08:00:00	NVDA	Stock	13.1622	13.245	13.0018	13.0722	803520.0
2021-03-17 09:00:00	NVDA	Stock	13.0675	13.235	12.9895	13.1918	26789800.0
2021-03-17 10:00:00	NVDA	Stock	13.188	13.247	13.0815	13.144	13804960.0
2021-03-17 11:00:00	NVDA	Stock	13.1311	13.1624	13.0255	13.0388	15423400.0
2021-03-17 12:00:00	NVDA	Stock	13.0325	13.1482	13.0125	13.0431	9221160.0
2021-03-17 13:00:00	NVDA	Stock	13.0338	13.1328	13.0258	13.101	7477720.0
2021-03-17 14:00:00	NVDA	Stock	13.112	13.4048	13.1095	13.3762	30702560.0
2021-03-17 15:00:00	NVDA	Stock	13.3835	13.4532	13.2698	13.3495	24701280.0
2021-03-17 16:00:00	NVDA	Stock	13.3412	13.3545	13.3368	13.3368	17565640.0
2021-03-17 17:00:00	NVDA	Stock	13.335	13.3412	13.3275	13.3275	53080.0
2021-03-17 18:00:00	NVDA	Stock	13.353	13.3692	13.3502	13.3502	76320.0
2021-03-17 19:00:00	NVDA	Stock	13.353	13.3838	13.3475	13.3838	183040.0
2021-03-17 06:00:00	AMZN	Stock	154.05	154.45	154.05	154.1505	6000.0
2021-03-17 07:00:00	AMZN	Stock	153.75	153.75	152.9	153.0	36180.0
2021-03-17 08:00:00	AMZN	Stock	153.85	153.85	153.0	153.25	36320.0

> showing 50 of 68,058 rows — these rows as CSV

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