PREVIEW / stock_30min / 2019-03-28

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-03-28.parquet
  size:    1.7 MB
  rows:    85,465
  symbols: 2,639

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
2019-03-28 05:00:00	AAPL	Stock	47.1175	47.1175	47.1175	47.1175	804.0
2019-03-28 05:30:00	AAPL	Stock	47.1	47.1	47.07	47.07	3740.0
2019-03-28 06:00:00	AAPL	Stock	47.1225	47.1225	47.1225	47.1225	400.0
2019-03-28 06:30:00	AAPL	Stock	47.195	47.195	47.0925	47.0925	3364.0
2019-03-28 07:00:00	AAPL	Stock	47.1575	47.1575	47.0125	47.0125	59476.0
2019-03-28 07:30:00	AAPL	Stock	47.0225	47.0375	46.9625	47.0275	33648.0
2019-03-28 08:00:00	AAPL	Stock	47.0275	47.2375	46.9325	47.075	168288.0
2019-03-28 08:30:00	AAPL	Stock	47.075	47.09	46.915	47.07	156432.0
2019-03-28 09:00:00	AAPL	Stock	47.0825	47.2275	47.005	47.2275	78728.0
2019-03-28 09:30:00	AAPL	Stock	47.2325	47.3898	47.0	47.1525	10640224.0
2019-03-28 10:00:00	AAPL	Stock	47.16	47.2375	46.955	47.02	7177836.0
2019-03-28 10:30:00	AAPL	Stock	47.02	47.195	47.0075	47.1275	6595204.0
2019-03-28 11:00:00	AAPL	Stock	47.1275	47.2062	46.9975	47.0275	4889076.0
2019-03-28 11:30:00	AAPL	Stock	47.025	47.1725	46.989	47.1542	4299524.0
2019-03-28 12:00:00	AAPL	Stock	47.1525	47.2088	47.0125	47.04	3509068.0
2019-03-28 12:30:00	AAPL	Stock	47.045	47.0975	47.0025	47.0737	3001472.0
2019-03-28 13:00:00	AAPL	Stock	47.075	47.1238	47.03	47.085	2693712.0
2019-03-28 13:30:00	AAPL	Stock	47.0875	47.1025	47.0	47.03	3625072.0
2019-03-28 14:00:00	AAPL	Stock	47.03	47.0475	46.9125	46.9485	3819212.0
2019-03-28 14:30:00	AAPL	Stock	46.9475	46.975	46.8825	46.9725	3606584.0
2019-03-28 15:00:00	AAPL	Stock	46.97	47.145	46.9525	47.1075	4538544.0
2019-03-28 15:30:00	AAPL	Stock	47.1075	47.215	47.0925	47.1775	7671460.0
2019-03-28 16:00:00	AAPL	Stock	47.18	47.22	47.1325	47.185	3677796.0
2019-03-28 16:30:00	AAPL	Stock	47.2	47.2375	47.18	47.225	37936.0
2019-03-28 17:00:00	AAPL	Stock	47.225	47.225	47.22	47.22	1300.0
2019-03-28 17:30:00	AAPL	Stock	47.23	47.23	47.2	47.2	12564.0
2019-03-28 18:00:00	AAPL	Stock	47.2125	47.2375	47.2025	47.2025	10912.0
2019-03-28 18:30:00	AAPL	Stock	47.2375	47.2525	47.2125	47.2525	15044.0
2019-03-28 19:00:00	AAPL	Stock	47.215	47.375	47.215	47.3375	63556.0
2019-03-28 19:30:00	AAPL	Stock	47.345	47.3475	47.2875	47.3225	52568.0
2019-03-28 04:30:00	MSFT	Stock	117.0	117.1	117.0	117.09	550.0
2019-03-28 05:00:00	MSFT	Stock	117.15	117.15	117.12	117.12	200.0
2019-03-28 05:30:00	MSFT	Stock	117.18	117.18	117.12	117.12	1143.0
2019-03-28 06:00:00	MSFT	Stock	117.14	117.14	117.14	117.14	583.0
2019-03-28 06:30:00	MSFT	Stock	117.14	117.32	117.1	117.14	6300.0
2019-03-28 07:00:00	MSFT	Stock	117.15	117.15	116.83	116.83	5452.0
2019-03-28 07:30:00	MSFT	Stock	116.84	117.04	116.74	117.04	5200.0
2019-03-28 08:00:00	MSFT	Stock	117.14	117.25	116.8	117.04	11997.0
2019-03-28 08:30:00	MSFT	Stock	117.04	117.36	116.83	117.2	10035.0
2019-03-28 09:00:00	MSFT	Stock	117.23	117.5	117.1	117.3	20336.0
2019-03-28 09:30:00	MSFT	Stock	117.39	117.58	116.63	117.2	1913297.0
2019-03-28 10:00:00	MSFT	Stock	117.19	117.425	117.0	117.19	1138762.0
2019-03-28 10:30:00	MSFT	Stock	117.19	117.45	116.52	116.54	1240892.0
2019-03-28 11:00:00	MSFT	Stock	116.545	116.7	116.14	116.16	1430243.0
2019-03-28 11:30:00	MSFT	Stock	116.16	116.48	116.13	116.42	1474944.0
2019-03-28 12:00:00	MSFT	Stock	116.41	116.73	116.33	116.685	1019874.0
2019-03-28 12:30:00	MSFT	Stock	116.69	116.86	116.61	116.78	740095.0
2019-03-28 13:00:00	MSFT	Stock	116.79	116.9	116.715	116.87	644687.0
2019-03-28 13:30:00	MSFT	Stock	116.86	116.94	116.72	116.81	617244.0
2019-03-28 14:00:00	MSFT	Stock	116.8	116.97	116.77	116.92	587532.0

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

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