PREVIEW / stock_30min / 2020-02-10

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-02-10.parquet
  size:    1.8 MB
  rows:    86,180
  symbols: 2,428

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-10 04:00:00	AAPL	Stock	79.485	79.6575	79.485	79.65	49620.0
2020-02-10 04:30:00	AAPL	Stock	79.63	79.63	79.3875	79.3875	23400.0
2020-02-10 05:00:00	AAPL	Stock	79.3	79.3725	79.125	79.315	12148.0
2020-02-10 05:30:00	AAPL	Stock	79.3425	79.4575	79.25	79.35	44512.0
2020-02-10 06:00:00	AAPL	Stock	79.3875	79.5125	79.35	79.5075	28992.0
2020-02-10 06:30:00	AAPL	Stock	79.5075	79.625	79.5	79.5225	42736.0
2020-02-10 07:00:00	AAPL	Stock	79.56	79.56	79.05	79.25	209756.0
2020-02-10 07:30:00	AAPL	Stock	79.25	79.375	79.1125	79.2	229576.0
2020-02-10 08:00:00	AAPL	Stock	79.2	80.2075	79.0375	79.15	510004.0
2020-02-10 08:30:00	AAPL	Stock	79.165	79.1675	78.93	78.9375	490544.0
2020-02-10 09:00:00	AAPL	Stock	78.93	78.955	78.525	78.555	647608.0
2020-02-10 09:30:00	AAPL	Stock	78.545	79.7375	78.4625	79.5625	19696580.0
2020-02-10 10:00:00	AAPL	Stock	79.5625	79.6475	79.1475	79.5608	8336224.0
2020-02-10 10:30:00	AAPL	Stock	79.565	80.015	79.4875	79.7358	8700944.0
2020-02-10 11:00:00	AAPL	Stock	79.7292	80.0625	79.7292	79.9625	5349472.0
2020-02-10 11:30:00	AAPL	Stock	79.955	80.0315	79.7	79.725	4792904.0
2020-02-10 12:00:00	AAPL	Stock	79.7268	79.82	79.5375	79.8028	4022600.0
2020-02-10 12:30:00	AAPL	Stock	79.8095	79.87	79.6825	79.8462	2362188.0
2020-02-10 13:00:00	AAPL	Stock	79.8462	80.0	79.825	79.915	2583980.0
2020-02-10 13:30:00	AAPL	Stock	79.91	79.9825	79.81	79.84	2164708.0
2020-02-10 14:00:00	AAPL	Stock	79.84	79.9875	79.7525	79.962	2320300.0
2020-02-10 14:30:00	AAPL	Stock	79.9645	80.1925	79.8625	80.164	3955968.0
2020-02-10 15:00:00	AAPL	Stock	80.1612	80.3325	80.14	80.317	5242672.0
2020-02-10 15:30:00	AAPL	Stock	80.3175	80.385	80.1375	80.385	8564648.0
2020-02-10 16:00:00	AAPL	Stock	80.385	80.4475	80.25	80.25	12500672.0
2020-02-10 16:30:00	AAPL	Stock	80.25	80.3875	80.1625	80.2525	49044.0
2020-02-10 17:00:00	AAPL	Stock	80.2625	80.3	80.2525	80.27	32292.0
2020-02-10 17:30:00	AAPL	Stock	80.2625	80.27	80.15	80.15	49512.0
2020-02-10 18:00:00	AAPL	Stock	80.155	80.225	80.1425	80.225	40780.0
2020-02-10 18:30:00	AAPL	Stock	80.225	80.2375	80.2025	80.2375	28084.0
2020-02-10 19:00:00	AAPL	Stock	80.225	80.305	80.125	80.3	60868.0
2020-02-10 19:30:00	AAPL	Stock	80.285	80.305	80.1875	80.225	103684.0
2020-02-10 04:00:00	MSFT	Stock	183.75	184.44	183.75	184.33	2131.0
2020-02-10 04:30:00	MSFT	Stock	184.35	184.35	184.1	184.2	2892.0
2020-02-10 05:00:00	MSFT	Stock	183.94	184.14	183.87	184.1	3575.0
2020-02-10 05:30:00	MSFT	Stock	184.33	184.45	184.33	184.45	410.0
2020-02-10 06:00:00	MSFT	Stock	184.31	184.31	184.3	184.3	400.0
2020-02-10 06:30:00	MSFT	Stock	184.28	184.5	184.28	184.4	2002.0
2020-02-10 07:00:00	MSFT	Stock	184.47	184.5	184.1	184.17	12584.0
2020-02-10 07:30:00	MSFT	Stock	184.2	184.3	184.13	184.25	7291.0
2020-02-10 08:00:00	MSFT	Stock	184.445	184.45	183.92	184.1	54993.0
2020-02-10 08:30:00	MSFT	Stock	184.183	184.19	183.8	183.82	32112.0
2020-02-10 09:00:00	MSFT	Stock	183.92	183.99	183.5	183.5	42478.0
2020-02-10 09:30:00	MSFT	Stock	183.51	184.84	183.25	184.78	3448681.0
2020-02-10 10:00:00	MSFT	Stock	184.79	186.22	184.58	186.22	2891029.0
2020-02-10 10:30:00	MSFT	Stock	186.23	187.3	185.77	186.05	3790403.0
2020-02-10 11:00:00	MSFT	Stock	186.045	186.78	186.045	186.68	1479620.0
2020-02-10 11:30:00	MSFT	Stock	186.685	187.25	186.68	187.14	1645957.0
2020-02-10 12:00:00	MSFT	Stock	187.135	187.135	186.205	186.34	1402606.0
2020-02-10 12:30:00	MSFT	Stock	186.34	186.67	186.2	186.377	855688.0

> showing 50 of 86,180 rows — these rows as CSV

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