PREVIEW / stock_30min / 2020-02-13

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-02-13.parquet
  size:    1.8 MB
  rows:    85,886
  symbols: 2,412

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-13 04:00:00	AAPL	Stock	81.04	81.1	80.8225	80.8225	48680.0
2020-02-13 04:30:00	AAPL	Stock	80.835	80.84	80.6	80.72	22232.0
2020-02-13 05:00:00	AAPL	Stock	80.65	80.725	80.36	80.7	29920.0
2020-02-13 05:30:00	AAPL	Stock	80.675	80.6875	80.5525	80.6	11988.0
2020-02-13 06:00:00	AAPL	Stock	80.6	80.6	80.5	80.525	12916.0
2020-02-13 06:30:00	AAPL	Stock	80.53	81.0	80.525	80.775	75952.0
2020-02-13 07:00:00	AAPL	Stock	80.785	80.9925	80.675	80.775	406664.0
2020-02-13 07:30:00	AAPL	Stock	80.7675	80.8475	80.59	80.825	270136.0
2020-02-13 08:00:00	AAPL	Stock	80.825	81.045	80.6	80.9625	660624.0
2020-02-13 08:30:00	AAPL	Stock	80.9625	81.0875	80.8075	80.9675	564712.0
2020-02-13 09:00:00	AAPL	Stock	80.9675	81.1	80.86	81.0975	560108.0
2020-02-13 09:30:00	AAPL	Stock	81.0625	81.49	80.8375	81.157	15538924.0
2020-02-13 10:00:00	AAPL	Stock	81.1588	81.3175	80.895	80.9975	8477968.0
2020-02-13 10:30:00	AAPL	Stock	80.9975	81.3725	80.885	81.3325	7095932.0
2020-02-13 11:00:00	AAPL	Stock	81.335	81.4325	81.245	81.325	4759016.0
2020-02-13 11:30:00	AAPL	Stock	81.3225	81.4058	81.1875	81.2475	3553388.0
2020-02-13 12:00:00	AAPL	Stock	81.245	81.555	81.23	81.3985	4525440.0
2020-02-13 12:30:00	AAPL	Stock	81.3975	81.45	81.0975	81.155	3375976.0
2020-02-13 13:00:00	AAPL	Stock	81.1625	81.3475	81.1	81.3125	3595896.0
2020-02-13 13:30:00	AAPL	Stock	81.3075	81.52	81.2575	81.4375	3176664.0
2020-02-13 14:00:00	AAPL	Stock	81.44	81.5525	81.2875	81.375	3247976.0
2020-02-13 14:30:00	AAPL	Stock	81.3875	81.545	81.3775	81.5075	2598496.0
2020-02-13 15:00:00	AAPL	Stock	81.5092	81.545	81.215	81.3037	3707488.0
2020-02-13 15:30:00	AAPL	Stock	81.305	81.325	81.107	81.2275	5884400.0
2020-02-13 16:00:00	AAPL	Stock	81.2175	81.3725	81.2175	81.28	6106252.0
2020-02-13 16:30:00	AAPL	Stock	81.3025	81.3875	81.2175	81.3525	107844.0
2020-02-13 17:00:00	AAPL	Stock	81.3525	81.3725	81.275	81.31	22924.0
2020-02-13 17:30:00	AAPL	Stock	81.35	81.385	81.275	81.385	44552.0
2020-02-13 18:00:00	AAPL	Stock	81.385	81.385	81.265	81.265	31632.0
2020-02-13 18:30:00	AAPL	Stock	81.3125	81.3125	81.175	81.1875	97824.0
2020-02-13 19:00:00	AAPL	Stock	81.2375	81.2375	81.125	81.125	38452.0
2020-02-13 19:30:00	AAPL	Stock	81.0825	81.275	81.0825	81.225	56544.0
2020-02-13 04:00:00	MSFT	Stock	183.2	183.2	182.84	182.95	2093.0
2020-02-13 04:30:00	MSFT	Stock	182.95	182.95	182.84	182.84	2855.0
2020-02-13 05:00:00	MSFT	Stock	182.63	182.86	182.21	182.86	5406.0
2020-02-13 05:30:00	MSFT	Stock	182.7	182.78	182.58	182.73	1040.0
2020-02-13 06:00:00	MSFT	Stock	182.63	182.78	182.55	182.75	1303.0
2020-02-13 06:30:00	MSFT	Stock	182.6	183.22	182.55	182.91	9979.0
2020-02-13 07:00:00	MSFT	Stock	183.0	183.15	182.5	182.55	29683.0
2020-02-13 07:30:00	MSFT	Stock	182.62	182.93	182.23	182.75	46421.0
2020-02-13 08:00:00	MSFT	Stock	182.95	183.797	182.31	183.48	81113.0
2020-02-13 08:30:00	MSFT	Stock	183.57	183.7	183.03	183.5	31823.0
2020-02-13 09:00:00	MSFT	Stock	183.45	183.5	182.9	183.1	71523.0
2020-02-13 09:30:00	MSFT	Stock	183.1	185.17	182.872	184.47	3632421.0
2020-02-13 10:00:00	MSFT	Stock	184.48	184.74	183.8	184.545	1719440.0
2020-02-13 10:30:00	MSFT	Stock	184.53	185.58	184.23	185.53	1666306.0
2020-02-13 11:00:00	MSFT	Stock	185.52	186.23	185.16	185.491	2301113.0
2020-02-13 11:30:00	MSFT	Stock	185.49	186.0	185.1	185.325	1550112.0
2020-02-13 12:00:00	MSFT	Stock	185.32	185.6	185.0	185.31	1266541.0
2020-02-13 12:30:00	MSFT	Stock	185.31	185.35	184.33	184.36	1050665.0

> showing 50 of 85,886 rows — these rows as CSV

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