PREVIEW / stock_30min / 2020-02-04

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-02-04.parquet
  size:    1.8 MB
  rows:    88,902
  symbols: 2,442

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-02-04 04:00:00	AAPL	Stock	78.09	78.3125	78.075	78.2975	59576.0
2020-02-04 04:30:00	AAPL	Stock	78.39	78.61	78.3375	78.575	28332.0
2020-02-04 05:00:00	AAPL	Stock	78.5975	78.6	78.4775	78.5175	18004.0
2020-02-04 05:30:00	AAPL	Stock	78.525	78.525	78.45	78.4625	47704.0
2020-02-04 06:00:00	AAPL	Stock	78.3875	78.4725	78.3775	78.45	21576.0
2020-02-04 06:30:00	AAPL	Stock	78.4375	78.5625	78.4375	78.5625	27416.0
2020-02-04 07:00:00	AAPL	Stock	78.515	78.55	78.38	78.535	245532.0
2020-02-04 07:30:00	AAPL	Stock	78.5375	78.9625	78.5375	78.9375	336040.0
2020-02-04 08:00:00	AAPL	Stock	78.925	78.97	77.3575	78.8375	584072.0
2020-02-04 08:30:00	AAPL	Stock	78.85	78.885	77.165	78.845	384824.0
2020-02-04 09:00:00	AAPL	Stock	78.8025	78.89	78.675	78.8625	505000.0
2020-02-04 09:30:00	AAPL	Stock	78.8275	79.215	78.4085	78.595	19718408.0
2020-02-04 10:00:00	AAPL	Stock	78.6	79.0975	78.45	79.0575	9963404.0
2020-02-04 10:30:00	AAPL	Stock	79.0638	79.3775	79.03	79.37	10621472.0
2020-02-04 11:00:00	AAPL	Stock	79.37	79.58	79.2832	79.521	6508464.0
2020-02-04 11:30:00	AAPL	Stock	79.5225	79.88	79.4828	79.6	9725544.0
2020-02-04 12:00:00	AAPL	Stock	79.6062	79.61	79.345	79.4088	5551500.0
2020-02-04 12:30:00	AAPL	Stock	79.4125	79.6348	79.3325	79.5875	4246208.0
2020-02-04 13:00:00	AAPL	Stock	79.59	79.66	79.4575	79.5725	3884360.0
2020-02-04 13:30:00	AAPL	Stock	79.5725	79.8475	79.565	79.8175	3867412.0
2020-02-04 14:00:00	AAPL	Stock	79.82	79.91	79.7225	79.7225	3883728.0
2020-02-04 14:30:00	AAPL	Stock	79.7225	79.84	79.655	79.7175	3703884.0
2020-02-04 15:00:00	AAPL	Stock	79.7175	79.7825	79.5825	79.6425	5194160.0
2020-02-04 15:30:00	AAPL	Stock	79.6425	79.7825	79.3575	79.715	11850980.0
2020-02-04 16:00:00	AAPL	Stock	79.715	79.815	79.65	79.8125	9122548.0
2020-02-04 16:30:00	AAPL	Stock	79.825	79.9125	79.7125	79.8275	1423828.0
2020-02-04 17:00:00	AAPL	Stock	79.825	79.855	79.8125	79.85	82700.0
2020-02-04 17:30:00	AAPL	Stock	79.8625	79.8725	79.825	79.8375	49900.0
2020-02-04 18:00:00	AAPL	Stock	79.8325	79.845	79.765	79.8125	77420.0
2020-02-04 18:30:00	AAPL	Stock	79.825	79.825	79.515	79.515	80512.0
2020-02-04 19:00:00	AAPL	Stock	79.545	79.725	79.5075	79.625	44876.0
2020-02-04 19:30:00	AAPL	Stock	79.6225	79.6225	79.4375	79.45	115468.0
2020-02-04 04:00:00	MSFT	Stock	176.15	177.21	176.15	176.8	15155.0
2020-02-04 04:30:00	MSFT	Stock	176.9	177.24	176.85	177.24	8415.0
2020-02-04 05:00:00	MSFT	Stock	177.2	177.2	176.69	176.89	5312.0
2020-02-04 05:30:00	MSFT	Stock	176.86	176.95	176.67	176.67	3862.0
2020-02-04 06:00:00	MSFT	Stock	176.87	176.94	176.8	176.88	4939.0
2020-02-04 06:30:00	MSFT	Stock	176.88	176.88	176.81	176.81	342.0
2020-02-04 07:00:00	MSFT	Stock	176.82	176.9	176.43	176.83	39675.0
2020-02-04 07:30:00	MSFT	Stock	176.89	177.05	176.72	176.9	41047.0
2020-02-04 08:00:00	MSFT	Stock	176.64	177.046	174.38	177.02	87784.0
2020-02-04 08:30:00	MSFT	Stock	177.021	177.16	174.38	177.08	551180.0
2020-02-04 09:00:00	MSFT	Stock	177.06	177.15	176.58	177.13	82075.0
2020-02-04 09:30:00	MSFT	Stock	177.13	177.67	176.31	177.58	4136302.0
2020-02-04 10:00:00	MSFT	Stock	177.62	178.75	177.47	178.74	2446999.0
2020-02-04 10:30:00	MSFT	Stock	178.74	180.0	178.675	179.06	3060456.0
2020-02-04 11:00:00	MSFT	Stock	179.06	179.97	179.05	179.671	1823013.0
2020-02-04 11:30:00	MSFT	Stock	179.68	180.64	179.68	180.07	2121980.0
2020-02-04 12:00:00	MSFT	Stock	180.061	180.28	179.78	179.94	1453359.0
2020-02-04 12:30:00	MSFT	Stock	179.95	179.99	179.79	179.83	825868.0

> showing 50 of 88,902 rows — these rows as CSV

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