PREVIEW / stock_30min / 2020-08-24

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-08-24.parquet
  size:    2.0 MB
  rows:    99,127
  symbols: 2,454

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-08-24 04:00:00	AAPL	Stock	126.525	126.75	126.1275	126.425	148652.0
2020-08-24 04:30:00	AAPL	Stock	126.4	127.15	126.25	126.99	71332.0
2020-08-24 05:00:00	AAPL	Stock	126.95	127.04	126.58	126.58	48980.0
2020-08-24 05:30:00	AAPL	Stock	126.6025	126.82	126.5575	126.82	38132.0
2020-08-24 06:00:00	AAPL	Stock	126.875	126.875	126.54	126.8075	15280.0
2020-08-24 06:30:00	AAPL	Stock	126.78	127.4	126.775	127.225	134084.0
2020-08-24 07:00:00	AAPL	Stock	127.25	128.3	127.05	127.795	1414200.0
2020-08-24 07:30:00	AAPL	Stock	127.7975	128.575	127.775	128.4725	817928.0
2020-08-24 08:00:00	AAPL	Stock	128.4725	128.875	126.4725	128.625	1966704.0
2020-08-24 08:30:00	AAPL	Stock	128.6625	128.695	128.1875	128.1925	1205412.0
2020-08-24 09:00:00	AAPL	Stock	128.1875	128.995	128.025	128.6975	1814596.0
2020-08-24 09:30:00	AAPL	Stock	128.695	128.785	125.56	126.8425	54515976.0
2020-08-24 10:00:00	AAPL	Stock	126.83	126.87	125.0	125.7225	29357384.0
2020-08-24 10:30:00	AAPL	Stock	125.7048	125.9425	123.9362	124.122	25246796.0
2020-08-24 11:00:00	AAPL	Stock	124.1965	126.1	123.9375	125.3375	19070664.0
2020-08-24 11:30:00	AAPL	Stock	125.335	127.1575	125.3125	127.02	16088484.0
2020-08-24 12:00:00	AAPL	Stock	127.0275	127.45	126.6375	126.925	15114316.0
2020-08-24 12:30:00	AAPL	Stock	126.925	126.975	126.06	126.2012	11635368.0
2020-08-24 13:00:00	AAPL	Stock	126.1812	127.0	126.0	126.2925	9892840.0
2020-08-24 13:30:00	AAPL	Stock	126.2928	126.6805	125.78	126.5038	9710376.0
2020-08-24 14:00:00	AAPL	Stock	126.5175	126.77	125.9175	126.0435	9950960.0
2020-08-24 14:30:00	AAPL	Stock	126.045	126.05	125.275	125.4325	11578408.0
2020-08-24 15:00:00	AAPL	Stock	125.4275	125.855	124.655	125.8065	16649352.0
2020-08-24 15:30:00	AAPL	Stock	125.8082	126.1288	125.3865	125.9475	17460432.0
2020-08-24 16:00:00	AAPL	Stock	125.92	126.3375	125.805	126.165	6734988.0
2020-08-24 16:30:00	AAPL	Stock	126.1625	126.215	125.8575	126.2125	154596.0
2020-08-24 17:00:00	AAPL	Stock	126.225	126.25	126.145	126.2125	80620.0
2020-08-24 17:30:00	AAPL	Stock	126.2075	126.2075	125.8575	126.16	57848.0
2020-08-24 18:00:00	AAPL	Stock	126.15	126.1875	126.1	126.1	70880.0
2020-08-24 18:30:00	AAPL	Stock	126.1	126.125	125.975	126.0625	116368.0
2020-08-24 19:00:00	AAPL	Stock	126.0525	126.22	126.0125	126.21	101596.0
2020-08-24 19:30:00	AAPL	Stock	126.21	126.525	126.1325	126.525	197652.0
2020-08-24 04:00:00	MSFT	Stock	215.23	215.32	215.16	215.28	2192.0
2020-08-24 04:30:00	MSFT	Stock	215.48	215.92	215.13	215.31	3674.0
2020-08-24 05:00:00	MSFT	Stock	215.66	215.66	215.0	215.2	3863.0
2020-08-24 05:30:00	MSFT	Stock	215.43	215.43	215.43	215.43	100.0
2020-08-24 06:00:00	MSFT	Stock	215.49	215.49	215.26	215.28	932.0
2020-08-24 06:30:00	MSFT	Stock	215.28	215.93	215.11	215.11	13936.0
2020-08-24 07:00:00	MSFT	Stock	215.13	215.5	214.62	215.11	24136.0
2020-08-24 07:30:00	MSFT	Stock	215.15	215.28	214.58	214.67	24325.0
2020-08-24 08:00:00	MSFT	Stock	215.164	215.433	213.55	214.73	67979.0
2020-08-24 08:30:00	MSFT	Stock	214.62	215.0	214.6	214.83	28324.0
2020-08-24 09:00:00	MSFT	Stock	214.85	215.33	214.83	214.91	56761.0
2020-08-24 09:30:00	MSFT	Stock	214.81	215.15	213.89	214.609	4286629.0
2020-08-24 10:00:00	MSFT	Stock	214.65	215.52	213.65	215.02	1953978.0
2020-08-24 10:30:00	MSFT	Stock	215.01	215.05	212.88	213.1	1688593.0
2020-08-24 11:00:00	MSFT	Stock	213.155	213.6	212.43	212.766	1210795.0
2020-08-24 11:30:00	MSFT	Stock	212.78	213.79	212.73	213.715	880023.0
2020-08-24 12:00:00	MSFT	Stock	213.705	213.96	213.12	213.175	711841.0
2020-08-24 12:30:00	MSFT	Stock	213.18	213.67	213.05	213.552	806139.0

> showing 50 of 99,127 rows — these rows as CSV

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