PREVIEW / stock_30min / 2021-03-09

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-03-09.parquet
  size:    2.3 MB
  rows:    118,264
  symbols: 2,875

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-09 04:00:00	AAPL	Stock	118.16	118.88	118.11	118.74	49765.0
2021-03-09 04:30:00	AAPL	Stock	118.71	119.25	118.5	119.0	48240.0
2021-03-09 05:00:00	AAPL	Stock	119.0	119.15	118.74	118.85	34010.0
2021-03-09 05:30:00	AAPL	Stock	118.84	119.29	118.84	119.05	26326.0
2021-03-09 06:00:00	AAPL	Stock	119.14	119.65	119.1	119.63	42385.0
2021-03-09 06:30:00	AAPL	Stock	119.62	119.78	119.31	119.55	48157.0
2021-03-09 07:00:00	AAPL	Stock	119.48	119.62	118.68	118.86	411569.0
2021-03-09 07:30:00	AAPL	Stock	118.85	118.99	118.54	118.58	193945.0
2021-03-09 08:00:00	AAPL	Stock	119.1299	119.24	118.5	118.73	828986.0
2021-03-09 08:30:00	AAPL	Stock	118.73	118.99	118.53	118.9	486217.0
2021-03-09 09:00:00	AAPL	Stock	118.9	119.19	118.63	119.04	912816.0
2021-03-09 09:30:00	AAPL	Stock	119.01	120.48	118.79	120.28	18915280.0
2021-03-09 10:00:00	AAPL	Stock	120.28	121.5599	120.26	121.317	12944168.0
2021-03-09 10:30:00	AAPL	Stock	121.315	121.37	120.07	120.2799	8835594.0
2021-03-09 11:00:00	AAPL	Stock	120.27	120.66	120.05	120.4271	5593389.0
2021-03-09 11:30:00	AAPL	Stock	120.43	120.68	120.2	120.5559	4579503.0
2021-03-09 12:00:00	AAPL	Stock	120.56	121.235	120.465	121.1034	4474892.0
2021-03-09 12:30:00	AAPL	Stock	121.1	121.2399	120.75	120.875	4081840.0
2021-03-09 13:00:00	AAPL	Stock	120.88	121.69	120.88	121.565	5561155.0
2021-03-09 13:30:00	AAPL	Stock	121.57	121.95	121.46	121.63	4959767.0
2021-03-09 14:00:00	AAPL	Stock	121.635	121.73	121.1	121.155	4262551.0
2021-03-09 14:30:00	AAPL	Stock	121.16	121.71	121.065	121.5548	3982124.0
2021-03-09 15:00:00	AAPL	Stock	121.55	122.06	121.4601	121.725	5248636.0
2021-03-09 15:30:00	AAPL	Stock	121.73	121.95	120.82	121.08	11925176.0
2021-03-09 16:00:00	AAPL	Stock	121.085	121.085	120.75	120.8	12542996.0
2021-03-09 16:30:00	AAPL	Stock	120.83	121.1	120.8	121.05	158176.0
2021-03-09 17:00:00	AAPL	Stock	121.0	121.36	121.0	121.1501	60970.0
2021-03-09 17:30:00	AAPL	Stock	121.1501	121.3	121.0	121.22	75124.0
2021-03-09 18:00:00	AAPL	Stock	121.23	121.28	121.05	121.11	78700.0
2021-03-09 18:30:00	AAPL	Stock	121.11	121.3	121.1	121.25	105112.0
2021-03-09 19:00:00	AAPL	Stock	121.23	121.28	121.0	121.06	90667.0
2021-03-09 19:30:00	AAPL	Stock	121.04	121.17	120.95	121.09	99409.0
2021-03-09 04:00:00	MSFT	Stock	230.3	232.0	230.3	231.98	7824.0
2021-03-09 04:30:00	MSFT	Stock	232.0	232.46	232.0	232.22	5730.0
2021-03-09 05:00:00	MSFT	Stock	232.16	232.44	231.5	231.97	1900.0
2021-03-09 05:30:00	MSFT	Stock	232.0	232.94	232.0	232.2	4539.0
2021-03-09 06:00:00	MSFT	Stock	232.04	232.9	232.04	232.89	3303.0
2021-03-09 06:30:00	MSFT	Stock	232.7	232.89	232.26	232.88	21120.0
2021-03-09 07:00:00	MSFT	Stock	232.475	232.475	231.55	231.6	24244.0
2021-03-09 07:30:00	MSFT	Stock	231.75	232.0	231.62	231.72	7678.0
2021-03-09 08:00:00	MSFT	Stock	232.0699	232.45	231.5	231.9	32698.0
2021-03-09 08:30:00	MSFT	Stock	232.1	232.76	231.78	232.39	51462.0
2021-03-09 09:00:00	MSFT	Stock	232.39	233.0	231.66	232.87	69492.0
2021-03-09 09:30:00	MSFT	Stock	232.88	234.09	231.67	233.74	3682258.0
2021-03-09 10:00:00	MSFT	Stock	233.74	234.67	233.4	233.8821	2226702.0
2021-03-09 10:30:00	MSFT	Stock	233.87	234.34	233.35	233.47	1725373.0
2021-03-09 11:00:00	MSFT	Stock	233.46	233.92	232.9	233.51	1024406.0
2021-03-09 11:30:00	MSFT	Stock	233.51	233.81	232.56	232.9199	1063105.0
2021-03-09 12:00:00	MSFT	Stock	232.92	234.33	232.84	234.2103	891016.0
2021-03-09 12:30:00	MSFT	Stock	234.22	234.42	233.79	233.82	886988.0

> showing 50 of 118,264 rows — these rows as CSV

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