PREVIEW / stock_30min / 2020-08-12

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-08-12.parquet
  size:    1.9 MB
  rows:    97,525
  symbols: 2,434

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-12 04:00:00	AAPL	Stock	110.35	110.565	110.3475	110.5375	10140.0
2020-08-12 04:30:00	AAPL	Stock	110.55	110.655	110.55	110.655	2000.0
2020-08-12 05:00:00	AAPL	Stock	110.625	110.625	110.55	110.55	8248.0
2020-08-12 05:30:00	AAPL	Stock	110.5775	110.6075	110.545	110.545	1212.0
2020-08-12 06:00:00	AAPL	Stock	110.515	110.71	110.475	110.4875	36252.0
2020-08-12 06:30:00	AAPL	Stock	110.485	110.6175	110.485	110.6175	6168.0
2020-08-12 07:00:00	AAPL	Stock	110.615	110.8025	110.4525	110.57	191980.0
2020-08-12 07:30:00	AAPL	Stock	110.675	110.815	110.6025	110.625	180656.0
2020-08-12 08:00:00	AAPL	Stock	110.4605	110.825	109.6475	110.8	299624.0
2020-08-12 08:30:00	AAPL	Stock	110.8	110.8	110.29	110.55	330856.0
2020-08-12 09:00:00	AAPL	Stock	110.525	110.575	110.29	110.4375	324636.0
2020-08-12 09:30:00	AAPL	Stock	110.4375	111.395	110.2975	111.3188	19271780.0
2020-08-12 10:00:00	AAPL	Stock	111.3175	111.5325	110.9	111.34	10012700.0
2020-08-12 10:30:00	AAPL	Stock	111.3468	111.85	111.0625	111.7725	8867764.0
2020-08-12 11:00:00	AAPL	Stock	111.7675	112.295	111.598	112.1425	8614772.0
2020-08-12 11:30:00	AAPL	Stock	112.136	112.5	112.136	112.3825	7284212.0
2020-08-12 12:00:00	AAPL	Stock	112.3775	113.165	112.3575	113.0575	11673696.0
2020-08-12 12:30:00	AAPL	Stock	113.055	113.275	112.625	112.7075	9058836.0
2020-08-12 13:00:00	AAPL	Stock	112.7102	112.9225	112.28	112.3225	8352480.0
2020-08-12 13:30:00	AAPL	Stock	112.3325	113.23	112.326	113.2062	8997428.0
2020-08-12 14:00:00	AAPL	Stock	113.2048	113.275	112.95	112.955	6009560.0
2020-08-12 14:30:00	AAPL	Stock	112.9625	113.17	112.6775	112.8262	5982692.0
2020-08-12 15:00:00	AAPL	Stock	112.8325	113.115	112.65	112.9275	6398284.0
2020-08-12 15:30:00	AAPL	Stock	112.93	113.2625	112.54	113.06	11223028.0
2020-08-12 16:00:00	AAPL	Stock	113.01	113.01	112.845	112.995	7197188.0
2020-08-12 16:30:00	AAPL	Stock	112.9725	113.0125	112.9525	113.0	174484.0
2020-08-12 17:00:00	AAPL	Stock	113.01	113.0225	112.9575	112.9575	31400.0
2020-08-12 17:30:00	AAPL	Stock	112.975	112.9975	112.7	112.825	71336.0
2020-08-12 18:00:00	AAPL	Stock	112.825	112.9375	112.7375	112.9125	82424.0
2020-08-12 18:30:00	AAPL	Stock	112.9225	113.0	112.9225	112.9875	68164.0
2020-08-12 19:00:00	AAPL	Stock	112.9875	113.0025	112.9375	113.0025	53196.0
2020-08-12 19:30:00	AAPL	Stock	113.01	113.125	113.0	113.1225	96704.0
2020-08-12 04:00:00	MSFT	Stock	206.03	206.03	205.51	205.71	2110.0
2020-08-12 04:30:00	MSFT	Stock	205.75	205.93	205.66	205.93	1211.0
2020-08-12 05:00:00	MSFT	Stock	205.94	205.94	205.76	205.87	510.0
2020-08-12 05:30:00	MSFT	Stock	205.81	205.81	205.49	205.6	1562.0
2020-08-12 06:00:00	MSFT	Stock	205.61	205.86	205.51	205.51	2733.0
2020-08-12 06:30:00	MSFT	Stock	205.55	205.74	205.41	205.74	3834.0
2020-08-12 07:00:00	MSFT	Stock	205.85	205.85	204.76	205.02	24121.0
2020-08-12 07:30:00	MSFT	Stock	205.2	205.44	204.99	205.18	21396.0
2020-08-12 08:00:00	MSFT	Stock	205.18	205.8	203.88	205.19	37124.0
2020-08-12 08:30:00	MSFT	Stock	205.02	205.102	204.4	204.75	39715.0
2020-08-12 09:00:00	MSFT	Stock	204.75	205.53	204.52	205.53	56395.0
2020-08-12 09:30:00	MSFT	Stock	205.28	207.15	204.75	207.11	3003613.0
2020-08-12 10:00:00	MSFT	Stock	207.125	208.97	206.66	208.68	2010969.0
2020-08-12 10:30:00	MSFT	Stock	208.69	209.13	208.11	208.67	1990057.0
2020-08-12 11:00:00	MSFT	Stock	208.66	209.49	208.288	208.91	1242863.0
2020-08-12 11:30:00	MSFT	Stock	208.94	209.7	208.67	209.495	1169935.0
2020-08-12 12:00:00	MSFT	Stock	209.53	209.83	209.27	209.71	1145390.0
2020-08-12 12:30:00	MSFT	Stock	209.72	209.75	208.68	208.803	926386.0

> showing 50 of 97,525 rows — these rows as CSV

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