PREVIEW / stock_1hour / 2021-03-03

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-03-03.parquet
  size:    1.5 MB
  rows:    69,154
  symbols: 2,856

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-03 04:00:00	AAPL	Stock	126.22	126.7	126.0	126.12	42493.0
2021-03-03 05:00:00	AAPL	Stock	126.1	126.3	125.6	126.0	18224.0
2021-03-03 06:00:00	AAPL	Stock	125.99	126.19	125.95	126.18	13672.0
2021-03-03 07:00:00	AAPL	Stock	126.12	126.2	125.53	125.65	241904.0
2021-03-03 08:00:00	AAPL	Stock	126.12	126.15	124.5	124.63	852119.0
2021-03-03 09:00:00	AAPL	Stock	124.62	125.71	123.75	124.0	12697376.0
2021-03-03 10:00:00	AAPL	Stock	124.0	124.7	123.1116	124.6324	15643681.0
2021-03-03 11:00:00	AAPL	Stock	124.63	124.935	124.02	124.0593	8550512.0
2021-03-03 12:00:00	AAPL	Stock	124.06	124.4699	123.45	123.47	7866085.0
2021-03-03 13:00:00	AAPL	Stock	123.47	124.17	122.93	123.14	9457057.0
2021-03-03 14:00:00	AAPL	Stock	123.145	123.21	121.84	122.81	13689186.0
2021-03-03 15:00:00	AAPL	Stock	122.81	122.975	122.0	122.06	15535675.0
2021-03-03 16:00:00	AAPL	Stock	122.06	123.3609	121.9	122.12	11094650.0
2021-03-03 17:00:00	AAPL	Stock	122.14	122.27	122.06	122.12	98825.0
2021-03-03 18:00:00	AAPL	Stock	122.08	122.16	121.4	121.4	293046.0
2021-03-03 19:00:00	AAPL	Stock	121.46	121.97	121.25	121.7	243912.0
2021-03-03 04:00:00	MSFT	Stock	235.45	235.87	235.01	235.01	7946.0
2021-03-03 05:00:00	MSFT	Stock	234.89	235.39	234.7	234.78	3141.0
2021-03-03 06:00:00	MSFT	Stock	235.1	235.48	235.01	235.48	764.0
2021-03-03 07:00:00	MSFT	Stock	235.5	235.5	234.4	234.62	15500.0
2021-03-03 08:00:00	MSFT	Stock	235.5	235.5	231.88	232.86	63096.0
2021-03-03 09:00:00	MSFT	Stock	232.73	233.5799	230.51	230.75	3016376.0
2021-03-03 10:00:00	MSFT	Stock	230.71	231.12	229.43	230.77	3582523.0
2021-03-03 11:00:00	MSFT	Stock	230.755	231.56	230.52	230.66	1875957.0
2021-03-03 12:00:00	MSFT	Stock	230.64	230.6618	229.3	229.3191	2229865.0
2021-03-03 13:00:00	MSFT	Stock	229.3	229.98	228.5	228.87	2130948.0
2021-03-03 14:00:00	MSFT	Stock	228.875	229.0	227.41	228.31	2504600.0
2021-03-03 15:00:00	MSFT	Stock	228.31	228.79	227.28	227.55	4437022.0
2021-03-03 16:00:00	MSFT	Stock	227.26	229.2241	227.02	227.33	4723204.0
2021-03-03 17:00:00	MSFT	Stock	227.5	227.6047	227.35	227.36	16423.0
2021-03-03 18:00:00	MSFT	Stock	227.6	227.6	225.55	225.55	37629.0
2021-03-03 19:00:00	MSFT	Stock	225.56	227.19	225.5	227.05	27832.0
2021-03-03 04:00:00	NVDA	Stock	13.554	13.555	13.5378	13.5425	51400.0
2021-03-03 05:00:00	NVDA	Stock	13.525	13.525	13.4975	13.4975	16000.0
2021-03-03 06:00:00	NVDA	Stock	13.5162	13.5162	13.5162	13.5162	4000.0
2021-03-03 07:00:00	NVDA	Stock	13.5148	13.5342	13.4812	13.4812	386520.0
2021-03-03 08:00:00	NVDA	Stock	13.5379	13.54	13.3248	13.4113	893200.0
2021-03-03 09:00:00	NVDA	Stock	13.4	13.4548	13.0785	13.1215	30533760.0
2021-03-03 10:00:00	NVDA	Stock	13.119	13.17	12.952	13.088	37766480.0
2021-03-03 11:00:00	NVDA	Stock	13.0885	13.1485	13.0432	13.056	17769800.0
2021-03-03 12:00:00	NVDA	Stock	13.0566	13.0838	12.9715	12.9825	15835960.0
2021-03-03 13:00:00	NVDA	Stock	12.975	13.0278	12.878	12.9	18397560.0
2021-03-03 14:00:00	NVDA	Stock	12.9045	12.948	12.8162	12.9375	28379640.0
2021-03-03 15:00:00	NVDA	Stock	12.9365	12.947	12.7988	12.8095	40360320.0
2021-03-03 16:00:00	NVDA	Stock	12.8048	12.9899	12.8048	12.829	24618000.0
2021-03-03 17:00:00	NVDA	Stock	12.825	12.8325	12.814	12.8322	215000.0
2021-03-03 18:00:00	NVDA	Stock	12.831	12.831	12.7608	12.7608	385680.0
2021-03-03 19:00:00	NVDA	Stock	12.7575	12.8	12.7575	12.7975	230520.0
2021-03-03 04:00:00	AMZN	Stock	156.05	156.05	156.0	156.0	4400.0
2021-03-03 07:00:00	AMZN	Stock	155.9	156.0	155.363	155.575	78760.0

> showing 50 of 69,154 rows — these rows as CSV

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