PREVIEW / stock_30min / 2018-10-24

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-10-24.parquet
  size:    1.7 MB
  rows:    84,823
  symbols: 2,777

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
2018-10-24 04:00:00	AAPL	Stock	55.2575	55.49	55.13	55.19	19412.0
2018-10-24 04:30:00	AAPL	Stock	55.19	55.19	55.1625	55.1625	8288.0
2018-10-24 05:00:00	AAPL	Stock	55.055	55.225	55.055	55.225	7320.0
2018-10-24 05:30:00	AAPL	Stock	55.25	55.25	55.225	55.225	5324.0
2018-10-24 06:00:00	AAPL	Stock	55.325	55.35	55.325	55.325	14048.0
2018-10-24 06:30:00	AAPL	Stock	55.3625	55.395	55.2625	55.395	33204.0
2018-10-24 07:00:00	AAPL	Stock	55.3975	55.5925	55.375	55.545	167500.0
2018-10-24 07:30:00	AAPL	Stock	55.55	55.8075	55.55	55.8	245684.0
2018-10-24 08:00:00	AAPL	Stock	55.7	55.8125	55.375	55.6875	315224.0
2018-10-24 08:30:00	AAPL	Stock	55.7225	55.82	55.5725	55.79	271136.0
2018-10-24 09:00:00	AAPL	Stock	55.775	55.7925	55.6275	55.65	312016.0
2018-10-24 09:30:00	AAPL	Stock	55.63	56.0575	55.28	55.4875	19648944.0
2018-10-24 10:00:00	AAPL	Stock	55.495	55.575	55.1725	55.2625	10001192.0
2018-10-24 10:30:00	AAPL	Stock	55.2725	55.3925	55.1275	55.135	6325492.0
2018-10-24 11:00:00	AAPL	Stock	55.1375	55.23	54.73	54.8095	8910568.0
2018-10-24 11:30:00	AAPL	Stock	54.815	55.4175	54.74	55.385	8289152.0
2018-10-24 12:00:00	AAPL	Stock	55.3825	55.415	55.1725	55.295	5207052.0
2018-10-24 12:30:00	AAPL	Stock	55.29	55.36	55.035	55.3275	4297444.0
2018-10-24 13:00:00	AAPL	Stock	55.3125	55.32	54.7775	54.82	6870452.0
2018-10-24 13:30:00	AAPL	Stock	54.8225	55.005	54.6875	54.785	6501608.0
2018-10-24 14:00:00	AAPL	Stock	54.7802	55.175	54.6475	55.115	7448732.0
2018-10-24 14:30:00	AAPL	Stock	55.1138	55.22	54.77	54.9	5415772.0
2018-10-24 15:00:00	AAPL	Stock	54.9125	54.915	54.4175	54.445	8960332.0
2018-10-24 15:30:00	AAPL	Stock	54.44	54.5625	53.635	53.77	22155652.0
2018-10-24 16:00:00	AAPL	Stock	53.7775	54.225	53.735	54.1625	12412716.0
2018-10-24 16:30:00	AAPL	Stock	54.2125	54.3	54.125	54.255	221356.0
2018-10-24 17:00:00	AAPL	Stock	54.25	54.2875	53.7725	54.175	179952.0
2018-10-24 17:30:00	AAPL	Stock	54.15	54.25	54.125	54.25	78248.0
2018-10-24 18:00:00	AAPL	Stock	54.2325	54.25	54.075	54.175	104364.0
2018-10-24 18:30:00	AAPL	Stock	54.1875	54.225	54.1375	54.2125	71100.0
2018-10-24 19:00:00	AAPL	Stock	54.215	54.2425	54.175	54.1875	49300.0
2018-10-24 19:30:00	AAPL	Stock	54.1875	54.245	54.0	54.245	133120.0
2018-10-24 04:00:00	MSFT	Stock	107.9	107.9	107.59	107.59	1238.0
2018-10-24 04:30:00	MSFT	Stock	107.14	107.14	107.0	107.0	3430.0
2018-10-24 05:00:00	MSFT	Stock	107.31	107.31	107.31	107.31	963.0
2018-10-24 05:30:00	MSFT	Stock	107.26	107.46	107.26	107.46	687.0
2018-10-24 06:00:00	MSFT	Stock	107.41	107.48	107.32	107.48	592.0
2018-10-24 06:30:00	MSFT	Stock	107.5	107.67	107.5	107.67	500.0
2018-10-24 07:00:00	MSFT	Stock	107.73	108.07	107.72	108.0	13133.0
2018-10-24 07:30:00	MSFT	Stock	108.07	108.9	108.07	108.85	25818.0
2018-10-24 08:00:00	MSFT	Stock	108.63	108.96	107.75	108.58	83189.0
2018-10-24 08:30:00	MSFT	Stock	108.6	108.8	108.4	108.8	20559.0
2018-10-24 09:00:00	MSFT	Stock	108.75	108.858	108.4	108.4	43893.0
2018-10-24 09:30:00	MSFT	Stock	108.4	108.49	106.76	106.995	3732744.0
2018-10-24 10:00:00	MSFT	Stock	106.99	107.55	106.56	106.6	3331805.0
2018-10-24 10:30:00	MSFT	Stock	106.6	107.13	106.272	106.62	2319016.0
2018-10-24 11:00:00	MSFT	Stock	106.63	106.83	105.04	105.075	3747256.0
2018-10-24 11:30:00	MSFT	Stock	105.08	106.34	104.815	106.055	3676056.0
2018-10-24 12:00:00	MSFT	Stock	106.05	106.23	105.53	105.61	2581953.0
2018-10-24 12:30:00	MSFT	Stock	105.61	105.99	105.32	105.94	1409291.0

> showing 50 of 84,823 rows — these rows as CSV

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